解決ASM無法啟動問題

space6212發表於2019-07-20
ASM

對RAC接觸不多,今天在測試環境啟動RAC失敗,經過一番努力,總算解決問題.下面簡單記錄一下:



啟動報錯如下所示
rac2-> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:32:57 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DG1/devdb/spfiledevdb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DG1/devdb/spfiledevdb.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL> exit
Disconnected

--檢查ASM例項執行情況
rac2-> srvctl status asm -n rac1
ASM 例項 +ASM1 正在節點 rac1 上執行。
rac2-> srvctl status asm -n rac2
ASM 例項 +ASM2 不在節點 rac2 上執行。

--可以看出,在節點2(也就是出問題的節點)上ASM例項並沒有啟動

--接著檢查ASM磁碟組
[root@rac2 ~]# /etc/init.d/oracleasm listdisks
沒有結果輸出表示ASM磁碟組沒有載入,之前配置ASM的時候已經配置了自動載入ASM,可能是因為其他原因沒有載入成功.下面手工載入:
[root@rac2 ~]# /etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration: [ OK ]
Loading module "oracleasm": [ OK ]
Mounting ASMlib driver filesystem: [ OK ]
Scanning system for ASM disks: [ OK ]
--再檢視ASM磁碟組資訊:
[root@rac2 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3

--可以看出,ASM磁碟組載入好了.


--下面要做的是啟動ASM例項
rac2-> export ORACLE_SID=+ASM2
rac2-> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:36:18 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area 92274688 bytes
Fixed Size 1217884 bytes
Variable Size 65890980 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters and Data Mining options

--啟動資料庫
rac2-> export ORACLE_SID=devdb2
rac2-> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:39:57 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 188743680 bytes
Fixed Size 1218436 bytes
Variable Size 83888252 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.


至此,例項啟動完畢.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/231499/viewspace-63796/，如需轉載，請註明出處，否則將追究法律責任。

相關文章