【IT168 服务器学院】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.60

　　node2 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 DB2

　　instance: RAC1 ,RAC2
　　service : RAC.SHIMU.COM.CN

　　2.网络环境研究

　　正常的两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:0x10c0

　　eth0: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:0x10c0

　　eth1 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:0x10e0

　　lo 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:0x10c0

　　eth1 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 DB1PUB

　　LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 12-JUL-2004 20:51:21

　　Copyright (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起具体作用还值得研究