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 forced
ORA-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