oracle 11g rac啟動報錯ORA-01102: cannot mount database in EXCLUSIVE mode

   啟動oracle 11g rac數(shù)據(jù)庫時出現(xiàn)以下錯誤,只能啟動其中一個節(jié)點,另一個節(jié)點啟動不了,可能是以前修改cluster_database這個參數(shù)引起的.在oralc rac架構(gòu)這個參數(shù)必須設(shè)置為TRUE.

錯誤信息:

   ORA-01102: cannot mount database in EXCLUSIVE mode

解決方法:

rac1節(jié)點:

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節(jié)點:

[oracle@rac2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 29 10:14:16 2016

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

Connected to an idle instance.

SQL> startup

ORA-01102: cannot mount database in EXCLUSIVE mode   --沒有修改參數(shù)前報錯,修改后啟動成功

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>