Oracle10.2.0.3 RAC的VIP及实例依赖关系

Oracle10g在Oracle 10.2.0.3之前,CRS中实例资源是依赖于VIP资源的。

这会导致的一个普遍问题是，当仅仅是VIP出现故障需要切换时，实例和监听也同时Down了。

往往这是我们不希望看到的情形，如果实例正常，VIP切换时，完全没有必要关闭实例。



在Oracle 10.2.0.3中，这个依赖关系被取消。我们看一下这个版本中的现有情况。

以下是VIP资源的配置情况：

[oracle@smsdbrac1 oracle]$ crs_stat -p ora.smsdbrac1.vip

NAME=ora.smsdbrac1.vip

TYPE=application

ACTION_SCRIPT=/opt/oracle/product/10.2.0/crs10g/bin/racgwrap

ACTIVE_PLACEMENT=1

AUTO_START=1

CHECK_INTERVAL=60

DESCRIPTION=CRS application for VIP on a node

FAILOVER_DELAY=0

FAILURE_INTERVAL=0

FAILURE_THRESHOLD=0

HOSTING_MEMBERS=smsdbrac1

OPTIONAL_RESOURCES=

PLACEMENT=favored

REQUIRED_RESOURCES=

RESTART_ATTEMPTS=0

SCRIPT_TIMEOUT=60

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=eth0|eth1

USR_ORA_INST_NOT_SHUTDOWN=

USR_ORA_LANG=

USR_ORA_NETMASK=255.255.255.0

USR_ORA_OPEN_MODE=

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=192.168.200.13

再来看看实例：

[oracle@smsdbrac1 oracle]$ crs_stat -p ora.smsdb.smsdb1.inst

NAME=ora.smsdb.smsdb1.inst

TYPE=application

ACTION_SCRIPT=/opt/oracle/product/10.2.0/db/bin/racgwrap

ACTIVE_PLACEMENT=0

AUTO_START=1

CHECK_INTERVAL=600

DESCRIPTION=CRS application for Instance

FAILOVER_DELAY=0

FAILURE_INTERVAL=0

FAILURE_THRESHOLD=0

HOSTING_MEMBERS=smsdbrac1

OPTIONAL_RESOURCES=

PLACEMENT=restricted

REQUIRED_RESOURCES=ora.smsdbrac1.ASM1.asm

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=

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=

现在instance仅仅依赖于asm而存在，这里的ASM资源是ora.smsdbrac1.ASM1.asm。



-The End-