RAC 下使用DBCA 建立ASM出错(ORA-15032,ORA-15063)

简介: 先说说我的系统和ORACLE版本 SQL> select * from v$version  2  ; BANNER-----------------------------------------------------------------------...
先说说我的系统和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     
应该没有问题了。
 
 
 
 
相关文章
|
7月前
|
存储 Oracle 关系型数据库
RAC创建ASM磁盘组时配置多路径和UDEV
RAC创建ASM磁盘组时配置多路径和UDEV
1462 7
RAC 增加4块 asm 磁盘
增加磁盘之前的asm状态
|
存储 SQL Oracle
请参考rhel7 安装 oracle 18c rac(03 dbca 建立数据库)
rhel7 安装 oracle 18c rac(01 grid软件安装) dbca 建立数据库。
3244 0
|
4月前
|
运维 Oracle 前端开发
Oracle 11g RAC集群日常运维命令总结
Oracle 11g RAC集群日常运维命令总结
101 2
|
4月前
|
Oracle 关系型数据库
分布式锁设计问题之Oracle RAC保证多个节点写入内存Page的一致性如何解决
分布式锁设计问题之Oracle RAC保证多个节点写入内存Page的一致性如何解决
|
5月前
|
存储 负载均衡 Oracle