oracle 10G RAC之VIP探討(1)
2024-08-29 13:37:23
供稿：網友
1.測試環境 two nodes RAC in vmware gsx2.1 for linux
系統環境：Redhat EnterPRise Linux AD 3 Update 2(kernel:2.4.21-15.EL)
Oracle環境: oracle 10.0.2 for linux x86
網絡環境：
node public network private network Vip network node1 192.168.0.61 192.168.1.1 192.168.0.60node2 192.168.0.62 192.168.1.2 192.168.0.59節點 hosts files
#cat /etc/hosts# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.0.61 DB1PUB DB1PUB.SHIMU.COM.CN
192.168.0.62 DB2PUB DB2PUB.SHIMU.COM.CN
192.168.0.60 VIPDB.SHIMU.COM.CN
192.168.0.59 VIPDB2.SHIMU.COM.CN
192.168.1.1 DB1
192.168.1.2 DB2instance: RAC1 ,RAC2
service : RAC.SHIMU.COM.CN2.網絡環境研究正常的兩nodes的10G RAC網絡環境應該是有6個ip(除了loopback),每個機器包括3個ip其正常的運行環境的網絡環境
通過ifconfig 得到網絡環境
node1:
[root@DB1PUB root]# ifconfig -a
eth0 Link encap:Ethernet HWaddr 00:50:56:40:00:7A
inet addr:192.168.0.61 Bcast:192.168.0.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:43817 errors:0 dropped:0 overruns:0 frame:0
TX packets:38627 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:23218286 (22.1 Mb) TX bytes:21836943 (20.8 Mb)
Interrupt:9 Base address:0x10c0eth0:1 Link encap:Ethernet HWaddr 00:50:56:40:00:7A
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:26861 errors:0 dropped:0 overruns:0 frame:0
TX packets:24224 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:12344753 (11.7 Mb) TX bytes:17367061 (16.5 Mb)
Interrupt:9 Base address:0x10c0eth1 Link encap:Ethernet HWaddr 00:50:56:40:00:7B
inet addr:192.168.1.1 Bcast:192.168.1.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:26861 errors:0 dropped:0 overruns:0 frame:0
TX packets:24224 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:12344753 (11.7 Mb) TX bytes:17367061 (16.5 Mb)
Interrupt:14 Base address:0x10e0lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:23128 errors:0 dropped:0 overruns:0 frame:0
TX packets:23128 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:2611715 (2.4 Mb) TX bytes:2611715 (2.4 Mb)node2:
[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:46454 errors:0 dropped:0 overruns:0 frame:0
TX packets:36730 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:24482851 (23.3 Mb) TX bytes:20281527 (19.3 Mb)
Interrupt:9 Base address:0x10c0
eth0: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:31258 errors:0 dropped:0 overruns:0 frame:0
TX packets:19194 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:19952760 (19.0 Mb) TX bytes:9559431 (9.1 Mb)
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:31258 errors:0 dropped:0 overruns:0 frame:0
TX packets:19194 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:19952760 (19.0 Mb) TX bytes:9559431 (9.1 Mb)
Interrupt:14 Base address:0x10e0
2.listener研究
10G的listener也做了改動參見如下:
# listener.ora.db2pub Network Configuration File: /oracle/10g2/network/admin/listener.ora.db2pub
# Generated by Oracle configuration tools.LISTENER_DB1PUB =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.61)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.60)(PORT = 1521))
)
)
)SID_LIST_LISTENER_DB2PUB =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/10g2)
(PROGRAM = extproc)
)
)此時oracle系統的監聽器是同時監聽public,和vip地址一下是listener的node1的監聽信息[oracle@DB1PUB oracle]$ lsnrctl statu DB1PUBLSNRCTL for Linux: Version 10.1.0.2.0 - ProdUCtion on 12-JUL-2004 20:51:21Copyright (c) 1991, 2004, Oracle. All rights reserved.Connecting to (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=DB1PUB.SHIMU.COM.CN))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.61)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER_DB1PUB
Version TNSLSNR for Linux: Version 10.1.0.2.0 - Production
Start Date 12-JUL-2004 19:40:28
Uptime 0 days 1 hr. 10 min. 53 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/10g2/network/admin/listener.ora
Listener Log File /oracle/10g2/network/log/listener_db1pub.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.60)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.61)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DB1PUB)(PORT=8080))(Presentation=HTTP)(session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DB1PUB)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "RAC.SHIMU.COM.CN" has 2 instance(s).
Instance "RAC1", status READY, has 2 handler(s) for this service...
Instance "RAC2", status READY, has 1 handler(s) for this service...
Service "RACXDB.SHIMU.COM.CN" has 2 instance(s).
Instance "RAC1", status READY, has 1 handler(s) for this service...
Instance "RAC2", status READY, has 1 handler(s) for this service...
The command completed successfully
其中多了監聽8080和2100起具體作用還值得研究
