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

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

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/