[RAC] CRS一个node 挂掉 VIP漂移 造成监听停止，连接超慢
[oracle@rac2 bin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------ora....B1.inst application ONLINE ONLINE rac1ora....B2.inst application ONLINE OFFLINEora.RACDB.db application ONLINE ONLINE rac1ora....SM1.asm application ONLINE ONLINE rac1ora....C1.lsnr application ONLINE ONLINE rac1ora.rac1.gsd application ONLINE ONLINE rac1ora.rac1.ons application ONLINE ONLINE rac1ora.rac1.vip application ONLINE ONLINE rac1ora....SM2.asm application ONLINE OFFLINEora....C2.lsnr application ONLINE OFFLINEora.rac2.gsd application ONLINE ONLINE rac2ora.rac2.ons application ONLINE ONLINE rac2ora.rac2.vip application ONLINE ONLINE rac1 （rac2 VIP漂移到rac1）
[root@rac1 ~]# ifconfig
eth0 Link encap:Ethernet HWaddr 00:0C:29:79:F5:26
inet addr:192.168.100.100 Bcast:192.168.100.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe79:f526/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:134506 errors:1 dropped:1 overruns:0 frame.:0
TX packets:104859 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:82366223 (78.5 MiB) TX bytes:47574267 (45.3 MiB)
Interrupt:67 Base address:0x2400
eth0:1 Link encap:Ethernet HWaddr 00:0C:29:79:F5:26
inet addr:192.168.100.200 Bcast:192.168.100.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
Interrupt:67 Base address:0x2400
eth0:2 Link encap:Ethernet HWaddr 00:0C:29:79:F5:26
inet addr:192.168.100.201 Bcast:192.168.100.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
Interrupt:67 Base address:0x2400
eth1 Link encap:Ethernet HWaddr 00:0C:29:79:F5:30
inet addr:192.168.200.200 Bcast:192.168.200.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe79:f530/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:65077 errors:0 dropped:0 overruns:0 frame.:0
TX packets:50502 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:55048173 (52.4 MiB) TX bytes:28293824 (26.9 MiB)
Interrupt:59 Base address:0x2480
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:167653 errors:0 dropped:0 overruns:0 frame.:0
TX packets:167653 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:36421888 (34.7 MiB) TX bytes:36421888 (34.7 MiB)
C:\tnsping racdb
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-1月 -2011 15:25:49
Copyright (c) 1997, 2010, Oracle. All rights reserved.
已使用的参数文件:
D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.200)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.201)(PORT = 1521)) (LOAD_BALANCE = yes) (FAILOVER = on)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RACDB) (FAILOVER_MODE =(TYPE = select)(METHOD = basic))))
OK (1110 毫秒)
C:\>tnsping racdb
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-1月 -2011 15:26:44
Copyright (c) 1997, 2010, Oracle. All rights reserved.
已使用的参数文件:
D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.200)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.201)(PORT = 1521)) (LOAD_BALANCE = yes) (FAILOVER = on)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RACDB) (FAILOVER_MODE =(TYPE = select)(METHOD = basic))))
OK (0 毫秒)
C:\>tnsping racdb
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-1月 -2011 15:26:45
Copyright (c) 1997, 2010, Oracle. All rights reserved.
已使用的参数文件:
D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.200)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.201)(PORT = 1521)) (LOAD_BALANCE = yes) (FAILOVER = on)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RACDB) (FAILOVER_MODE =(TYPE = select)(METHOD = basic))))
OK (40 毫秒)
C:\>tnsping racdb
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-1月 -2011 15:26:46
Copyright (c) 1997, 2010, Oracle. All rights reserved.
已使用的参数文件:
D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.200)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.201)(PORT = 1521)) (LOAD_BALANCE = yes) (FAILOVER = on)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RACDB) (FAILOVER_MODE =(TYPE = select)(METHOD = basic))))
OK (20 毫秒)
C:\>tnsping racdb
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-1月 -2011 15:26:47
Copyright (c) 1997, 2010, Oracle. All rights reserved.
已使用的参数文件:
D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.200)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.201)(PORT = 1521)) (LOAD_BALANCE = yes) (FAILOVER = on)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RACDB) (FAILOVER_MODE =(TYPE = select)(METHOD = basic))))
OK (1110 毫秒)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24933693/viewspace-683131/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- SecureCRT的sz/rz工具包
- Oracle English words文档资料学习 生词摘录(不断更新中)
- [RAC] RAC环境 开启Archivelog 开启Flashback 归档与 ASM
- [ASM]command disallowed by current instance type 解决方法
- [ASM]]ASM功能详解
- [RAC]oracle admin目录dump文件占用很大空间
- [ASM] 查看 +ASM文件信息列表
- [RAC] Remove node from cluster steps
- [RAC] cluvfy用法及验证错误解决
- Oracle中NVL2 和NULLIF的用法[转]
