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

发布时间：2020-06-24 22:15:02 来源：网络阅读：1271 作者：striong 栏目：关系型数据库

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

eth2 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

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

在节点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

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

向AI问一下细节

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

猜你喜欢

最新资讯

相关推荐

相关标签