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

启动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>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!