ORA-00704 bootstrap process failure


After Upgrading ORACLE_HOME (from 10.2.0.1 to 10.2.0.4), I was started my database by using startup command, then got below error.

ORA-01092 oracle instance terminated. Disconnection force.


After I saw my alert log and got ORA-00704 error,


Alert Log :

Errors in file /oracle/product/db/10.2.0/dbhome/admin/test/udump/test_ora_11338.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Wed Jun 19 11:43:30 2013
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 11338
ORA-1092 signalled during: ALTER DATABASE OPEN....

Solution:

I missed to run catupgrd.sql script after upgrade, so got above errors while starting the database.

Go to ORACLE_HOME/rdbms/admin

sqlplus / as sysdba

sql>startup upgrade

sql>@catupgrd.sql 

sql>@utlrp.sql

sql>shut immediate

sql>startup