HOW TO RESOLVE THE ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option

In this tutorial, we are going to learn about, “How to resolve these ORA ERRORS: ORA-01092, ORA-00704 and ORA-39700”.

I got the below type of error while startup the database. I workaround and resolved the issue.

ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

If you get this type of error in the future do follow below steps:

[oracle@oracle19c ~]$ . testdb.env
[oracle@oracle19c ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 24 10:18:22 2021

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  914358272 bytes
Fixed Size                  2930800 bytes
Variable Size             239077264 bytes
Database Buffers          666894336 bytes
Redo Buffers                5455872 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: 17462
Session ID: 355 Serial number: 8413

Step 1:

We should do shutdown the database and again startup with upgrade mode, it will take you to up the database without errors.

[oracle@oracle19c ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 24 10:18:22 2021

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup upgrade
ORACLE instance started.

Total System Global Area  914358272 bytes
Fixed Size                  2930800 bytes
Variable Size             239077264 bytes
Database Buffers          666894336 bytes
Redo Buffers                5455872 bytes
Database mounted.
Database opened.

Step 2:

Now after the database came up, Then we should run the below script as a sys user.

Connect as sys user “/ as sysdba” and execute the below SQL file into the database.

 

SQL>@/rdbms/admin/catalog.sql;

SQL>@/rdbms/admin/catproc.sql;

 

Step 3:

After completion of SQL file execution. Now we want to check the status of the database by using the below command. Then the status should be in “OPEN MIGRATE” status.

SQL> select NAME,open_mode from v$database;

 

NAME OPEN_MODE
——— ——————–
TESTDB READ WRITE

 

SQL> select instance_name, status from v$instance;

 

INSTANCE_NAME STATUS
—————- ————
testdb OPEN MIGRATE

 

Step4:

All are set then now we want to shut immediate and startup the database as normally then that old error will not come.

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup

ORACLE instance started.
Total System Global Area  914358272 bytes
Fixed Size                  2930800 bytes
Variable Size             239077264 bytes
Database Buffers          666894336 bytes
Redo Buffers                5455872 bytes
Database mounted.
Database opened.

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
——— ——————– —————-
TESTDB READ WRITE PRIMARY