In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
DB: RAC 11.2.0.4.3
OS: RHEL 5.4
IP information before modification
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
Modified IP information
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. Stop all oracle processes such as database instances, cluster services, etc.
[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
Node 1 stops the has process
[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.
Node 2 stops the has process
[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.
two。 Modify server IP address
Node 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
Node 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. Modify / etc/hosts parsing (in this case there is no configuration of DNS, so you only need to modify the file)
Node 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
Node 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
After the modification is completed, restart the network of the two servers and test address connectivity
Node 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 ms 0.147 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 ms 0.011 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 ms 0.328 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 ms 0.354 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
Node 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 ms 0.406 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 ms 0.307 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 ms 0.027 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 ms 0.022 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
It should be noted here that rac-scan must be an unoccupied address, that is, ping is impassable
4. All nodes start 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. Reconfigure IP information
View configuration information on one of the nodes
[root@rac1 grid] # bin/oifcfg getif
Eth0 172.18.130.0 global public
Eth2 192.168.1.0 global cluster_interconnect
Modify configuration information on one of the nodes
[root@rac1 grid] # bin/oifcfg delif-global eth0
[root@rac1 grid] # bin/oifcfg setif-global eth0/172.18.130.0:public
View configuration information on all nodes
[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
Stop the listening and vip services of all nodes on node 1 and modify the vip configuration
[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. Modify monitoring configuration information
[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. Modify 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. Start 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
Test:
Client tnsnames.ora configuration:
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
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.