资讯专栏INFORMATION COLUMN

上云采购季！| 2核2G4M爆款云服务器低至59元/年，更有多台、长期优惠，快来选购！

立即前往
首页/文章专栏/oracle 11g rac更换public ip、vip

oracle 11g rac更换public ip、vip

IT那活儿 / 1452人阅读
oracle 11g rac更换public ip、vip
一. 修改公网IP

公网 IP 的网段一旦发生改变，VIP 和 SCAN IP 也要随之发生改变

将公网 IP 的网段由 192.168.56.0 改为 192.168.60.0 子网掩码 255.255.255.0

1. 删除OCR网卡信息

从 OCR 中删除已有的的网卡信息，然后添加正确的信息

[grid@zrac1 ~]$ oifcfg delif -global bond0/192.168.56.0[grid@zrac1 ~]$ oifcfg setif -global bond0/192.168.60.0:public[grid@zrac1 ~]$ oifcfg getifbond1 10.10.10.0 global cluster_interconnectbond0 192.168.60.0 global public

注意：运行上面的命令时，需要集群在所有的节点 running，不然会报错

PRIF-32: Error in checking for profile availability for host racnode2CRS-02306: GPnP service on host "zrac2" not found.

PRIF-33: Failed to set or delete interface because hosts could not be discovCRS-02307: No GPnP services on requested remote hosts.

2. 修改网卡文件、/etc/hosts 文件

[root@zrac1 ~]# vim /etc/sysconfig/network-scripts/ifcfg-bond0DEVICE=bond0TYPE=EthernetONBOOT=yesBOOTPROTO=noneIPADDR=192.168.60.31NETMASK=255.255.255.0GATEWAY=192.168.60.1USERCTL=no

重启网卡 ifdown bond0;ifup bond0
#Public IP192.168.60.31 zrac1192.168.56.41 zrac2#Private IP10.10.10.31 zrac1-priv10.10.10.41 zrac2-priv# VIP192.168.56.35 zrac1-vip192.168.56.45 zrac2-vip# SCAN192.168.56.90 scan


二. 修改VIP

公网 IP 的网段发生改变，VIP 需要随之发生改变，从 10.2.0.3 开始，ASM/database 实例对 VIP 资源的依赖关系被 remove，所以修改VIP 时，不再需要关闭 ASM/database 实例，只有客户端连接在 VIP down 掉时会受影响，如果只在一个节点修改 VIP，VIP 修改期间只会影响该节点的连接OS 网络发生改变后，如果有节点重启或集群重启，VIP 不会启动，跳过 " Modifying VIP and its Associated Attributes"


1. 查看当前 VIP 的配置

[grid@zrac1 ~]$ srvctl config nodeapps -aNetwork exists: 1/192.168.56.0/255.255.255.0/bond0, type staticVIP exists: /zrac1-vip/192.168.56.35/192.168.56.0/255.255.255.0/bond0, hostiVIP exists: /zrac2-vip/192.168.56.45/192.168.56.0/255.255.255.0/bond0, hosti

VIP 漂移到其他的可用节点上

[grid@zrac1 ~]$ crsctl stat res -t

ora.zrac1.vip1  ONLINE INTERMEDIATE zrac2          FAILED OVER

2. 停止实例与 VIP 资源

[grid@zrac1 ~]$ srvctl stop instance -d rac -n zrac1    // 可选项[grid@zrac1 ~]$ srvctl stop vip -n zrac1 -f

3. 修改 VIP 以及属性

注意：（先修改 /etc/hosts 文件中的 VIP）

[grid@zrac1 ~]$ srvctl modify nodeapps -n zrac1 -A zrac1-vip/255.255.255.0/b

  • 验证改变

[root@zrac1 grid]# srvctl config nodeapps -aNetwork exists: 1/192.168.60.0/255.255.255.0/bond0, type staticVIP exists: /zrac1-vip/192.168.60.35/192.168.60.0/255.255.255.0/bond0, hostiVIP exists: /zrac2-vip/192.168.56.45/192.168.60.0/255.255.255.0/bond0, hosti

  • 启动资源

[root@zrac1 grid]# srvctl start vip -n zrac1  [root@zrac1 grid]# srvctl start listener -n zrac1  [root@zrac1 grid]# srvctl start instance -d rac -n zrac1  // 可选项

  • 查看 VIP 资源状态

[root@zrac1 grid]# crsctl stat res -t

ora.zrac1.vip 1              ONLINE  ONLINE zrac1

  • 查看网络信息

[root@zrac1 grid]# ifconfigbond0  Link encap:Ethernet HWaddr 08:00:27:44:AF:3Cinet addr:192.168.60.31 Bcast:192.168.60.255 Mask:255.255.255.0inet6 addr: fe80::a00:27ff:fe44:af3c/64 Scope:LinkUP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1RX packets:6876 errors:0 dropped:0 overruns:0 frame:0TX packets:2884 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:0RX bytes:663094 (647.5 KiB) TX bytes:359866 (351.4 KiB)
 bond0:1  Link encap:Ethernet HWaddr 08:00:27:44:AF:3Cinet addr:192.168.60.35 Bcast:192.168.60.255 Mask:255.255.255.0UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1

  • 查看监听信息

grid@zrac1 admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-MAY-2017 11:22:50

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))STATUS of the LISTENER-------------------------Alias                      LISTENERVersion                     TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date                   14-MAY-2017 11:22:46Uptime                       0 days 0 hr. 0 min. 4 secTrace Level                  offSecurity                     ON: Local OS AuthenticationSNMP                          OFFListener Parameter File      /u01/11.2.0/grid/network/admin/listener.ora Listener Log File            /u01/app/oracle/diag/tnslsnr/zrac1/listener/alert/ Listening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.60.31)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.60.35)(PORT=1521)))Services Summary...Service "rac" has 1 instance(s).Instance "rac1", status READY, has 1 handler(s) for this service...Service "racXDB" has 1 instance(s).Instance "rac1", status READY, has 1 handler(s) for this service...The command completed successfully

注意：如果需要的话，修改 listener.ora 文件、tnsnames.ora 文件、LOCAL_LISTENER/REMOTE_LISTENER 参数来映射 VIP 的改变，如果不停实例的话，需要修改 LOCAL_LISTENER 参数；不修改的话 listener 监听不到服务

SQL> alter system set local_listener="(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.6

  • 在其他节点也进行上述操作


三. 修改 SCAN IP

1. 停止 SCAN listener 并查看状态

[grid@zrac1 admin]$ srvctl stop scan_listener[grid@zrac1 admin]$ srvctl status scan_listenerSCAN Listener LISTENER_SCAN1 is enabledSCAN listener LISTENER_SCAN1 is not running

2. 停止 SCAN VIP 资源并查看状态

[grid@zrac1 admin]$ srvctl stop scan

[grid@zrac1 admin]$ srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is not running

3. 修改所有节点的 /etc/hosts 文件

# SCAN VIP  192.168.60.90  scan

4. 更新 SCAN VIP 资源

[root@zrac1 admin]# srvctl modify scan -n scan 
[root@zrac1 admin]# srvctl config scanSCAN name: scan, Network: 1/192.168.60.0/255.255.255.0/bond0SCAN VIP name: scan1, IP: /scan/192.168.60.90

5. 启动 SCAN VIP 和 SCAN 监听资源

[root@zrac1 admin]# srvctl start scan[root@zrac1 admin]# srvctl start scan_listener

6. 查看 SCAN 监听状态（发现没有服务）

[root@zrac1 admin]# lsnrctl status LISTENER_scan1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-MAY-2017 11:43:58

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))STATUS of the LISTENER 12Alias  LISTENER_SCAN1Version  TNSLSNR for Linux: Version 11.2.0.4.0 - Production15 Start Date  14-MAY-2017 11:40:32Uptime  0 days 0 hr. 3 min. 26 secTrace Level  offSecurity  ON: Local OS AuthenticationSNMP  OFFListener Parameter File  /u01/11.2.0/grid/network/admin/listener.oraListener Log File  /u01/11.2.0/grid/log/diag/tnslsnr/zrac1/listener_sListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.60.90)(PORT=1521)))The listener supports no servicesThe command completed successfully

7. 解决方式：重启实例或者修改 remote_listener 参数

[root@zrac1 admin]# srvctl stop instance -d rac -i rac1,rac2[root@zrac1 admin]# srvctl start instance -d rac -i rac1,rac2

8. 修改完成后，/etc/hosts 文件

#Public IP192.168.60.31 zrac1192.168.60.41 zrac2

#Private IP10.10.10.31 zrac1-priv10.10.10.41 zrac2-priv


END


更多精彩干货分享

点击下方名片关注

IT那活儿

GPU云服务器 云服务器 Oracle?RAC?集群 oracle-rac 迁移 oracle10g rac oracle 11g

文章版权归作者所有，未经允许请勿转载,若此文章存在违规行为，您可以联系管理员删除。

转载请注明本文地址：https://www.ucloud.cn/yun/129844.html

相关文章

  • DBASK问答集萃（2）

    摘要：新晋技术专家下面是墨天轮部分新晋的技术专家。大家可以点击往期阅读墨天轮技术专家邀请函了解详情，申请成为我们的技术专家，加入专家团队，与我们一起创建一个开放互助的数据库技术社区。新关联公众号墨天轮是一个开放互助的数据库技术社区。 引言 近期我们在DBASK小程序增加了数据库 MongoDB、Redis、 Elasticsearch、DB2、Weblogic 等新的的专题栏目和一些新的技术...

    liuchengxu 评论0 收藏0

发表评论

登陆后可评论

0条评论

IT那活儿

男|高级讲师
我要私信

TA的文章

阅读更多
最新活动
阅读需要支付1元查看
<