oracle10g删除asm组,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--