ORA-12720: operation requires database is in EXCLUSIVE mode

When I try to create a controlfile for a RAC database using the CONTROLFILE Trace. It threw the below error message:

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='*';
shutdown immdeiate;
startup nomount;

re-run script for controlfile creation

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

Control file created.

after that change parameter with its old value

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

and restart database.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s