oracle 11g rac更换public ip、vip

IT那活儿 2021-07-29

3379

一. 修改公网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 getif
bond1 10.10.10.0 global cluster_interconnect
bond0 192.168.60.0 global public

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

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


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

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

[root@zrac1 ~]# vim etc/sysconfig/network-scripts/ifcfg-bond0
DEVICE=bond0
TYPE=Ethernet
ONBOOT=yes
BOOTPROTO=none
IPADDR=192.168.60.31
NETMASK=255.255.255.0
GATEWAY=192.168.60.1
USERCTL=no


重启网卡 ifdown bond0;ifup bond0

#Public IP
192.168.60.31 zrac1
192.168.56.41 zrac2
#Private IP
10.10.10.31 zrac1-priv
10.10.10.41 zrac2-priv
# VIP
192.168.56.35 zrac1-vip
192.168.56.45 zrac2-vip
# SCAN
192.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 -a
Network exists: 1/192.168.56.0/255.255.255.0/bond0, type static
VIP exists: /zrac1-vip/192.168.56.35/192.168.56.0/255.255.255.0/bond0, hosti
VIP 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.vip
1  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 -a
Network exists: 1/192.168.60.0/255.255.255.0/bond0, type static
VIP exists: /zrac1-vip/192.168.60.35/192.168.60.0/255.255.255.0/bond0, hosti
VIP 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]# ifconfig
bond0  Link encap:Ethernet HWaddr 08:00:27:44:AF:3C
inet addr:192.168.60.31 Bcast:192.168.60.255 Mask:255.255.255.0
inet6 addr: fe80::a00:27ff:fe44:af3c/64 Scope:Link
UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1
RX packets:6876 errors:0 dropped:0 overruns:0 frame:0
TX packets:2884 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:663094 (647.5 KiB) TX bytes:359866 (351.4 KiB)

 
bond0:1  Link encap:Ethernet HWaddr 08:00:27:44:AF:3C
inet addr:192.168.60.35 Bcast:192.168.60.255 Mask:255.255.255.0
UP 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                      LISTENER
Version                     TNSLSNR for Linux: Version 11.2.0.4.0 - Production 
Start Date                   14-MAY-2017 11:22:46
Uptime                       0 days 0 hr. 0 min. 4 sec
Trace Level                  off
Security                     ON: Local OS Authentication
SNMP                          OFF
Listener 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_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running

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

[grid@zrac1 admin]$ srvctl stop scan


[grid@zrac1 admin]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN 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 scan
SCAN name: scan, Network: 1/192.168.60.0/255.255.255.0/bond0
SCAN 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 12
Alias  LISTENER_SCAN1
Version  TNSLSNR for Linux: Version 11.2.0.4.0 - Production
15 Start Date  14-MAY-2017 11:40:32
Uptime  0 days 0 hr. 3 min. 26 sec
Trace Level  off
Security  ON: Local OS Authentication
SNMP  OFF
Listener Parameter File  /u01/11.2.0/grid/network/admin/listener.ora
Listener Log File  /u01/11.2.0/grid/log/diag/tnslsnr/zrac1/listener_s
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.60.90)(PORT=1521)))
The listener supports no services
The 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 IP
192.168.60.31 zrac1
192.168.60.41 zrac2




#Private IP
10.10.10.31 zrac1-priv
10.10.10.41 zrac2-priv

END

更多精彩干货分享

点击下方名片关注

IT那活儿

oracle

文章转载自IT那活儿，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。