oracle 10g rac 拨公网网线和私网网线物理测试
测试环境aix+ oracle 10g rac
数据库版本 oracle 10g 10.2.0.4
一. 拨公网网线测试
1.拔掉p595a2节点公网网线
[oracle@p595a2:/oracle/app/oracle]$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.fk.db application ONLINE ONLINE p595a2
ora....k1.inst application ONLINE ONLINE p595a2
ora....k2.inst application ONLINE ONLINE p595b2
ora....SM1.asm application ONLINE ONLINE p595a2
ora....A2.lsnr application ONLINE ONLINE p595a2
ora.p595a2.gsd application ONLINE ONLINE p595a2
ora.p595a2.ons application ONLINE ONLINE p595a2
ora.p595a2.vip application ONLINE OFFLINE
ora....SM2.asm application ONLINE ONLINE p595b2
ora....B2.lsnr application ONLINE ONLINE p595b2
ora.p595b2.gsd application ONLINE ONLINE p595b2
ora.p595b2.ons application ONLINE ONLINE p595b2
ora.p595b2.vip application ONLINE ONLINE p595b2
vip offline
[oracle@p595a2:/oracle/app/oracle]$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.fk.db application ONLINE ONLINE p595a2
ora....k1.inst application ONLINE ONLINE p595a2
ora....k2.inst application ONLINE ONLINE p595b2
ora....SM1.asm application ONLINE ONLINE p595a2
ora....A2.lsnr application ONLINE OFFLINE
ora.p595a2.gsd application ONLINE ONLINE p595a2
ora.p595a2.ons application ONLINE ONLINE p595a2
ora.p595a2.vip application ONLINE ONLINE p595b2
ora....SM2.asm application ONLINE ONLINE p595b2
ora....B2.lsnr application ONLINE ONLINE p595b2
ora.p595b2.gsd application ONLINE ONLINE p595b2
ora.p595b2.ons application ONLINE ONLINE p595b2
ora.p595b2.vip application ONLINE ONLINE p595b2
vip发生切换,飘到p595b2节点上,p595a2 listener offline
其他资源正常
2.恢复p595a2节点公网网线
[oracle@p595a2:/oracle/app/oracle]$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.fk.db application ONLINE ONLINE p595a2
ora....k1.inst application ONLINE ONLINE p595a2
ora....k2.inst application ONLINE ONLINE p595b2
ora....SM1.asm application ONLINE ONLINE p595a2
ora....A2.lsnr application ONLINE OFFLINE
ora.p595a2.gsd application ONLINE ONLINE p595a2
ora.p595a2.ons application ONLINE ONLINE p595a2
ora.p595a2.vip application ONLINE ONLINE p595b2
ora....SM2.asm application ONLINE ONLINE p595b2
ora....B2.lsnr application ONLINE ONLINE p595b2
ora.p595b2.gsd application ONLINE ONLINE p595b2
ora.p595b2.ons application ONLINE ONLINE p595b2
ora.p595b2.vip application ONLINE ONLINE p595b2
p595a2 listener 还是offline vip没切换回来,还是在p595b节点上
vip服务和listener服务并不会自动启动,这两个服务需要手工启动
用以下命令启动listener服务和vip服务
srvctl start listener -n p595a2
也可以用crs_relocate手工将vip漂移回来
crs_relocate ora.p595a2.vip -c p595a2
然后p595a2 listener会自动起来
[oracle@p595a2:/oracle/app/oracle]$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.fk.db application ONLINE ONLINE p595a2
ora....k1.inst application ONLINE ONLINE p595a2
ora....k2.inst application ONLINE ONLINE p595b2
ora....SM1.asm application ONLINE ONLINE p595a2
ora....A2.lsnr application ONLINE ONLINE p595a2
ora.p595a2.gsd application ONLINE ONLINE p595a2
ora.p595a2.ons application ONLINE ONLINE p595a2
ora.p595a2.vip application ONLINE ONLINE p595a2
ora....SM2.asm application ONLINE ONLINE p595b2
ora....B2.lsnr application ONLINE ONLINE p595b2
ora.p595b2.gsd application ONLINE ONLINE p595b2
ora.p595b2.ons application ONLINE ONLINE p595b2
ora.p595b2.vip application ONLINE ONLINE p595b2
结论
和metalink解释一致。
Prior to 10.2.0.3
What happens on public network adapter failure? This list does not represent the exact sequence of events.
The VIP resource is relocated to another node in the cluster
The Listener resource is taken offline
The RAC database instance is taken offline
The ASM instance, if present, is taken offline
The ASM instance, if present, and RAC database instances deregister with the other listeners in the cluster
Post 10.2.0.3 patchset
What happens on public network adapter failure? This list does not represent the exact sequence of events.
The VIP resource is relocated to another node in the cluster
The Listener resource is taken offline
The RAC database instance stays up and blocked for general operations
The ASM instance, if present, stays up
The ASM instance, if present, and RAC database instances deregister with the other listeners in the cluster
What happens when the Public adapter comes back?
The VIP will be relocated back to its host node, this will happen the next time Oracle Clusterware checks the instance.
This check is carried out, by default, every 600 seconds so this is the maximum amount of time that could pass before
the relocate is triggered.
The VIP can manually be relocated back to its home node using the srvctl start nodeapps –n command.
二. 拨私网网线测试
1.拔掉p595a2或p595b2节点私网网线
均会导致p595b2节点自动重启,这是oracle crs保护机制
会保留master节点,即first node join the cluster
I have a 2-node RAC running. I notice that it is always node2 that is evicted when I test private network failure
scenario by disconnecting the private network cable.
Doesn't matter whether it is node1's or node2's private network cable that is disconnected, it is always the node2 that is evicted.
What happens in a 3-nodes RAC cluster if node1's cable is disconnected?
The node with the lower node number will survive(The first node to join the cluster). In case of 3 nodes,
2 nodes will survive and the one you pulled the cable will go away. 4 nodes - the sub cluster with the lower node number will survive.
为了提高私网的可用性,建议网卡绑定。