ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE

Mehmet Salih Deveci

5 years ago

Hi,

Sometimes You can get “ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE ” error.

Details of error are as follows.

ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE

Cause: The database was mounted for SHARED cluster access.

Action: Set the CLUSTER_DATABASE initialization parameter to FALSE and restart the server with the UPGRADE or DOWNGRADE option.

SQL> startup upgrade
ORACLE instance started.
Total System Global Area 3758096384 bytes
Fixed Size 4503952 bytes
Variable Size 3103786608 bytes
Database Buffers 637534208 bytes
Redo Buffers 12271616 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
Process ID: 10523
Session ID: 2092 Serial number: 36861

SQL>

This error is related with the RAC database and Cluster_database parameter.


SQL> show parameter cluster_database
NAME                          TYPE                VALUE
------------------------------------ ----------- ------------------------------
cluster_database               boolean            TRUE
cluster_database_instances     integer             2
SQL>

To solve this error, set the cluster_database False.

SQL> alter system set cluster_database=FALSE scope=spfile sid='*' ;
System altered.

then startup upgrade again as follows.

SQL> startup upgrade
ORACLE instance started.
Total System Global Area 3758096384 bytes
Fixed Size 4503952 bytes
Variable Size 3003123312 bytes
Database Buffers 738197504 bytes
Redo Buffers 12271616 bytes
Database mounted.
Database opened.
SQL>

Read the following post to learn detailed how to upgrade any database.

https://ittutorial.org/manual-upgrade-oracle-database-from-11-2-0-4-to-12-2-0-1-without-dbua/

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/