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

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
网站URL：http://lswzjz.com/article/jijeso.html