Sunday, October 13, 2013

ORA-01503: CREATE CONTROLFILE failed ORA-12720: operation requires database is in EXCLUSIVE mode

PROBLEM:


Create an controlfile for a RAC database using the CONTROLFILE Trace throws the below error message

SQL> @create_control.sql

CREATE CONTROLFILE REUSE SET DATABASE "DBNAME" RESETLOGS NOARCHIVELOG

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

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



SOLUTION:


cluster_database=TRUE Change this parameter to FALSE in the parameter file

or 

SQL> alter system set cluster_database=false scope=spfile; 


System altered.


SQL> shutdown immediate;

SQL> startup nomount

SQL> @create_control.sql

Control file created.


SQL> shutdown immediate;

Once the controlfile created and open the database and revert back the parameter cluster_database=TRUE in the parameter file 
 
 
SQL>startup


===============================================================================
- Reference

Recreating my controlfile [ID 735106.1]

No comments: