Oracle 11g RAC錯誤ORA

153次閱讀

共計 2218 個字符，預計需要花費 6 分鐘才能閱讀完成。

行業資訊
數據庫
關系型數據庫
Oracle 11g RAC 錯誤 ORA-01102: cannot mount database in EXCLUSIVE mode 怎么解決

本篇內容主要講解“Oracle 11g RAC 錯誤 ORA-01102: cannot mount database in EXCLUSIVE mode 怎么解決”，感興趣的朋友不妨來看看。本文介紹的方法操作簡單快捷，實用性強。下面就讓丸趣 TV 小編來帶大家學習“Oracle 11g RAC 錯誤 ORA-01102: cannot mount database in EXCLUSIVE mode 怎么解決”吧!

啟動
Oracle
11g RAC 數據庫時出現以下錯誤。只能啟動其中一個節點, 另一個節點啟動不了。可能是以前修改 cluster_database 這個參數引起的。在 Oracle 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

到此，相信大家對“Oracle 11g RAC 錯誤 ORA-01102: cannot mount database in EXCLUSIVE mode 怎么解決”有了更深的了解，不妨來實際操作一番吧！這里是丸趣 TV 網站，更多相關內容可以進入相關頻道進行查詢，關注我們，繼續學習！

正文完