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

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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;

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer