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