1. Error
The operating system and database are installed by the service provider. After a few months, I remembered that the database was used. The following error occurs during startup.
SQL> startup
Oracle instance started.
Total System Global Area 4932501504 bytes
Fixed Size 2103096 bytes
Variable Size 889194696 bytes
Database Buffers 4026531840 bytes
Redo Buffers 14671872 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
2. View alert. log
ORA-00704: bootstrap process failure.
ORA-39700: database must be opened with UPGRADE option
3. Check that the database version is 10.2.0.5.0. This is because they have performed database upgrades and have not executed this script.
$ ORACLE_HOME \ rdbms \ admin \ catupgrd. SQL;
4. The process is simple.
Startup upgrade;
@ $ ORACLE_HOME \ rdbms \ admin \ catupgrd. SQL;
@ $ ORACLE_HOME/rdbms/admin/utlrp. SQL; -- Re-compile the invalid object, which has little to do with this problem.
Restart Database
Shutdwon immediate;
Startup
OK