IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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 11.2.0.1 ORACLE_HOME rather than 11.2.0.2 ORACLE_HOME during the upgrade. Hence, the wrong version of sqlplus was invoked
PATH=/oracle/product/11.2.0/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/oracle/product/11.2.0/bin:/sbin:/usr/sbin:/home/oracle/bin:/home/oracle/bin:/oracle/product/11.2.0.2//bin:/usr/lib64/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/usr/java
sqlplus banner follows (note that sqlplus release is 11.2.0.1.0 whereas the database version is 11.2.0.2.0)
$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 15 21:10:55 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Release 11.2.0.2.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
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
