Oracle 10G RAC中去除asm实例与vip的依赖关系

Oracle 10G rac安装完成之后，如果使用asm，那么默认情况下 asm是依赖于vip的，如果vip因故失效，会导致asm同时失效，在10.2.0.3上这个问题已经得到修复。
在metelink上有一个文档（doc：4865736.8），介绍了一个方法接触asm与vip的依赖关系，下面演示器过程：

[@more@]

1、找到asm资源名称，红色部分为asm资源名称

[root@rac1 ~]# crs_stat NAME=ora.cnhtm.cnhtm1.inst TYPE=application TARGET=ONLINE STATE=ONLINE on rac1 NAME=ora.cnhtm.cnhtm2.inst TYPE=application TARGET=ONLINE STATE=ONLINE on rac2 NAME=ora.cnhtm.db TYPE=application TARGET=ONLINE STATE=ONLINE on rac1 NAME=ora.rac1.ASM1.asm TYPE=application TARGET=ONLINE STATE=ONLINE on rac1 NAME=ora.rac1.LISTENER_RAC1.lsnr TYPE=application TARGET=ONLINE STATE=ONLINE on rac1 NAME=ora.rac1.gsd TYPE=application TARGET=ONLINE STATE=ONLINE on rac1 NAME=ora.rac1.ons TYPE=application TARGET=ONLINE STATE=ONLINE on rac1 NAME=ora.rac1.vip TYPE=application TARGET=ONLINE STATE=ONLINE on rac1 NAME=ora.rac2.ASM2.asm TYPE=application TARGET=ONLINE STATE=ONLINE on rac2 NAME=ora.rac2.LISTENER_RAC2.lsnr TYPE=application TARGET=ONLINE STATE=ONLINE on rac2 NAME=ora.rac2.gsd TYPE=application TARGET=ONLINE STATE=ONLINE on rac2 NAME=ora.rac2.ons TYPE=application TARGET=ONLINE STATE=ONLINE on rac2 NAME=ora.rac2.vip TYPE=application TARGET=ONLINE STATE=ONLINE on rac2

2、查看asm资源是否依赖于vip

如果REQUIRED_RESOURCES=后边有vip资源的值，证明asm依赖于vip（红色部分），需要进行修改

ora.rac1.ASM1.asm

[root@rac1 tmp]# crs_stat -p ora.rac1.ASM1.asm NAME=ora.rac1.ASM1.asm TYPE=application ACTION_SCRIPT=/u01/app/oracle/product/10.2.0/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=rac1 OPTIONAL_RESOURCES= PLACEMENT=restricted REQUIRED_RESOURCES=ora.rac1.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=

ora.rac2.ASM2.asm

[root@rac1 tmp]# crs_stat -p ora.rac2.ASM2.asm NAME=ora.rac2.ASM2.asm TYPE=application ACTION_SCRIPT=/u01/app/oracle/product/10.2.0/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=

3、将asm资源注册信息保存到临时文件中

ora.rac1.ASM1.asm

[root@rac1 ~]# crs_stat -p ora.rac1.ASM1.asm > /tmp/ora.rac1.ASM1.asm.cap

ora.rac2.ASM2.asm

[root@rac1 ~]# crs_stat -p ora.rac2.ASM2.asm > /tmp/ora.rac2.ASM2.asm.cap

4、修改保存的asm资源文件

[root@rac1 ~]# cd /tmp [root@rac1 tmp]# ls -l *cap -rw-r--r-- 1 root root 823 Jan 18 16:34 ora.rac1.ASM1.asm.cap -rw-r--r-- 1 root root 823 Jan 18 16:35 ora.rac2.ASM2.asm.cap

修改的方法就是将REQUIRED_RESOURCES=后的vip信息去掉，下面红色部分为修改后的结果

ora.rac1.ASM1.asm

[root@rac1 tmp]# cat ora.rac1.ASM1.asm.cap NAME=ora.rac1.ASM1.asm TYPE=application ACTION_SCRIPT=/u01/app/oracle/product/10.2.0/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=rac1 OPTIONAL_RESOURCES= PLACEMENT=restricted REQUIRED_RESOURCES= 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=

ora.rac2.ASM2.asm

[root@rac1 tmp]# cat ora.rac2.ASM2.asm.cap NAME=ora.rac2.ASM2.asm TYPE=application ACTION_SCRIPT=/u01/app/oracle/product/10.2.0/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= 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=

5、用修改过的文件重新注册asm资源

ora.rac1.ASM1.asm

[root@rac1 tmp]# crs_register -u ora.rac1.ASM1.asm -dir /tmp

ora.rac2.ASM2.asm

[root@rac1 tmp]# crs_register -u ora.rac2.ASM2.asm -dir /tmp

6、查看asm是否还依赖于vip资源

下面结果显示asm已经不依赖于vip资源，红色行

ora.rac1.ASM1.asm

[root@rac1 tmp]# crs_stat -p ora.rac1.ASM1.asm NAME=ora.rac1.ASM1.asm TYPE=application ACTION_SCRIPT=/u01/app/oracle/product/10.2.0/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=rac1 OPTIONAL_RESOURCES= PLACEMENT=restricted REQUIRED_RESOURCES= 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=

ora.rac2.ASM2.asm

[root@rac1 tmp]# crs_stat -p ora.rac2.ASM2.asm NAME=ora.rac2.ASM2.asm TYPE=application ACTION_SCRIPT=/u01/app/oracle/product/10.2.0/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= 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=

--end--

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22049049/viewspace-1030663/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22049049/viewspace-1030663/