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

   啟動oracle 11g rac數據庫時出現以下錯誤,只能啟動其中一個節點,另一個節點啟動不了,可能是以前修改cluster_database這個參數引起的.在oralc rac架構這個參數必須設置為TRUE.

錯誤信息:

   ORA-01102: cannot mount database in EXCLUSIVE mode

解決方法:

rac1節點:

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節點:

[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   --沒有修改參數前報錯,修改后啟動成功

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>