Shulou(Shulou.com)05/31 Report--

This article mainly explains "Oracle 11g RAC error ORA-01102: cannot mount database in EXCLUSIVE mode", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Oracle 11g RAC Error ORA-01102: Cannot mount database in EXCLUSIVE mode

The following error occurred while starting the Oracle 11g RAC database. Only one of the nodes can be started, and the other node cannot be started. This may be caused by previously modifying the cluster_database parameter. This parameter must be set to TRUE in Oracle RAC schema.

Error message:

ORA-01102: cannot mount database in EXCLUSIVE mode

Solution:

rac1 node:

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 node:

[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 --Error reported before modifying parameters, startup succeeded after modification

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>

At this point, I believe that everyone has a deeper understanding of "Oracle 11g RAC error ORA-01102: cannot mount database in EXCLUSIVE mode". Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.