RAC 下使用DBCA 建立ASM出錯（ORA-15032，ORA-15063）

先說說我的系統和ORACLE版本

SQL> select * from v$version
  2  ;

BANNER
--------------------------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
[oracle@rac2 etc]$ more redhat-release
Red Hat Enterprise Linux Server release 5.3 (Tikanga)

 

以前使用的RAC+RAW的方式，現在再同樣的ORACLE使用者下面準備建立一個ASM 叢集例項，用來測試。

但是再使用DBCA 選擇ASM配置過後輸入了引數等資訊後建立的時候DBCA報錯

ORA-15032 ORA-15063

。

然後檢視了一下pfile返現ASM再兩個例項的pfile都已經建立成功，並且節點1的ASM記憶體和後臺程式都起來，然後嘗試連線到ASM例項，

SQL> shutdown abort
ASM instance shutdown

然後嘗試啟動
SQL> startup
ASM instance started

Total System Global Area   92274688 bytes
Fixed Size                  1272168 bytes
Variable Size              65836696 bytes
ASM Cache                  25165824 bytes
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "TEST"
發現確實報錯，但是我這個RAW是沒有問題，很是莫名其妙，檢視METALINK也沒有有價值的資訊。檢視磁碟組

SQL> select * from v$asm_diskgroup;

no rows selected

發現磁碟組根本沒有建立，後來我嘗試手動建立磁碟組成功了

SQL> create diskgroup TEST external redundancy disk '/dev/raw/raw12';

Diskgroup created.

沒有報錯。

然後嘗試再節點2啟動ASM例項

[oracle@rac2 dbs]$ export ORACLE_SID=+ASM2
[oracle@rac2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Apr 25 11:44:07 2011

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area   92274688 bytes
Fixed Size                  1272168 bytes
Variable Size              65836696 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted

 

發現沒有問題了。10G的ASM BUG真多我靠

最後必須要手動註冊ASM資源到OCR

 

[oracle@rac1 bdump]$ srvctl add asm -n rac1 -i +ASM1 -o /home/oracle/product/10.2.0/db
[oracle@rac1 bdump]$ srvctl add asm -n rac2 -i +ASM2 -o /home/oracle/product/10.2.0/db

 

最後重啟所有的CRS資源

[oracle@rac1 bdump]$ crs_stop -all
Attempting to stop `ora.ppzhu.dw.ppzhu1.srv` on member `rac1`
Attempting to stop `ora.rac1.gsd` on member `rac1`
Attempting to stop `ora.rac1.ons` on member `rac1`
Attempting to stop `ora.ppzhu.dw.ppzhu2.srv` on member `rac2`
Stop of `ora.ppzhu.dw.ppzhu1.srv` on member `rac1` succeeded.
Attempting to stop `ora.ppzhu.dw.cs` on member `rac2`
Attempting to stop `ora.rac2.gsd` on member `rac2`
Attempting to stop `ora.ppzhu.db` on member `rac2`
Stop of `ora.ppzhu.dw.ppzhu2.srv` on member `rac2` succeeded.
Stop of `ora.rac1.ons` on member `rac1` succeeded.
Stop of `ora.rac1.gsd` on member `rac1` succeeded.
Stop of `ora.rac2.gsd` on member `rac2` succeeded.
Stop of `ora.ppzhu.dw.cs` on member `rac2` succeeded.
Stop of `ora.ppzhu.db` on member `rac2` succeeded.
`ora.ppzhu.ppzhu2.inst` is already OFFLINE.
`ora.ppzhu.ppzhu1.inst` is already OFFLINE.
Attempting to stop `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1`
Attempting to stop `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2`
Stop of `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1` succeeded.
Attempting to stop `ora.rac1.vip` on member `rac1`
Stop of `ora.rac1.vip` on member `rac1` succeeded.
Stop of `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2` succeeded.
Attempting to stop `ora.rac2.vip` on member `rac2`
Stop of `ora.rac2.vip` on member `rac2` succeeded.
CRS-0216: Could not stop resource 'ora.ppzhu.ppzhu1.inst'.

CRS-0216: Could not stop resource 'ora.ppzhu.ppzhu2.inst'.

[oracle@rac1 bdump]$ crs_start -all
Attempting to start `ora.rac1.vip` on member `rac1`
Attempting to start `ora.rac2.vip` on member `rac2`
Attempting to start `ora.ppzhu.ppzhu1.inst` on member `rac1`
Attempting to start `ora.ppzhu.ppzhu2.inst` on member `rac2`
Attempting to start `ora.rac2.ASM2.asm` on member `rac2`
Attempting to start `ora.rac1.ASM1.asm` on member `rac1`
Start of `ora.rac1.ASM1.asm` on member `rac1` succeeded.
Start of `ora.rac2.vip` on member `rac2` succeeded.
Attempting to start `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2`
Start of `ora.rac1.vip` on member `rac1` succeeded.
Attempting to start `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1`
Start of `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1` succeeded.
Start of `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2` succeeded.
Start of `ora.rac2.ASM2.asm` on member `rac2` succeeded.
Start of `ora.ppzhu.ppzhu1.inst` on member `rac1` succeeded.
Start of `ora.ppzhu.ppzhu2.inst` on member `rac2` succeeded.
Attempting to start `ora.ppzhu.dw.cs` on member `rac2`
CRS-1002: Resource 'ora.rac1.ons' is already running on member 'rac1'

CRS-1002: Resource 'ora.ppzhu.db' is already running on member 'rac2'

Attempting to start `ora.rac1.gsd` on member `rac1`
Attempting to start `ora.ppzhu.dw.ppzhu1.srv` on member `rac1`
Attempting to start `ora.ppzhu.dw.ppzhu2.srv` on member `rac2`
Attempting to start `ora.rac2.gsd` on member `rac2`
Attempting to start `ora.rac2.ons` on member `rac2`
Start of `ora.ppzhu.dw.cs` on member `rac2` succeeded.
Start of `ora.ppzhu.dw.ppzhu1.srv` on member `rac1` succeeded.
Start of `ora.rac1.gsd` on member `rac1` succeeded.
Start of `ora.ppzhu.dw.ppzhu2.srv` on member `rac2` succeeded.
Start of `ora.rac2.gsd` on member `rac2` succeeded.
Start of `ora.rac2.ons` on member `rac2` failed.
rac1 : CRS-1019: Resource ora.rac2.ons (application) cannot run on rac1

CRS-0223: Resource 'ora.ppzhu.db' has placement error.

CRS-0223: Resource 'ora.rac1.ons' has placement error.

CRS-0215: Could not start resource 'ora.rac2.ons'.

[oracle@rac1 bdump]$ crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.ppzhu.db   application    ONLINE    ONLINE    rac2       
ora....u.dw.cs application    ONLINE    ONLINE    rac2       
ora....hu1.srv application    ONLINE    ONLINE    rac1       
ora....hu2.srv application    ONLINE    ONLINE    rac2       
ora....u1.inst application    ONLINE    ONLINE    rac1       
ora....u2.inst application    ONLINE    ONLINE    rac2       
ora....SM1.asm application    ONLINE    ONLINE    rac1       
ora....C1.lsnr application    ONLINE    ONLINE    rac1       
ora.rac1.gsd   application    ONLINE    ONLINE    rac1       
ora.rac1.ons   application    ONLINE    ONLINE    rac1       
ora.rac1.vip   application    ONLINE    ONLINE    rac1       
ora....SM2.asm application    ONLINE    ONLINE    rac2       
ora....C2.lsnr application    ONLINE    ONLINE    rac2       
ora.rac2.gsd   application    ONLINE    ONLINE    rac2       
ora.rac2.ons   application    ONLINE    OFFLINE              
ora.rac2.vip   application    ONLINE    ONLINE    rac2     

應該沒有問題了。