oracle 10G RAC之VIP探討(2)
2024-08-29 13:37:23
供稿：網(wǎng)友
3.tnsnames的研究
以下時服務(wù)RAC.SHIMU.COM.CN的tnsnames的配置
# tnsnames.ora.db2pub Network Configuration File: /Oracle/10g2/network/admin/tnsnames.ora.db2pub
# Generated by Oracle configuration tools. RAC =
(DESCRipTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.158.0.60)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.59)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC.SHIMU.COM.CN)
)
)LISTENERS_RAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.60)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.59)(PORT = 1521))
)RAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.59)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC.SHIMU.COM.CN)
(INSTANCE_NAME = RAC2)
)
)RAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = VIPDB.SHIMU.COM.CN)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC.SHIMU.COM.CN)
(INSTANCE_NAME = RAC1)
)
)哈哈，終于發(fā)現(xiàn)秘密了,所有cluster的listener和service都是監(jiān)聽VIP的地址。。。
呵呵。等著好戲吧。。。
4.故障測試停掉node1,此時所有的連接都正常工作，檢測node2的網(wǎng)絡(luò)裝況，呵呵，果不出所然：
[root@DB2PUB root]# ifconfig -a
eth0 Link encap:Ethernet HWaddr 00:50:56:40:00:5B
inet addr:192.168.0.62 Bcast:192.168.0.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:960 errors:0 dropped:0 overruns:0 frame:0
TX packets:70 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:284407 (277.7 Kb) TX bytes:4017 (3.9 Kb)
Interrupt:9 Base address:0x10c0eth0:1 Link encap:Ethernet HWaddr 00:50:56:40:00:5B
inet addr:192.168.0.59 Bcast:192.168.0.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:734 errors:0 dropped:0 overruns:0 frame:0
TX packets:227 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:268965 (262.6 Kb) TX bytes:9534 (9.3 Kb)
Interrupt:9 Base address:0x10c0eth0:2 Link encap:Ethernet HWaddr 00:50:56:40:00:5B
inet addr:192.168.0.60 Bcast:192.168.0.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:734 errors:0 dropped:0 overruns:0 frame:0
TX packets:227 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:268965 (262.6 Kb) TX bytes:9534 (9.3 Kb)
Interrupt:9 Base address:0x10c0eth1 Link encap:Ethernet HWaddr 00:50:56:40:00:5C
inet addr:192.168.1.2 Bcast:192.168.1.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:734 errors:0 dropped:0 overruns:0 frame:0
TX packets:227 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:268965 (262.6 Kb) TX bytes:9534 (9.3 Kb)
Interrupt:14 Base address:0x10e0
此時node2立即接管node1的VIP網(wǎng)絡(luò)地址，所有的連接透明的連到了后臺!!
