Oracle RAC 11gR2 – ORA-01102: cannot mount database in EXCLUSIVE mode

Oracle RAC 11gR2 – ORA-01102: cannot mount database in exclusive mode

In one of the customer site, I was unable to start both of the RAC instance at the same time. When 1 of the RAC instance was up, I couldn’t start the other RAC instance.

#sqlplus / as sysdba
SQL> startup;
ERROR at line 1:
ORA-01102: cannot mount database in EXCLUSIVE mode

ORA-01102 error occurs when 2 separate (Not RAC configured) Oracle instance tries to open the same database. In one of the RAC instance, one of the parameter was configured wrongly

CLUSTER_DATABASE = FALSE;

Solution;

SQL>alter system set cluster_database=TRUE scope=spfile sid='SID1';
SQL>shutdown immediate;
SQL>startup

Hope this helps.

Regards,
Wei Shan

 

 

Advertisements

3 thoughts on “Oracle RAC 11gR2 – ORA-01102: cannot mount database in EXCLUSIVE mode”

  1. I’m curious on which instance to make the change? if you DB won’t startup how could we alter the cluster_database?

    1. Hi Kevkha,

      Bring the database to mount state. Make the change on whichever instance which has the wrong configuration. In my situation, only one of the node has the issue, so I made the change on that node.

      Regards,
      WeiShan

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