Upgrade the database from 10.2.0.1.0 to 10.2.0.5.0, start the database, error: ORA-01092: Oracle routine termination, forced disconnection.
View the alert file.
ORA-00704: bootstrap process failure.
ORA-39700: database must be opened with UPGRADE option
After the database is upgraded, the data dictionary content is modified. You need to run the catalog. SQL and catproc. SQL scripts to update the data dictionary.
The solution is as follows:
SQL> startup upgrade;
SQL> @ ORACLE_HOME \ rdbms \ admin \ catupgrd. SQL;
This script will be executed for a long time. I spent 22 minutes on the VM.
Total Upgrade Time: 00:21:58
After the execution is complete, close the database and start the database in normal mode.
Run the utlrp. SQL script to re-compile some invalid objects.
SQL> startup
SQL> @ ORACLE_HOME \ rdbms \ admin \ utlrp. SQL;
...
OBJECTS WITH ERRORS
-------------------
0
...
ERRORS DURING RECOMPILATION
---------------------------
0
Upgrade complete.