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
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/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *