Ora-12720:operation requires database is in EXCLUSIVE mode

Problem

When I try to create an controlfile for a RAC database using the Controlfile Trace. I was throw with the below error message

Sql> @c.sql

CREATE controlfile Reuse DATABASE "XE1" resetlogs Force LOGGING ARCHIVELOG

*

ERROR at line 1:

Ora-01503:create Controlfile failed

Ora-12720:operation requires database is in EXCLUSIVE mode

Solution

After analyzing the issue, I found this cluster_database parameter needs to BES set as FALSE. So I am proceeding with the change.

Sql> alter system set CLUSTER_DATABASE=FALSE scope=spfile sid= ' * ';

System altered.

sql> shutdown abort;

ORACLE instance shut down.

Sql>

Sql> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit Production

With the partitioning, Real application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real application testing options

Starting the DATABASE

$sqlplus/as SYSDBA

Sql*plus:release 11.2.0.2.0 Production on Fri Nov 11 14:30:58 2011

Copyright (c) 1982, Oracle. All rights reserved.

Connected to an idle instance.

Sql> Startup Nomount

Ora-32004:obsolete or deprecated parameter (s) specified for RDBMS instance

ORACLE instance started.

Total System Global area 1.4431E+10 bytes

Fixed Size 2240272 bytes

Variable Size 3892314352 bytes

Database buffers 1.0503E+10 bytes

Redo buffers 34148352 bytes

Sql> @c.sql

Control file created.

Once the Controlfile created and open the database, I have a change of the parameter to TRUE

Sql> alter system set CLUSTER_DATABASE=TRUE scope=spfile sid= ' * ';

Once issue the command, you need to bounce the DB.

Ora-12720:operation requires database is in EXCLUSIVE mode