DB : RAC 11.2.0.4.3
OS: RHEL 5.4
修改前IP信息
RAC1 | RAC2 | |
PUBLIC IP | 172.18.130.81 | 172.18.130.82 |
PRIVATE IP | 192.168.1.11 | 192.168.1.12 |
VIP | 172.18.130.71 | 172.18.130.72 |
SCAN-IP | 172.18.130.80 |
修改后IP信息
RAC1 | RAC2 | |
PUBLIC IP | 172.18.130.201 | 172.18.130.202 |
PRIVATE IP | 192.168.1.11 | 192.168.1.12 |
VIP | 172.18.130.211 | 172.18.130.212 |
SCAN-IP | 172.18.130.200 |
1.停止数据库实例、集群服务等所有oracle进程
[grid@rac1 ~]$ srvctl stop database -d rac
[grid@rac1 ~]$ crsctl stop cluster -all
CRS-4563: Insufficient user privileges.
CRS-4000: Command Stop failed, or completed with errors.
[grid@rac1 ~]$ su -
Password:
[root@rac1 ~]# cd /u01/app/11.2.0.4/grid/
[root@rac1 grid]# bin/crsctl stop cluster -all
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.OCRVOTE.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.crsd' on 'rac2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac2'
CRS-2673: Attempting to stop 'ora.oc4j' on 'rac2'
CRS-2673: Attempting to stop 'ora.cvu' on 'rac2'
CRS-2673: Attempting to stop 'ora.OCRVOTE.dg' on 'rac2'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac2'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac2'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rac2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac2'
CRS-2677: Stop of 'ora.cvu' on 'rac2' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac2'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac2'
CRS-2677: Stop of 'ora.FRA.dg' on 'rac2' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'rac2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac2' succeeded
CRS-2677: Stop of 'ora.rac2.vip' on 'rac2' succeeded
CRS-2677: Stop of 'ora.scan1.vip' on 'rac2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'rac2' succeeded
CRS-2677: Stop of 'ora.OCRVOTE.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac1'
CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.OCRVOTE.dg' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac2'
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac2'
CRS-2677: Stop of 'ora.ons' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac2'
CRS-2677: Stop of 'ora.net1.network' on 'rac2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac2' has completed
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.crsd' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac2'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac2'
CRS-2673: Attempting to stop 'ora.asm' on 'rac2'
CRS-2677: Stop of 'ora.evmd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac2'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac2'
CRS-2677: Stop of 'ora.cssd' on 'rac2' succeeded
节点1停止has进程
[root@rac1 grid]# bin/crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.crf' on 'rac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
节点2停止has进程
[root@rac2 grid]# bin/crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac2'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac2'
CRS-2673: Attempting to stop 'ora.crf' on 'rac2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac2'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac2' succeeded
CRS-2677: Stop of 'ora.crf' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac2'
CRS-2677: Stop of 'ora.mdnsd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac2'
CRS-2677: Stop of 'ora.gpnpd' on 'rac2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rac1 grid]# bin/crsctl stat res -t -init
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Status failed, or completed with errors.
[root@rac1 grid]# bin/crs_stat -t
CRS-0184: Cannot communicate with the CRS daemon.
2.修改服务器IP地址
节点1
[root@rac1 grid]# vi /etc/sysconfig/network-scripts/ifcfg-eth0
# Intel Corporation 82545EM Gigabit Ethernet Controller (Copper)
DEVICE=eth0
HWADDR=00:50:56:b4:7a:4d
BOOTPROTO=static
BROADCAST=172.18.130.255
#IPADDR=172.18.130.81
IPADDR=172.18.130.201
NETMASK=255.255.255.0
NETWORK=172.18.130.0
ONBOOT=yes
节点2
[root@rac2 grid]# vi /etc/sysconfig/network-scripts/ifcfg-eth0
# Intel Corporation 82545EM Gigabit Ethernet Controller (Copper)
DEVICE=eth0
HWADDR=00:50:56:b4:7a:50
DEVICE=eth0
BOOTPROTO=static
#IPADDR=172.18.130.82
IPADDR=172.18.130.202
NETMASK=255.255.255.0
NETWORK=172.18.130.0
ONBOOT=yes
3.修改/etc/hosts解析(本例无配置DNS,故只需要修改该文件即可)
节点1
[root@rac1 grid]# vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost
::1 localhost6.localdomain6 localhost6
#172.18.130.81 rac1
#172.18.130.71 rac1-vip
#192.168.1.11 rac1-priv
#172.18.130.82 rac2
#172.18.130.72 rac2-vip
#192.168.1.12 rac2-priv
#172.18.130.80 rac-scan
172.18.130.201 rac1
172.18.130.211 rac1-vip
192.168.1.11 rac1-priv
172.18.130.202 rac2
172.18.130.212 rac2-vip
192.168.1.12 rac2-priv
172.18.130.200 rac-scan
节点2
[root@rac2 grid]# vi /etc/hosts
# that require network functionality will fail.
127.0.0.1 localhost
::1 localhost6.localdomain6 localhost6
#172.18.130.81 rac1
#172.18.130.71 rac1-vip
#192.168.1.11 rac1-priv
#172.18.130.82 rac2
#172.18.130.72 rac2-vip
#192.168.1.12 rac2-priv
#172.18.130.80 rac-scan
172.18.130.201 rac1
172.18.130.211 rac1-vip
192.168.1.11 rac1-priv
172.18.130.202 rac2
172.18.130.212 rac2-vip
192.168.1.12 rac2-priv
172.18.130.200 rac-scan
修改完成后,重启2台服务器网络,并测试地址联通情况
节点1
[root@rac1 ~]# ping rac1
PING rac1 (172.18.130.201) 56(84) bytes of data.
64 bytes from rac1 (172.18.130.201): icmp_seq=1 ttl=64 time=0.147 ms
--- rac1 ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.147/0.147/0.147/0.000 ms
[root@rac1 ~]# ping rac1-priv
PING rac1-priv (192.168.1.11) 56(84) bytes of data.
64 bytes from rac1-priv (192.168.1.11): icmp_seq=1 ttl=64 time=0.011 ms
--- rac1-priv ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.011/0.011/0.011/0.000 ms
[root@rac1 ~]# ping rac2
PING rac2 (172.18.130.202) 56(84) bytes of data.
64 bytes from rac2 (172.18.130.202): icmp_seq=1 ttl=64 time=0.328 ms
--- rac2 ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.328/0.328/0.328/0.000 ms
[root@rac1 ~]# ping rac2-priv
PING rac2-priv (192.168.1.12) 56(84) bytes of data.
64 bytes from rac2-priv (192.168.1.12): icmp_seq=1 ttl=64 time=0.354 ms
--- rac2-priv ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.354/0.354/0.354/0.000 ms
[root@rac1 ~]# ping rac-scan
PING rac-scan (172.18.130.200) 56(84) bytes of data.
From rac1 (172.18.130.201) icmp_seq=2 Destination Host Unreachable
From rac1 (172.18.130.201) icmp_seq=3 Destination Host Unreachable
From rac1 (172.18.130.201) icmp_seq=4 Destination Host Unreachable
--- rac-scan ping statistics ---
4 packets transmitted, 0 received, +3 errors, 100% packet loss, time 3000ms
, pipe 3
节点2
[root@rac2 ~]# ping rac1
PING rac1 (172.18.130.201) 56(84) bytes of data.
64 bytes from rac1 (172.18.130.201): icmp_seq=1 ttl=64 time=0.406 ms
--- rac1 ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.406/0.406/0.406/0.000 ms
[root@rac2 ~]# ping rac1-priv
PING rac1-priv (192.168.1.11) 56(84) bytes of data.
64 bytes from rac1-priv (192.168.1.11): icmp_seq=1 ttl=64 time=0.307 ms
--- rac1-priv ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.307/0.307/0.307/0.000 ms
[root@rac2 ~]# ping rac2
PING rac2 (172.18.130.202) 56(84) bytes of data.
64 bytes from rac2 (172.18.130.202): icmp_seq=1 ttl=64 time=0.027 ms
--- rac2 ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.027/0.027/0.027/0.000 ms
[root@rac2 ~]# ping rac2-priv
PING rac2-priv (192.168.1.12) 56(84) bytes of data.
64 bytes from rac2-priv (192.168.1.12): icmp_seq=1 ttl=64 time=0.022 ms
--- rac2-priv ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.022/0.022/0.022/0.000 ms
[root@rac2 ~]# ping rac-scan
PING rac-scan (172.18.130.200) 56(84) bytes of data.
--- rac-scan ping statistics ---
1 packets transmitted, 0 received, 100% packet loss, time 0ms
这里要注意的是,rac-scan必须是没被占用的地址,即ping不通的
4.所有节点启动crs
[root@rac1 grid]# bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@rac2 grid]# bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@rac1 grid]# bin/crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE rac1
ora.FRA.dg ora....up.type ONLINE ONLINE rac1
ora....ER.lsnr ora....er.type ONLINE ONLINE rac1
ora....N1.lsnr ora....er.type ONLINE ONLINE rac1
ora.OCRVOTE.dg ora....up.type ONLINE ONLINE rac1
ora.asm ora.asm.type ONLINE ONLINE rac1
ora.cvu ora.cvu.type ONLINE ONLINE rac1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE rac1
ora.oc4j ora.oc4j.type ONLINE ONLINE rac1
ora.ons ora.ons.type ONLINE ONLINE rac1
ora.rac.db ora....se.type OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip ora....t1.type ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip ora....t1.type ONLINE ONLINE rac2
ora....ry.acfs ora....fs.type ONLINE ONLINE rac1
ora.scan1.vip ora....ip.type ONLINE ONLINE rac1
5.重新配置IP信息
在其中一节点查看配置信息
[root@rac1 grid]# bin/oifcfg getif
eth0 172.18.130.0 global public
eth1 192.168.1.0 global cluster_interconnect
在其中一节点修改配置信息
[root@rac1 grid]# bin/oifcfg delif -global eth0
[root@rac1 grid]# bin/oifcfg setif -global eth0/172.18.130.0:public
在所有节点查看配置信息
[root@rac1 grid]# bin/oifcfg getif
eth1 192.168.1.0 global cluster_interconnect
eth0 172.18.130.0 global public
[root@rac2 grid]# bin/oifcfg getif
eth1 192.168.1.0 global cluster_interconnect
eth0 172.18.130.0 global public
[root@rac1 grid]# bin/srvctl config vip -n rac1
VIP exists: /rac1-vip/172.18.130.211/172.18.130.0/255.255.255.0/eth0, hosting node rac1
[root@rac1 grid]# bin/srvctl config vip -n rac2
VIP exists: /rac2-vip/172.18.130.212/172.18.130.0/255.255.255.0/eth0, hosting node rac2
在节点1上停掉所有节点的监听和vip服务并修改vip配置
[root@rac1 grid]# bin/srvctl stop listener -n rac1
[root@rac1 grid]# bin/srvctl stop listener -n rac2
[root@rac1 grid]# bin/srvctl stop vip -n rac1
[root@rac1 grid]# bin/srvctl stop vip -n rac2
[root@rac1 grid]# bin/srvctl modify nodeapps -n rac1 -A 172.18.130.211/255.255.255.0/eth0
[root@rac1 grid]# bin/srvctl modify nodeapps -n rac2 -A 172.18.130.212/255.255.255.0/eth0
[root@rac1 grid]# bin/srvctl config vip -n rac1
VIP exists: /rac1-vip/172.18.130.211/172.18.130.0/255.255.255.0/eth0, hosting node rac1
[root@rac1 grid]# bin/srvctl config vip -n rac2
VIP exists: /rac2-vip/172.18.130.212/172.18.130.0/255.255.255.0/eth0, hosting node rac2
6.修改监听配置信息
[grid@rac1 admin]$ cd $TNS_ADMIN
[grid@rac1 admin]$ cat listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
[grid@rac1 admin]$ cat endpoints_listener.ora
LISTENER_RAC1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=172.18.130.201)(PORT=1521)(IP=FIRST)))) # line added by Agent
7.修改SCAN
[root@rac1 grid]# bin/srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
[root@rac1 grid]# bin/srvctl config scan
SCAN name: rac-scan, Network: 1/172.18.130.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /rac-scan/172.18.130.80
[root@rac1 grid]# bin/srvctl stop scan_listener
[root@rac1 grid]# bin/srvctl stop scan
[root@rac1 grid]# bin/srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
[root@rac1 grid]# bin/srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running
[root@rac1 grid]# bin/srvctl modify scan -nrac-scan
[root@rac1 grid]# bin/srvctl config scan
SCAN name: rac-scan, Network: 1/172.18.130.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /rac-scan/172.18.130.200
[root@rac1 grid]# bin/srvctl start scan
[root@rac1 grid]# bin/srvctl start scan_listener
8.启动db
[root@rac1 grid]# bin/srvctl start database -d rac
[root@rac1 grid]# bin/crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.FRA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.OCRVOTE.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.registry.acfs
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2
ora.cvu
1 ONLINE ONLINE rac1
ora.oc4j
1 ONLINE ONLINE rac1
ora.rac.db
1 ONLINE ONLINE rac1 Open
2 ONLINE ONLINE rac2 Open
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac2
[root@rac1 grid]# bin/crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE rac1
ora.FRA.dg ora....up.type ONLINE ONLINE rac1
ora....ER.lsnr ora....er.type ONLINE ONLINE rac1
ora....N1.lsnr ora....er.type ONLINE ONLINE rac2
ora.OCRVOTE.dg ora....up.type ONLINE ONLINE rac1
ora.asm ora.asm.type ONLINE ONLINE rac1
ora.cvu ora.cvu.type ONLINE ONLINE rac1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE rac1
ora.oc4j ora.oc4j.type ONLINE ONLINE rac1
ora.ons ora.ons.type ONLINE ONLINE rac1
ora.rac.db ora....se.type ONLINE ONLINE rac1
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip ora....t1.type ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip ora....t1.type ONLINE ONLINE rac2
ora....ry.acfs ora....fs.type ONLINE ONLINE rac1
ora.scan1.vip ora....ip.type ONLINE ONLINE rac2
测试:
客户端tnsnames.ora配置:
RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.130.200)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
)
)
[oracle@striong admin]$ tnsping rac
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 21-MAR-2014 20:06:31
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.130.200)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rac)))
OK (20 msec)
[oracle@striong admin]$ sqlplus /nolog
SQL> conn wsq/wsq@rac
Connected.
SQL> select instance_name from v$instance;
INSTANCE_NAME
--------------------------------
rac1
SQL> conn wsq/wsq@rac
Connected.
SQL> select instance_name from v$instance;
INSTANCE_NAME
--------------------------------
rac2
转载于:https://blog.51cto.com/johnnywong/1619396