ORA-01092,ORA-00704,ORA-39700

SCENARIO

Few weeks back a DBA has created database manually and started it till mount mode. Later on when he tried to open database it resulted in ORA-01092, ORA-00704, ORA-39700 error pasted below.

ERROR

ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

Process ID: 64689

Session ID: 1144 Serial number: 3

CAUSE

ORA-01092, ORA-00704, ORA-39700 is primarily caused due to inappropriate environment variables set and PATH variable pointing to old ORACLE_HOME/bin rather than new ORACLE_HOME/bin. Hence, the wrong version of sqlplus was invoked

SOLUTION

ORA-01092, ORA-00704, ORA-39700 can be resolved by setting correct environment variable like ORACLE_HOME (new), PATH (new ORACLE_HOME/bin) and rerun catupgrd.sql.

SQL> startup upgrade;

ORACLE instance started.

Total System Global Area  680607744 bytes

Fixed Size                  2256352 bytes

Variable Size             427819552 bytes

Database Buffers          247463936 bytes

Redo Buffers                3067904 bytes

Database mounted.

Database opened.

SQL>

SQL> @/u01/app/oracle/product/11.2.0/db_home1/rdbms/admin/catupgrd.sql;

SQL>

SQL> shutdown immediate;

SQL> startup;

SQL>

SQL> select name, open_mode, database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE

--------- -------------------- ----------------

ORA11G    READ WRITE           PRIMARY

DISCLAIMER

The views expressed here are subjected to www.RAEY.in business environment. Suggestions and comments will be highly appreciated.