ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
August 21, 2020 Leave a comment
Problem:
In cluster environment, I was not able to start database in upgrade mode:
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 1996486272 bytes
Fixed Size 8898176 bytes
Variable Size 704643072 bytes
Database Buffers 1275068416 bytes
Redo Buffers 7876608 bytes
Database mounted.
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
The following also did not work:
SQL> startup mount exclusive
ORACLE instance started.
Total System Global Area 1996486272 bytes
Fixed Size 8898176 bytes
Variable Size 704643072 bytes
Database Buffers 1275068416 bytes
Redo Buffers 7876608 bytes
Database mounted.
SQL> alter database open upgrade;
alter database open upgrade
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
Solution:
Change parameter cluster_database to FALSE, and startup in upgrade mode:
$ sqlplus / as sysdba
SQL> startup nomount;
SQL> alter system set cluster_database=FALSE scope=spfile sid='*';
SQL> shutdown immediate;
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 1996486272 bytes
Fixed Size 8898176 bytes
Variable Size 704643072 bytes
Database Buffers 1275068416 bytes
Redo Buffers 7876608 bytes
Database mounted.
Database opened.
After finishing your work, don’t forget to return cluster_database parameter to TRUE and restart your database:
SQL> alter system set cluster_database=TRUE scope=spfile sid='*';
