Total Pageviews

Tuesday, June 29, 2021

Start up error after restoration in oracle 11.2.0.4

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.