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

標籤：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節點:

[[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, 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>

本文出自 “一起走過的日子” 部落格，請務必保留此出處http://tongcheng.blog.51cto.com/6214144/1857642

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