« 2007 年终总结-Eygle.Com的发展历程 | Blog首页 | DBA警世录:年关临近 谨防数据库事故 »

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-

By eygle on 2008-01-10 10:35 | Comments (1) | Advanced | Oracle12c/11g | 1738 |

ASMRAC