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     

应该没有问题了。