溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務(wù)條款》
您好，登錄后才能下訂單哦！
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.停止數(shù)據(jù)庫實例、集群服務(wù)等所有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
節(jié)點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.
節(jié)點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.修改服務(wù)器IP地址
節(jié)點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é)點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，故只需要修改該文件即可）
節(jié)點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é)點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臺服務(wù)器網(wǎng)絡(luò)，并測試地址聯(lián)通情況
節(jié)點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é)點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é)點啟動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é)點查看配置信息
[root@rac1 grid]# bin/oifcfg getif
eth0 172.18.130.0 global public
eth2 192.168.1.0 global cluster_interconnect
在其中一節(jié)點修改配置信息
[root@rac1 grid]# bin/oifcfg delif -global eth0
[root@rac1 grid]# bin/oifcfg setif -global eth0/172.18.130.0:public
在所有節(jié)點查看配置信息
[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é)點1上停掉所有節(jié)點的監(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.啟動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
免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點不代表本網(wǎng)站立場，如果涉及侵權(quán)請聯(lián)系站長郵箱：is@yisu.com進行舉報，并提供相關(guān)證據(jù)，一經(jīng)查實，將立刻刪除涉嫌侵權(quán)內(nèi)容。
億速云公眾號
手機網(wǎng)站二維碼
