ORA-12720 Operation Requires Database

ORA-12720 Operation Requires Database Is In EXCLUSIVE Mode

by

Today I’m trying to restore the RAC database backup in another RAC environment and after successful restoration, we tried to rename the database then we faced ORA-12720 Operation Requires Database Is In EXCLUSIVE Mode.

Ora Errors

ORA-12720: Operation Requires Database Is In EXCLUSIVE Mode

During rename database activity when we re-creating the controlfile it gives the following error message.

ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-12720: operation requires database is in EXCLUSIVE mode

ORA-12720 Operation Requires Database in exclusive mode

ORA-12720 Operation Requires Database

Solution:

Set cluster_database parameter false befor re-creating controlfile in RAC environment.
SQL> show parameter cluster_database

NAME TYPE VALUE
------------------------------------ ----------- -----------------------
cluster_database boolean TRUE
cluster_database_instances integer 2

Let’s set it false:

alter system set cluster_database='FALSE' scope=both sid='*';

SQL> show parameter cluster_database

NAME TYPE VALUE
------------------------------------ ----------- -----------------------
cluster_database boolean FALSE
cluster_database_instances integer 2

Now try to re-create controlfile, it will be created.

Note:

Same issue occur if you try to duplicate from RAC to RAC.

Read More Ora Errors Click Here

Leave a Comment