oracle11g RAC如何修改PUBLIC-IP、VIP、PRIV-IP、SCAN-IP
小编给大家分享一下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”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注亿速云行业资讯频道!
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。