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]
