Home / Errors/Workarounds10g / ORA-12720: operation requires database is in EXCLUSIVE mode

ORA-12720: operation requires database is in EXCLUSIVE mode

ERROR

CREATE CONTROLFILE .................................
   .................................................
CHARACTER SET AL32UTF8;

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

SOLUTION

SQL> alter system set cluster_database=FALSE scope=spfile sid='*';
SQL> shutdown immediate; 
SQL>startup nomount;

Now, re-run script for creating controlfile 

CREATE CONTROLFILE .................................
   .................................................
CHARACTER SET AL32UTF8;

Control file created.

Then, change parameter with its old value and restart database.

SQL>alter system set cluster_database=TRUE scope=spfile sid='*';

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleDBconfig

Manually remove ODA DB HOME

Manually remove OLD DB HOMES if odacli-delete dbhome fails Please follow the instructions below: 1. …

Leave a Reply