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

8 comments:

  1. thankyou sir for good explanation .... sir i need more issues where u came across .. Thankyou

    ReplyDelete
  2. Hi
    We have two oracle homes(11 and 10) and when i tried to open a 10 ora home db i am getting this error. Please let me know from which ora home(10 or 11) i need to run the above script
    thanks
    kk

    ReplyDelete
  3. hi ram,

    I have faced the issue after upgrade from 10.2.0.1 to 10.2.0.4. In your case, its different set the correct ORACLE_HOME in oratab with right dbname.

    ReplyDelete

  4. SP2-0310: unable to open file "catupgrd.sql"
    what is the solution for this??

    ReplyDelete