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