修改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.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
先查看当前的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
记得先stop掉节点上的nodeapps
- 提供Oracle管理/故障处理/优化/安装/RAC/备份恢复技术服务,提供专业的Oracle培训和咨询服务。
- 邮件: inthirties@gmail.com
- MSN: inthirties@hotmail.com
- QQ: inthirties@qq.com
- 专业论坛 http://www.inthirties.com
- 技术博客 http://blog.csdn.net/inthirties
- 个人站点 http://blog.inthirties.com