oracle 11g rac启动报错ORA-01102: cannot mount database in EXCLUSIVE mode

错误信息:

   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>

本文出自 “一起走过的日子” 博客，请务必保留此出处http://tongcheng.blog.51cto.com/6214144/1857642

oracle 11g rac启动报错ORA-01102: cannot mount database in EXCLUSIVE mode

标签：ora-01102: cannot mount database in exclusive mode