Oracle 11g RAC boot error ora-01102:cannot mount database in EXCLUSIVE mode

The following error occurred while starting the Oracle 11g RAC database, only one of the nodes could be started, and the other node could not start, possibly due to a previous modification of the Cluster_database parameter. This parameter must be set to true in the Oralc RAC schema.

Error message:

ora-01102:cannot Mount Database in EXCLUSIVE mode

Workaround:

RAC1 node:

Sql> Show parameter cluster_database;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Cluster_database Boolean FALSE

Cluster_database_instances Integer 1

Sql> alter system set CLUSTER_DATABASE=TRUE Scope=spfile;

System altered.

sql> shutdown Immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

Sql> Startup

ORACLE instance started.

Total System Global area 830930944 bytes

Fixed Size 2257800 bytes

Variable Size 566234232 bytes

Database buffers 260046848 bytes

Redo buffers 2392064 bytes

Database mounted.

Database opened.

Sql> select Open_mode from V$database;

Open_mode

--------------------

READ WRITE

Sql> Show parameter cluster_database;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Cluster_database Boolean TRUE

Cluster_database_instances Integer 2

Sql>

RAC2 node:

[Email protected] ~]$ Sqlplus/as SYSDBA

Sql*plus:release 11.2.0.4.0 Production on Thu Sep 29 10:14:16 2016

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

Connected to an idle instance.

Sql> Startup

Ora-01102:cannot mount Database in EXCLUSIVE mode --error before modifying parameters, start successful after modification

Sql> Startup

ORACLE instance started.

Total System Global area 830930944 bytes

Fixed Size 2257800 bytes

Variable Size 599788664 bytes

Database buffers 226492416 bytes

Redo buffers 2392064 bytes

Database mounted.

Database opened.

Sql> select Open_mode from V$database;

Open_mode

--------------------

READ WRITE

Sql> Show parameter cluster_database;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Cluster_database Boolean TRUE

Cluster_database_instances Integer 2

Sql>

This article is from the "Days Together" blog, please be sure to keep this source http://tongcheng.blog.51cto.com/6214144/1857642

Oracle 11g RAC boot error ora-01102:cannot mount database in EXCLUSIVE mode