[RAC] CRS一个node 挂掉 VIP漂移 造成监听停止，连接超慢

 oracle@rac2 bin]$ crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora....B1.inst application    ONLINE    ONLINE    rac1        

ora....B2.inst application    ONLINE    OFFLINE               

ora.RACDB.db   application    ONLINE    ONLINE    rac1        

ora....SM1.asm application    ONLINE    ONLINE    rac1        

ora....C1.lsnr application    ONLINE    ONLINE    rac1        

ora.rac1.gsd   application    ONLINE    ONLINE    rac1        

ora.rac1.ons   application    ONLINE    ONLINE    rac1        

ora.rac1.vip   application    ONLINE    ONLINE    rac1        

ora....SM2.asm application    ONLINE    OFFLINE               

ora....C2.lsnr application    ONLINE    OFFLINE              

ora.rac2.gsd   application    ONLINE    ONLINE    rac2        

ora.rac2.ons   application    ONLINE    ONLINE    rac2        

ora.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 毫秒)