I got ” ORA-00704: bootstrap process failure ” error in Oracle database.
ORA-00704: bootstrap process failure
Details of error are as follows.
ORA-00704: bootstrap process failure Cause: An error occurred when processing bootstrap data. Refer to the accompanying messages for more information about the cause of the problem. Action: Correct the problems mentioned in the other messages. If the problem persists, contact customer support.
While opening a database, the following errors are observed in the alert log ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option The following is observed in the sqlplus session SQL> startup; ORACLE instance started. Total System Global Area 1954160640 bytes Fixed Size 2227752 bytes Variable Size 1325400536 bytes Database Buffers 620756992 bytes Redo Buffers 5775360 bytes Database mounted. ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option Process ID: 22861 Session ID: 1705 Serial number: 5
bootstrap process failure
This ORA-00704 is related with the error occurred when processing bootstrap data. Refer to the accompanying messages for more information about the cause of the problem.
Correct the problems mentioned in the other messages. If the problem persists, contact customer support.
PATH variable was pointing to 220.127.116.11 ORACLE_HOME rather than 18.104.22.168 ORACLE_HOME during the upgrade. Hence, the wrong version of sqlplus was invoked
sqlplus banner follows (note that sqlplus release is 22.214.171.124.0 whereas the database version is 126.96.36.199.0)
$ sqlplus / as sysdba SQL*Plus: Release 188.8.131.52.0 Production on Mon Aug 15 21:10:55 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Release 184.108.40.206.0 - 64bit Production Connected to an idle instance.
To solve this error, Correct the environment variables to point to the correct ORACLE_HOME, PATH etc and rerun catupgrd.sql
Another case is as follows.
After upgrade, trying to open the database fails with
ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1
1. There is a probable of this error when any unsupported operations are tried to force open the database.
2. This error can also occur when system datafile has corrupted blocks. (ORA-01578)
3. Either Bootstrap Objects are corrupted /Missing
In Oracle, Bootstrap refers to loading of metadata (data dictionary) before we OPEN the database –
If ORA-00704 is accompanied with any of the below errors
A) ORA-39700: database must be opened with UPGRADE option
Ensure that environment variables point to the correct ORACLE_HOME, PATH etc and rerun catupgrd.sql
B) ORA-00942: table or view does not exist
A Particular bootstrap object must be missing
1. Shutdown (abort) the instance and clean up any OS structures used by the instance.
2. Cleanup if any sharedmemory/semaphores exists
Use the following commands to remove the shared memory segments and semaphores owned by the Oracle user.
At the unix command prompt do the following:
a) ipcs -m
This shows the memory segments owned by the oracle user. If there are some segments owned by Oracle and related to instance which is failing to start then remove
> ipcrm -m <segment id number>
This removes the segment from memory so Oracle no longer has a hold on that piece of memory
c) ipcs -s
Check for any semaphores – Take the segment id of the correct instance which is failing to start and remove
>ipcrm -s <segment id number>
3. Retry the startup.
4. If the error persists then Restore the database from a backup taken prior to the upgrade
C) If ORA-01406: fetched column value was truncated OR any other errors,
Its possible that bootstrap objects are corrupted
Restore the database from a backup taken prior to the upgrade
Note: If the error persists follow up on the accompanying errors
519 views last month, 2 views today