环境配置:
OS版本:Enterprise Linux Enterprise Linux Server release 5.4 (Carthage)
DB版本:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
出现节点rac2的ASM不能注册到CRS资源中,启动RAC库的时候就无法自动启动+ASM2,导致实例2就不能启动,只能通过手动先启动+ASM2,然后手动启动实例2解决。现在将+ASM2注册到CRS中,如下
1.查看CRS资源注册信息
[oracle@rac1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....11.inst application 0/5 0/0 ONLINE ONLINE rac1
ora....12.inst application 0/5 0/0 ONLINE ONLINE rac2
ora....N11.srv application 0/0 0/0 ONLINE ONLINE rac1
ora...._TAF.cs application 0/0 0/1 ONLINE ONLINE rac1
ora.HHPEN1.db application 0/0 0/1 ONLINE ONLINE rac2
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1
ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1
ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1
ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2
ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2
CRS-0181: Cannot access the resource profile '/u01/app/oracle/crs/crs/public/ora.rac2.ASM2.asm.cap'.
OS版本:Enterprise Linux Enterprise Linux Server release 5.4 (Carthage)
DB版本:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
出现节点rac2的ASM不能注册到CRS资源中,启动RAC库的时候就无法自动启动+ASM2,导致实例2就不能启动,只能通过手动先启动+ASM2,然后手动启动实例2解决。现在将+ASM2注册到CRS中,如下
1.查看CRS资源注册信息
[oracle@rac1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....11.inst application 0/5 0/0 ONLINE ONLINE rac1
ora....12.inst application 0/5 0/0 ONLINE ONLINE rac2
ora....N11.srv application 0/0 0/0 ONLINE ONLINE rac1
ora...._TAF.cs application 0/0 0/1 ONLINE ONLINE rac1
ora.HHPEN1.db application 0/0 0/1 ONLINE ONLINE rac2
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1
ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1
ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1
ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2
ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2
2.使用crs_register进行注册
[oracle@rac1 ~]$ crs_register ora.rac2.ASM2.asm
CRS-0181: Cannot access the resource profile '/u01/app/oracle/crs/crs/public/ora.rac2.ASM2.asm.cap'.
[oracle@rac1 ~]$ cd /u01/app/oracle/crs/crs/public
[oracle@rac1 public]$ ls
action_scr.scr ora.bak ora.rac1.ASM1.asm.cap
[oracle@rac1 public]$ cp ora.rac1.ASM1.asm.cap ora.rac2.ASM2.asm.cap
[oracle@rac1 public]$ ls
action_scr.scr ora.bak ora.rac1.ASM1.asm.cap ora.rac2.ASM2.asm.cap
[oracle@rac1 public]$ ls
action_scr.scr ora.bak ora.rac1.ASM1.asm.cap
[oracle@rac1 public]$ cp ora.rac1.ASM1.asm.cap ora.rac2.ASM2.asm.cap
[oracle@rac1 public]$ ls
action_scr.scr ora.bak ora.rac1.ASM1.asm.cap ora.rac2.ASM2.asm.cap
[oracle@rac1 public]$ cat ora.rac2.ASM2.asm.cap --修改其中的配置如下
NAME=ora.rac2.ASM2.asm
TYPE=application
ACTION_SCRIPT=/u01/app/oracle/db_1/bin/racgwrap
ACTIVE_PLACEMENT=0
AUTO_START=1
CHECK_INTERVAL=600
DESCRIPTION=CRS application for ASM instance
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=rac2
OPTIONAL_RESOURCES=
PLACEMENT=restricted
REQUIRED_RESOURCES=ora.rac2.vip
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=0
STOP_TIMEOUT=0
UPTIME_THRESHOLD=7d
USR_ORA_ALERT_NAME=
USR_ORA_CHECK_TIMEOUT=0
USR_ORA_CONNECT_STR=/ as sysdba
USR_ORA_DEBUG=0
USR_ORA_DISCONNECT=false
USR_ORA_FLAGS=
USR_ORA_IF=
USR_ORA_INST_NOT_SHUTDOWN=
USR_ORA_LANG=
USR_ORA_NETMASK=
USR_ORA_OPEN_MODE=mount
USR_ORA_OPI=false
USR_ORA_PFILE=
USR_ORA_PRECONNECT=none
USR_ORA_SRV=
USR_ORA_START_TIMEOUT=0
USR_ORA_STOP_MODE=immediate
USR_ORA_STOP_TIMEOUT=0
USR_ORA_VIP=
NAME=ora.rac2.ASM2.asm
TYPE=application
ACTION_SCRIPT=/u01/app/oracle/db_1/bin/racgwrap
ACTIVE_PLACEMENT=0
AUTO_START=1
CHECK_INTERVAL=600
DESCRIPTION=CRS application for ASM instance
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=rac2
OPTIONAL_RESOURCES=
PLACEMENT=restricted
REQUIRED_RESOURCES=ora.rac2.vip
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=0
STOP_TIMEOUT=0
UPTIME_THRESHOLD=7d
USR_ORA_ALERT_NAME=
USR_ORA_CHECK_TIMEOUT=0
USR_ORA_CONNECT_STR=/ as sysdba
USR_ORA_DEBUG=0
USR_ORA_DISCONNECT=false
USR_ORA_FLAGS=
USR_ORA_IF=
USR_ORA_INST_NOT_SHUTDOWN=
USR_ORA_LANG=
USR_ORA_NETMASK=
USR_ORA_OPEN_MODE=mount
USR_ORA_OPI=false
USR_ORA_PFILE=
USR_ORA_PRECONNECT=none
USR_ORA_SRV=
USR_ORA_START_TIMEOUT=0
USR_ORA_STOP_MODE=immediate
USR_ORA_STOP_TIMEOUT=0
USR_ORA_VIP=
[oracle@rac1 public]$ crs_register ora.rac2.ASM2.asm --重新注册
批注:也许每个人的RAC环境不一样,我的这种情况是之前一个节点的磁盘坏了,然后将其剔除集群环境,新增加了一个节点放入集群环境,但是后来新
添加的节点+ASM2并没有注册到CRS资源中,以至于crs_stat -t -v不显示+ASM2的信息,本篇文章是基于这种情况下的解决办法。
基于我之前总结的重建ASM的后续问题解决: http://blog.itpub.net/29634949/viewspace-1280908/
-- END --
3.查看是否注册资源成功
批注:也许每个人的RAC环境不一样,我的这种情况是之前一个节点的磁盘坏了,然后将其剔除集群环境,新增加了一个节点放入集群环境,但是后来新
添加的节点+ASM2并没有注册到CRS资源中,以至于crs_stat -t -v不显示+ASM2的信息,本篇文章是基于这种情况下的解决办法。
基于我之前总结的重建ASM的后续问题解决: http://blog.itpub.net/29634949/viewspace-1280908/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29634949/viewspace-1298048/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29634949/viewspace-1298048/