Oracle 10g 11G RAC Database Control File Creation Failed with ORA-01503, ORA-12720: operation requires database is in EXCLUSIVE mode

Error Description
Oracle RAC database control file creation failed with following error.

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


Solution Description:
Sol 1:

1. Shut down the database
2. Change cluster_database=false in init.ora file
3. Start nomount and execute the control file creation script.
Sol 2:
     alter system set cluster_database =false scope = spfile;
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google