修改RAC VIP IP-CSDN博客

本文链接：https://blog.csdn.net/inthirties/article/details/5361416

修改RAC VIP IP

http://inthirties.com:90/thread-984-2-1.html

1.修改RAC2 的VIP ip 由192.168.0.32改为192.168.0.34
1.1 sqlplus sys/manager@rac2 as sysdba
SQL>alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.34) (PORT = 1521))' sid='rac2';
1.2 [root@racdb02 oracle]#srvctl stop nodeapps -n racdb02
1.3 [root@racdb02 oracle]#srvctl modify nodeapps -n racdb02 -A 192.168.0.34/255.255.255.0/eth0
1.4 分别修改所有主机的hosts，将原来IP修改为新的IP
1.5 [root@racdb02 oracle]#srvctl start nodeapps -n racdb02
1.6 最好能重新启动一下RAC2的相关服务

2. 修改RAC1 的VIP IP 由192.168.0.31改为192.168.0.33
2.1 sqlplus sys/manager@rac1 as sysdba
SQL>alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.33) (PORT = 1521))' sid='rac1';
2.2 [root@racdb01 oracle]#srvctl stop nodeapps -n racdb01
2.3 [root@racdb01 oracle]#srvctl modify nodeapps -n racdb02 -A 192.168.0.33/255.255.255.0/eth0
2.4 分别修改所有主机的hosts，将原来IP修改为新的IP
2.5 [root@racdb01 oracle]#srvctl start nodeapps -n racdb01
2.6 最好能重新启动一下RAC1的相关服务

官方做法

1.修改public ip
先查看当前的public ip
oifcfg getif
eth0 10.2.156.0 global public
删除旧ip
oifcfg delif -global eth0
添加新ip
oifcfg setif –global eth0/10.2.166.0:public

2.修改vip
查看当前vip信息
srvctl config nodeapps -n node1 -a
srvctl config nodeapps -n node2 -a
停库
srvctl stop database -d dbname
停资源
srvctl stop nodeapps -n node1
srvctl stop nodeapps -n node2
修改vip
srvctl modify nodeapps -n node1 -A newvip/255.255.255.0/eth0
srvctl modify nodeapps -n node2 -A newvip/255.255.255.0/eth0

潮人做法

改vip可以直接把nodeapps和监听资源都从ocr里删除了然后重新vipca

记得先stop掉节点上的nodeapps