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

最新推荐文章于 2021-05-26 14:10:18 发布
最新推荐文章于 2021-05-26 14:10:18 发布
阅读量1.7k 收藏
点赞数
分类专栏： Oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kelly1984/article/details/9285323
版权
由于网络闪断，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

搞定。


kelly1984
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
PRCR-1079 : Failed to start resource ora.scan1.vip
cuixie2370的博客
04-17 1228
天边月 11:19:00我装11G RAC的时候，没有指定DNS，只有在节点1，2的/etc/hosts上指定了一个128 SCAN IP，在节点1上 运行root.sh没有问题，但是在节点2上运行root.sh出现了这个错...
2018-06-07 KK日记，ORA-12545故障处理
IT匠人的专栏
06-08 719
一、案例某dba反馈前几天刚安装好的rac，让一个小白碰过后，就变得不能用scan-ip访问了，报如下错误“ora-12545 Connect failed because target host or object does not exist”;但是用vip是可以访问的。二、问题为什么使用scan-vip连接DB时会报“ora-12545 Connect failed because targ...
HBase 官方文档中文版
lbyyy的专栏
11-17 4556
HBase 官方文档中文版
RAC: Frequently Asked Questions [ID 220970.1]
11-22 1174
RAC: Frequently Asked Questions [ID 220970.1]Applies to: Oracle Server - Enterprise Edition - Version 9....
12C ORA-错误汇总10 ORA-12500 to ORA-19400
badman250的专栏
03-02 3万+
ORA-12500: TNS:listener failed to start a dedicated server process Cause: The process of starting up a dedicated server process failed. The executable could not be found or the environment may be se
11.2.0.4 Patch Set - List of Bug Fixes by Problem Type (Doc ID 1562142.1)
Zhong Weicheng Study Notes
09-20 6万+
Bugs fixed in the 11.2.0.4 Patch Set See Note:880782.1 for Support Status and Alerts affecting 11.2.0 releases. This note lists customer bugs fixed in the 11.2.0.4 Patch Set which are not alread
RAC: Frequently Asked Questions (Doc ID 220970.1)
mybluetiankong的专栏
04-25 5182
APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.1 to 12.1.0.1 [Release 9.2 to 12.1] Information in this document applies to any platform. PURPOSE Frequently Asked Questions for Re
RAC经常被问到的问题--RAC: Frequently Asked Questions [ID 220970.1]
congxinlan3332的博客
01-23 1175
RAC: Frequently Asked Questions [ID 220970.1] 修改时间13-JAN-2011类型FAQ状态PUBLISHED ...
10.2.0.4 Patch Set - List of Bug Fixes by Problem Type (文档 ID 401436.1)
mybluetiankong的专栏
12-25 8594
Bugs fixed in the 10.2.0.4 Patch Set See Note:316900.1 for Support Status and Alerts affecting 10.2.0 releases. This note lists the customer bugs fixed in the 10.2.0.4 Patch Set which are not al
Oracle的diag文件可以删除,oracle11g rac diag/tnslsnr/pgis2/listener/alert 中的文件能删除吗...
weixin_28834169的博客
04-04 3257
满意答案yaoyangm2016.08.03采纳率：47%等级：12已帮助：27962人当然要对监听日志文件(listener.log)进行定期清理，如果不定期清理，会遇到下面一些麻烦：1：监听日志文件(listener.log)变得越来越大，占用额外的存储空间。(当然现在存储白菜价，不差那几G的空间。但是我们还是要本着工匠情怀，精益求精)2：监听日志文件(listener.log)变得太...
【SpringBoot】36、SpringBoot整合Redis实现发布/订阅
热门推荐
Asurplus
10-23 21万+
一、简介 1、发布订阅 SUBSCRIBE, UNSUBSCRIBE 和 PUBLISH 实现了 发布/订阅消息范例，发送者 (publishers) 不用编程就可以向特定的接受者发送消息 (subscribers). Rather, 发布的消息进入通道，不需要知道有没有订阅者. 订阅者发表感兴趣的一个或多个通道，并且只接受他们感兴趣的消息，不管发布者是不是存在. 发布者和订阅者的解耦可以允许更大的伸缩性和更多动态的网络拓扑。 2、说明 本篇文章是继： 【SpringBoot】三十四、SpringBoot
Oracle RAC修改VIP、public IP地址
weixin_36239782的博客
06-08 1758
前言：Oracle RAC修改IP并不多见，但是修改下来还是比较简单，做好备份，文章中没有写私网IP的修改，但是与修改VIP以及公网IP差别不大，主要多一个重要的步骤就是再删除旧IP之前需要先把新的IP加上，因为集群间的通信除了磁盘心跳就是私网心跳，在附录中MOS文档中有描述如何修改私网IP。 环境： 11.2.0.4 RAC OS:oracle linux 6.5 一、 准备 备份OCR、hos...
【ES】es 查询超时listener timeout after waiting for [60000] ms
九师兄
12-24 4764
1.背景 简单的查询一次es的所有索引信息，然后报错如下 java.io.IOException: listener timeout after waiting for [60000] ms at org.elasticsearch.client.RestClient$SyncResponseListener.get(RestClient.java:912) at org.elasticsearch.client.RestClient.performRequest(RestClient.java:23.
linux下报ora-12504,ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA .
weixin_33518565的博客
05-26 3391
在配置oracle监听的时候竟然报了错：ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA以下是我报错的配置：listener.ora的配置：[oracle@sm2 admin]$ cat listener.oraLISTENER = (DESCRIPTION_LIST = (DESCRIPTION =(AD...
read by other session等待事件
kelly1984的专栏
11-13 1万+
这个等待时间今天碰到，回忆了一下这个等待事件的原理 和解决思路并总结一下。   read by other session Definition: When information is requested from the database, Oracle will first read the data from disk into the database buffer cache.
gc buffer busy等待事件
kelly1984的专栏
12-04 1万+
这2天RAC生产库出现gc buffer busy 等待事件,出现的应用情况为出单缓慢。下面是官方对此的解释： gc buffer busy   This wait event, also known as global cache buffer busy prior to Oracle 10g,    specifies the time the remote instance local
enq: TX - index contention等待事件
kelly1984的专栏
02-26 4946
enq: TX - index contention常由 大量并发INSERT 造成的 index split 引起。下面截取部分有问题的 awr：       可以看到在awr中 发生过 3412次的 index leaf block split ， 15次的branch block split    建议： 1. 定期对 DLog 相关的索引执行 c
Linux更改oracle用户组实验
kelly1984的专栏
09-27 4638
---通常我们安装oracle数据库是建立oracle用户。并且用户加入dba组 --但是我们要改了oracle的dba组为dba1 ，数据库使用操作系统认证还能 --正常登录吗？ --回答是不行的。需要重新编译下我们的oracle可执行文件 --下面是我的操作步骤。 1：查看oracle 用户的具体情况，主组为dba [root@repositorydb gc-1024]# id
/data/oracle/diag/tnslsnr/Oracle/listener/alert
最新发布
08-30
"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值