SQL> startup
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 2100520 bytes
Variable Size 230687448 bytes
Database Buffers 675282944 bytes
Redo Buffers 6287360 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forcedORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Solution:
After SQL> startup upgrade, run the catupgrd.sql(if you were upgrading the database). The file can be found under $ORACLE_HOME/rdbms/admin directory.
SQL> @?\rdbms\admin\catupgrd.sql
After the completion it's execution
SQL>shut immediate then
SQL>startup then run
SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql to recompile invalid database objects.
No comments:
Post a Comment