ChangingIP、VIP、SCAN-IPONRAC11gR2
DB : RAC 11.2.0.4.3
讓客戶滿意是我們工作的目標(biāo)，不斷超越客戶的期望值來(lái)自于我們對(duì)這個(gè)行業(yè)的熱愛。我們立志把好的技術(shù)通過(guò)有效、簡(jiǎn)單的方式提供給客戶，將通過(guò)不懈努力成為客戶在信息化領(lǐng)域值得信任、有價(jià)值的長(zhǎng)期合作伙伴，公司提供的服務(wù)項(xiàng)目有：域名申請(qǐng)、網(wǎng)絡(luò)空間、營(yíng)銷軟件、網(wǎng)站建設(shè)、滄州網(wǎng)站維護(hù)、網(wǎng)站推廣。
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.停止數(shù)據(jù)庫(kù)實(shí)例、集群服務(wù)等所有oracle進(jìn)程
[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
節(jié)點(diǎn)1停止has進(jìn)程
[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.
節(jié)點(diǎn)2停止has進(jìn)程
[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.修改服務(wù)器IP地址
節(jié)點(diǎn)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
節(jié)點(diǎn)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解析（本例無(wú)配置DNS，故只需要修改該文件即可）
節(jié)點(diǎn)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
節(jié)點(diǎn)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臺(tái)服務(wù)器網(wǎng)絡(luò)，并測(cè)試地址聯(lián)通情況
節(jié)點(diǎn)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
節(jié)點(diǎn)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.所有節(jié)點(diǎn)啟動(dòng)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信息
在其中一節(jié)點(diǎn)查看配置信息
[root@rac1 grid]# bin/oifcfg getif
eth0 172.18.130.0 global public
eth2 192.168.1.0 global cluster_interconnect
在其中一節(jié)點(diǎn)修改配置信息
[root@rac1 grid]# bin/oifcfg delif -global eth0
[root@rac1 grid]# bin/oifcfg setif -global eth0/172.18.130.0:public
在所有節(jié)點(diǎn)查看配置信息
[root@rac1 grid]# bin/oifcfg getif
eth2 192.168.1.0 global cluster_interconnect
eth0 172.18.130.0 global public
[root@rac2 grid]# bin/oifcfg getif
eth2 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
在節(jié)點(diǎn)1上停掉所有節(jié)點(diǎn)的監(jiān)聽和vip服務(wù)并修改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.修改監(jiān)聽配置信息
[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.啟動(dòng)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
測(cè)試：
客戶端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
分享名稱：ChangingIP、VIP、SCAN-IPONRAC11gR2
本文路徑：http://chinadenli.net/article30/jijeso.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供全網(wǎng)營(yíng)銷推廣、網(wǎng)站排名、商城網(wǎng)站、移動(dòng)網(wǎng)站建設(shè)、網(wǎng)站設(shè)計(jì)、軟件開發(fā)
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)
