Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Changing IP 、 VIP 、 SCAN-IP ON RAC 11gR2

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.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report