028-86922220

建站动态

根据您的个性需求进行定制 先人一步 抢占小程序红利时代

oracle11gRAC如何修改PUBLIC-IP、VIP、PRIV-IP、SCAN-IP

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

成都创新互联主要从事成都网站建设、网站建设、网页设计、企业做网站、公司建网站等业务。立足成都服务黄浦,10余年网站建设经验,价格优惠、服务专业,欢迎来电咨询建站服务:18982081108


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文件

Name           Type           Target    State     Host          


4.      关闭数据及CRS

database -d tan  

2个节点都需要停掉CRS

with the CRSdaemon.  

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

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

"eth0"  

7.      集群启动CRS

check crs  

 等一会再看

check crs  

8.      使用oifcfg修改public-IP

[root@node1 ~]# oifcfg getif

eth0 192.168.150.0  global  public

eth2 172.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

eth2 172.168.146.0  global  cluster_interconnect

eth0 192.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

eth2 172.168.146.0  global  cluster_interconnect

eth0 192.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"  

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”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注创新互联行业资讯频道!


本文题目:oracle11gRAC如何修改PUBLIC-IP、VIP、PRIV-IP、SCAN-IP
文章网址:http://www.tsicrk.com/article/pjjpso.html

其他资讯

让你的专属顾问为你服务

2.2745s