小编给大家分享一下oracle11g RAC如何修改PUBLIC-IP、VIP、PRIV-IP、SCAN-IP,相信大部分人都还不怎么了解,因此分享这篇文章给大家参考一下,希望大家阅读完这篇文章后大有收获,下面让我们一起去了解一下吧!


1.IP修改规划

hostname

修改前

修改后

Public-ip

Node1

192.168.150.11

192.168.114.11

Node2

192.168.150.12

192.168.114.12

VIP

Node1

192.168.150.13

192.168.114.13

Node2

192.168.150.14

192.168.114.14

SCAN-IP

Node1

Node2

192.168.150.15

192.168.114.15

192.168.150.16

192.168.114.16

192.168.150.17

192.168.114.17

Priv-ip

Node1

172.168.146.101

172.168.146.11

Node2

172.168.146.102

172.168.146.12

2.修改前hosts文件

NameTypeTargetStateHost

------------------------------------------------------------

ora.CRS.dgora....up.typeONLINEONLINEnode1

ora.DATA.dgora....up.typeONLINEONLINEnode1

ora....ER.lsnrora....er.typeONLINEONLINEnode1

ora.LSNR2.lsnrora....er.typeONLINEONLINEnode1

ora....N1.lsnrora....er.typeONLINEONLINEnode2

ora....N2.lsnrora....er.typeONLINEONLINEnode1

ora....N3.lsnrora....er.typeONLINEONLINEnode1

ora.LSNR3.lsnrora....er.typeONLINEONLINEnode1

ora.asmora.asm.typeONLINEONLINEnode1

ora.cvuora.cvu.typeONLINEONLINEnode1

ora.gsdora.gsd.typeONLINEOFFLINE

ora....networkora....rk.typeONLINEONLINEnode1

ora....SM1.asmapplicationONLINEONLINEnode1

ora....E1.lsnrapplicationONLINEONLINEnode1

ora....E1.lsnrapplicationONLINEONLINEnode1

ora....E1.lsnrapplicationONLINEONLINEnode1

ora.node1.gsdapplicationONLINEOFFLINE

ora.node1.onsapplicationONLINEONLINEnode1

ora.node1.vipora....t1.typeONLINEONLINEnode1

ora....SM2.asmapplicationONLINEONLINEnode2

ora....E2.lsnrapplicationONLINEONLINEnode2

ora....E2.lsnrapplicationONLINEONLINEnode2

ora....E2.lsnrapplicationONLINEONLINEnode2

ora.node2.gsdapplicationONLINEOFFLINE

ora.node2.onsapplicationONLINEONLINEnode2

ora.node2.vipora....t1.typeONLINEONLINEnode2

ora.oc4jora.oc4j.typeONLINEONLINEnode1

ora.onsora.ons.typeONLINEONLINEnode1

ora.scan1.vipora....ip.typeONLINEONLINEnode2

ora.scan2.vipora....ip.typeONLINEONLINEnode1

ora.scan3.vipora....ip.typeONLINEONLINEnode1

ora.tan.dbora....se.typeONLINEONLINEnode1

[root@node2~]#srvctlstatusdatabase-dtan

Instancetan1isrunningonnodenode1

Instancetan2isrunningonnodenode2


4.关闭数据及CRS

database-dtan

[root@node1~]#srvctlstatusdatabase-dtan

Instancetan1isnotrunningonnodenode1

Instancetan2isnotrunningonnodenode2

[root@node1~]#srvctlstoplistener-nnode1

[root@node1~]#srvctlstoplistener-nnode2

[root@node1~]#srvctlstopvip-nnode1

[root@node1~]#srvctlstopvip-nnode2

PRCC-1017:node2-vipwasalreadystoppedonnode2

PRCR-1005:Resourceora.node2.vipisalreadystopped

[root@node1~]#srvctlstopscan_listener

[root@node1~]#srvctlstopscan

2个节点都需要停掉CRS

withtheCRSdaemon.

[root@node1~]#crsctlcheckcrs

CRS-4639:CouldnotcontactOracleHighAvailabilityServices

[root@node1~]#crsctlcheckcluster

CRS-4639:CouldnotcontactOracleHighAvailabilityServices

CRS-4000:CommandCheckfailed,orcompletedwitherrors.

[root@node1~]#

[root@node1~]#ps-ef|grepgrid

root1406226218023:46pts/200:00:00grepgrid

5.修改2个节点hosts中的public-ip,vip,scan-ip

暂不修改Priv-ip,修改后如下:

"eth0"

BOOTPROTO="static"

HWADDR="00:0C:29:7D:D1:29"

NM_CONTROLLED="yes"

ONBOOT="yes"

TYPE="Ethernet"

IPADDR=192.168.114.11

NETMASK=255.255.255.0

GATEWAY=192.168.115.254

~

[root@node2~]#cd/etc/sysconfig/network-scripts/

[root@node2network-scripts]#viifcfg-eth0

DEVICE="eth0"

BOOTPROTO=static

ONBOOT="yes"

TYPE="Ethernet"

IPADDR=192.168.114.12

NETMASK=255.255.255.0

GATEWAY=192.168.114.254

HWADDR="00:50:56:27:B7:1A"

7.集群启动CRS

checkcrs

CRS-4638:OracleHighAvailabilityServicesisonline

CRS-4535:CannotcommunicatewithClusterReadyServices

CRS-4529:ClusterSynchronizationServicesisonline

CRS-4534:CannotcommunicatewithEventManager

等一会再看

checkcrs

CRS-4638:OracleHighAvailabilityServicesisonline

CRS-4537:ClusterReadyServicesisonline

CRS-4529:ClusterSynchronizationServicesisonline

CRS-4533:EventManagerisonline

[root@node1~]#crs_stat-t

NameTypeTargetStateHost

------------------------------------------------------------

ora.CRS.dgora....up.typeONLINEONLINEnode1

ora.DATA.dgora....up.typeONLINEONLINEnode1

ora....ER.lsnrora....er.typeOFFLINEOFFLINE

ora.LSNR2.lsnrora....er.typeOFFLINEOFFLINE

ora....N1.lsnrora....er.typeOFFLINEOFFLINE

ora....N2.lsnrora....er.typeOFFLINEOFFLINE

ora....N3.lsnrora....er.typeOFFLINEOFFLINE

ora.LSNR3.lsnrora....er.typeOFFLINEOFFLINE

ora.asmora.asm.typeONLINEONLINEnode1

ora.cvuora.cvu.typeONLINEOFFLINE

ora.gsdora.gsd.typeONLINEOFFLINE

ora....networkora....rk.typeONLINEOFFLINE

ora....SM1.asmapplicationONLINEONLINEnode1

ora....E1.lsnrapplicationOFFLINEOFFLINE

ora....E1.lsnrapplicationOFFLINEOFFLINE

ora....E1.lsnrapplicationOFFLINEOFFLINE

ora.node1.gsdapplicationONLINEOFFLINE

ora.node1.onsapplicationONLINEOFFLINE

ora.node1.vipora....t1.typeOFFLINEOFFLINE

ora....SM2.asmapplicationONLINEONLINEnode2

ora....E2.lsnrapplicationOFFLINEOFFLINE

ora....E2.lsnrapplicationOFFLINEOFFLINE

ora....E2.lsnrapplicationOFFLINEOFFLINE

ora.node2.gsdapplicationONLINEOFFLINE

ora.node2.onsapplicationONLINEOFFLINE

ora.node2.vipora....t1.typeOFFLINEOFFLINE

ora.oc4jora.oc4j.typeONLINEONLINEnode1

ora.onsora.ons.typeONLINEOFFLINE

ora.scan1.vipora....ip.typeOFFLINEOFFLINE

ora.scan2.vipora....ip.typeOFFLINEOFFLINE

ora.scan3.vipora....ip.typeOFFLINEOFFLINE

ora.tan.dbora....se.typeOFFLINEOFFLINE

8.使用oifcfg修改public-IP

[root@node1 ~]# oifcfg getif

eth0192.168.150.0 global public

eth2172.168.146.0 global cluster_interconnect

[root@node1 ~]#oifcfg delif -global eth0

[root@node1 ~]#oifcfg setif -global eth0/192.168.114.0:public

[root@node1 ~]# oifcfg getif

eth2172.168.146.0 global cluster_interconnect

eth0192.168.114.0 global public

9.使用srvctl修改VIP

[root@node2 ~]# srvctl stop database -d tan-o immediate

PRCC-1016 : tan was already stopped

[root@node2 ~]# srvctl config vip -n node1

VIP exists:/node1-vip/192.168.114.13/192.168.150.0/255.255.255.0/eth0, hosting node node1

[root@node2 ~]# srvctl config vip -n node2

VIP exists:/node2-vip/192.168.114.14/192.168.150.0/255.255.255.0/eth0, hosting node node2

[root@node2 ~]# srvctl stop listener -nnode1

[root@node2 ~]# srvctl stop listener -nnode2

[root@node2 ~]# srvctl stop vip -n node1

[root@node2 ~]# srvctl stop vip -n node2

[root@node2 ~]# srvctlmodify nodeapps -n node1 -A 192.168.114.13/255.255.255.0/eth0

[root@node2 ~]# srvctlmodify nodeapps -n node2 -A 192.168.114.14/255.255.255.0/eth0

[root@node2 ~]# srvctl config vip -n node1

VIP exists:/node1-vip/192.168.114.13/192.168.114.0/255.255.255.0/eth0, hosting node node1

[root@node2 ~]# srvctl config vip -n node2

VIP exists:/node2-vip/192.168.114.14/192.168.114.0/255.255.255.0/eth0, hosting node node2

10. 使用srvctl修改SCANIP

修改SCANIP

[root@node1 ~]# srvctl config scan

SCAN name: scanip, Network:1/192.168.114.0/255.255.255.0/eth0

SCAN VIP name: scan1, IP:/scanip/192.168.150.15

SCAN VIP name: scan2, IP:/scanip/192.168.150.16

SCAN VIP name: scan3, IP:/scanip/192.168.150.17

[root@node1 ~]# srvctl stop scan_listener

[root@node1 ~]# srvctl stop scan

[root@node1 ~]# srvctlmodify scan -n scanip

注:这儿的scanip是/etc/hosts里的名字

192.168.114.15 scanip

192.168.114.16 scanip

192.168.114.17 scanip

检查确认:

[root@node1 ~]# srvctl config scan

SCAN name: scanip, Network:1/192.168.114.0/255.255.255.0/eth0

SCAN VIP name: scan1, IP:/scanip/192.168.114.15

SCAN VIP name: scan2, IP:/scanip/192.168.114.16

SCAN VIP name: scan3, IP:/scanip/192.168.114.17

启动scan

[root@node1 ~]# srvctl start scan

[root@node1 ~]# srvctl start scan_listener

11. 使用oifcfg修改私有PRIV-IP

[root@node1 ~]# oifcfg getif

eth2172.168.146.0 global cluster_interconnect

eth0192.168.114.0 global public

是一个网段,这儿就不用改了,如果需要改,参考修改public-ip

修改2个节点/etc/hosts

172.168.146.11 node1-priv

172.168.146.12 node2-priv

修改2个节点eth2物理地点

"eth2"

BOOTPROTO="static"

HWADDR="00:0C:29:7D:D1:33"

NM_CONTROLLED="yes"

ONBOOT="yes"

TYPE="Ethernet"

IPADDR=172.168.146.11

NETMASK=255.255.255.0

GATEWAY=172.168.150.1

~

[root@node2network-scripts]#viifcfg-eth2

DEVICE="eth2"

BOOTPROTO="static"

HWADDR="00:50:56:3E:DF:A5"

NM_CONTROLLED="yes"

ONBOOT="yes"

TYPE="Ethernet"

IPADDR=172.168.146.12

NETMASK=255.255.255.0

GATEWAY=172.168.150.1

12. 逐个启动相关进程

[root@node1 ~]# srvctl start vip -n node1

[root@node1 ~]# srvctl start vip -n node2

[root@node1 ~]# srvctl start listener -nnode1

[root@node1 ~]# srvctl start listener -nnode2

[root@node2 ~]# srvctl start database -dtan

[root@node1 ~]# srvctl status database -dtan

Instance tan1 is running on node node1

Instance tan2 is running on node node2

13. 修改参数local_listener

alter system setlocal_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.114.13)(PORT=1524))))'sid='tan1';

alter system setlocal_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.114.14)(PORT=1524))))'sid='tan2';

14. 测试

SQL> conn system/oracle@tanx

已连接。

以上是“oracle11g RAC如何修改PUBLIC-IP、VIP、PRIV-IP、SCAN-IP”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注亿速云行业资讯频道!