Home > TroubleShooting > ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

Today, I upgrade a database from 11.1.06 to 11.1.0.7. When I startup with upgrade option, the message returned as below

SQL> alter database open UPGRADE;
alter database open UPGRADE
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 4060
Session ID: 170 Serial number: 5

After looking at alert.log, I found the following messages

*** 2011-03-09 17:38:41.390
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

 

Fixed

Finally, I found that the database must be mounted in exclusive mode first and alter open with upgrade. The problem was fixed as procedure below

SQL> startup nomount;
ORACLE instance started.

SQL> alter system set cluster_database=false scope=spfile;

System altered.

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup mount exclusive
ORACLE instance started.

SQL> alter database open upgrade;

About these ads
Categories: TroubleShooting
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: