ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > SCAN VIP/Listener do not fail back after public network recovered

SCAN VIP/Listener do not fail back after public network recovered

原创 Oracle 作者：monkeybron 时间：2015-04-02 10:09:26 0 删除 编辑
由于网络闪断，2节点rac，出现sanlistener 飘逸到一个节点的情况： 
[grid@hq-d-rac0201 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node hq-d-rac0201
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node hq-d-rac0201



[root@hq-d-rac0201 ~]# ifconfig
eth0      Link encap:Ethernet  HWaddr 00:15:5D:6E:37:04  
          inet addr:10.1.2.11  Bcast:10.1.3.255  Mask:255.255.254.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:531615924 errors:0 dropped:0 overruns:0 frame:0
          TX packets:439135926 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:324364978919 (302.0 GiB)  TX bytes:156572335963 (145.8 GiB)

eth0:1    Link encap:Ethernet  HWaddr 00:15:5D:6E:37:04  
          inet addr:10.1.2.12  Bcast:10.1.3.255  Mask:255.255.254.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth0:2    Link encap:Ethernet  HWaddr 00:15:5D:6E:37:04  
          inet addr:10.1.2.13  Bcast:10.1.3.255  Mask:255.255.254.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth0:4    Link encap:Ethernet  HWaddr 00:15:5D:6E:37:04  
          inet addr:10.1.3.13  Bcast:10.1.3.255  Mask:255.255.254.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth1      Link encap:Ethernet  HWaddr 00:15:5D:6E:37:05  
          inet addr:10.1.100.11  Bcast:10.1.100.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:282634075 errors:0 dropped:0 overruns:0 frame:0
          TX packets:227986720 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:244020508708 (227.2 GiB)  TX bytes:163838544505 (152.5 GiB)

eth1:1    Link encap:Ethernet  HWaddr 00:15:5D:6E:37:05  
          inet addr:169.254.26.113  Bcast:169.254.255.255  Mask:255.255.0.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth2      Link encap:Ethernet  HWaddr 00:15:5D:6E:37:06  
          inet addr:10.1.106.30  Bcast:10.1.106.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:9000  Metric:1
          RX packets:112281425 errors:0 dropped:0 overruns:0 frame:0
          TX packets:156210447 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:559182688112 (520.7 GiB)  TX bytes:172414912859 (160.5 GiB)

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:65899988 errors:0 dropped:0 overruns:0 frame:0
          TX packets:65899988 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:9951165215 (9.2 GiB)  TX bytes:9951165215 (9.2 GiB)
#################################################################################################3333
		  
[root@hq-d-rac0202 ~]# ifconfig
eth0      Link encap:Ethernet  HWaddr 00:15:5D:05:84:07  
          inet addr:10.1.3.11  Bcast:10.1.3.255  Mask:255.255.254.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:167554240 errors:0 dropped:0 overruns:0 frame:0
          TX packets:151967799 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:41410109591 (38.5 GiB)  TX bytes:86390694228 (80.4 GiB)

eth0:1    Link encap:Ethernet  HWaddr 00:15:5D:05:84:07  
          inet addr:10.1.3.12  Bcast:10.1.3.255  Mask:255.255.254.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth1      Link encap:Ethernet  HWaddr 00:15:5D:05:84:08  
          inet addr:10.1.100.12  Bcast:10.1.100.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:228122319 errors:0 dropped:0 overruns:0 frame:0
          TX packets:282511776 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:160669221145 (149.6 GiB)  TX bytes:247963297870 (230.9 GiB)

eth1:1    Link encap:Ethernet  HWaddr 00:15:5D:05:84:08  
          inet addr:169.254.105.37  Bcast:169.254.255.255  Mask:255.255.0.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth2      Link encap:Ethernet  HWaddr 00:15:5D:05:84:09  
          inet addr:10.1.106.31  Bcast:10.1.106.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:9000  Metric:1
          RX packets:203299557 errors:0 dropped:0 overruns:0 frame:0
          TX packets:243882538 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:1216490492922 (1.1 TiB)  TX bytes:228145565509 (212.4 GiB)

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:82060813 errors:0 dropped:0 overruns:0 frame:0
          TX packets:82060813 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:15368661201 (14.3 GiB)  TX bytes:15368661201 (14.3 GiB)
查看网络果然如此。根据MOS[ID 1491345.1]，手动分配下报错：依然没还原！ 




[grid@hq-d-rac0201 ~]$ srvctl relocate scan_listener -i 2 -n hq-d-rac0202



PRCR-1105 : Failed to relocate resource ora.LISTENER_SCAN2.lsnr to node hq-d-rac0202
PRCR-1089 : Failed to relocate resource ora.LISTENER_SCAN2.lsnr.
Cannot communicate with crsd


[grid@hq-d-rac0201 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node hq-d-rac0201
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node hq-d-rac0201

[root@hq-d-rac0201 ~]# ifconfig
eth0      Link encap:Ethernet  HWaddr 00:15:5D:6E:37:04  
          inet addr:10.1.2.11  Bcast:10.1.3.255  Mask:255.255.254.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:531947855 errors:0 dropped:0 overruns:0 frame:0
          TX packets:439363165 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:324498179629 (302.2 GiB)  TX bytes:156635418433 (145.8 GiB)

eth0:1    Link encap:Ethernet  HWaddr 00:15:5D:6E:37:04  
          inet addr:10.1.2.12  Bcast:10.1.3.255  Mask:255.255.254.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth0:3    Link encap:Ethernet  HWaddr 00:15:5D:6E:37:04  
          inet addr:10.1.3.13  Bcast:10.1.3.255  Mask:255.255.254.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth1      Link encap:Ethernet  HWaddr 00:15:5D:6E:37:05  
          inet addr:10.1.100.11  Bcast:10.1.100.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:282724645 errors:0 dropped:0 overruns:0 frame:0
          TX packets:228044478 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:244100663822 (227.3 GiB)  TX bytes:163872295399 (152.6 GiB)

eth1:1    Link encap:Ethernet  HWaddr 00:15:5D:6E:37:05  
          inet addr:169.254.26.113  Bcast:169.254.255.255  Mask:255.255.0.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth2      Link encap:Ethernet  HWaddr 00:15:5D:6E:37:06  
          inet addr:10.1.106.30  Bcast:10.1.106.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:9000  Metric:1
          RX packets:112323180 errors:0 dropped:0 overruns:0 frame:0
          TX packets:156266451 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:559413473576 (520.9 GiB)  TX bytes:172446357908 (160.6 GiB)

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:65916231 errors:0 dropped:0 overruns:0 frame:0
          TX packets:65916231 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:9955228957 (9.2 GiB)  TX bytes:9955228957 (9.2 GiB)
		  
		  
[root@hq-d-rac0202 ~]# ifconfig
eth0      Link encap:Ethernet  HWaddr 00:15:5D:05:84:07  
          inet addr:10.1.3.11  Bcast:10.1.3.255  Mask:255.255.254.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:167587597 errors:0 dropped:0 overruns:0 frame:0
          TX packets:152001354 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:41413071662 (38.5 GiB)  TX bytes:86411723263 (80.4 GiB)

eth0:1    Link encap:Ethernet  HWaddr 00:15:5D:05:84:07  
          inet addr:10.1.2.13  Bcast:10.1.3.255  Mask:255.255.254.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth0:2    Link encap:Ethernet  HWaddr 00:15:5D:05:84:07  
          inet addr:10.1.3.12  Bcast:10.1.3.255  Mask:255.255.254.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth1      Link encap:Ethernet  HWaddr 00:15:5D:05:84:08  
          inet addr:10.1.100.12  Bcast:10.1.100.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:228178580 errors:0 dropped:0 overruns:0 frame:0
          TX packets:282598516 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:160701853279 (149.6 GiB)  TX bytes:248040904050 (231.0 GiB)

eth1:1    Link encap:Ethernet  HWaddr 00:15:5D:05:84:08  
          inet addr:169.254.105.37  Bcast:169.254.255.255  Mask:255.255.0.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth2      Link encap:Ethernet  HWaddr 00:15:5D:05:84:09  
          inet addr:10.1.106.31  Bcast:10.1.106.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:9000  Metric:1
          RX packets:203353106 errors:0 dropped:0 overruns:0 frame:0
          TX packets:243951678 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:1216811464365 (1.1 TiB)  TX bytes:228172499526 (212.5 GiB)

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:82077278 errors:0 dropped:0 overruns:0 frame:0
          TX packets:82077278 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:15374913313 (14.3 GiB)  TX bytes:15374913313 (14.3 GiB)

但是其实已经重新relocate了，重新执行srvctl relocate命令： 



[grid@hq-d-rac0202 ~]$ srvctl relocate scan_listener -i 2 -n hq-d-rac0202
[grid@hq-d-rac0202 ~]$ 
[grid@hq-d-rac0202 ~]$ 
[grid@hq-d-rac0202 ~]$ 
[grid@hq-d-rac0202 ~]$ 
[grid@hq-d-rac0202 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node hq-d-rac0201
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node hq-d-rac0202

搞定。


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

0
0
上一篇： 11.2.0.3 rac path16670704遇到的问题
下一篇： 存储镜像导致rac数据库hang
请登录后发表评论 登录
全部评论
monkeybron

注册时间：2015-03-30

  • 博文量
    70
  • 访问量
    94588

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593