How to Change IP and VIP in Oracle Clusterware 实操篇
修改RAC环境下IP 和 VIP
操作平台:AIX
主机配置:IBM p5
数据库版本:oracle RAC 10.2.0.4
1. 关机顺序
a) 停止数据库
srvctl stop instance -d orcl -i orcl1(tail alert)
srvctl stop instance -d orcl -i orcl2(tail alert)
b) 停止ASM
srvctl stop asm -n devdb1 (tail alert_+ASM1.LOG)
srvctl stop asm -n devdb2 (tail alert_+ASM1.LOG)
c) 停止nodeapps
srvctl stop nodeapps -n devdb1
srvctl stop nodeapps -n devdb2
d) 停止crs(root用户)
devdb1:/u01/app/oracle/product/10.2.0/crs_1/bin/crsctl stop crs
devdb2:/u01/app/oracle/product/10.2.0/crs_1/bin/crsctl stop crs
或者:/etc/init.d/init.crs stop
e) 停止dbconsole
devdb1:emctl stop dbconsole
devdb2:emctl stop dbconsole
f) 察看进程(2node)
ps -ef|grep ora
ps -ef|grep crs
ps -ef|grep evmd
ps -ef|grep cssd
g) note: down机前最好禁用开机自动启动crs服务
devdb1#[/] /etc/init.crs disable
devdb2#[/] /etc/init.crs disable
2. 修改 /etc/hosts文件, tnsnames.ora, listener.ora文件
3. 修改操作系统的ip设置
使用smitty tcpip修改操作系统ip
4. 修改IP信息
a) 查询原有信息
devdb1$[/home/oracle] oifcfg getif
en0 192.168.1.0 global public
en1 100.1.1.0 global cluster_interconnect
b) 删除原先的信息
devdb1$[/home/oracle] oifcfg delif -global en0
c) 添加新的信息
devdb1$[/home/oracle] oifcfg setif -global en0/192.168.195.0:public
d) 检查是否添加成功
devdb1$[/home/oracle] oifcfg getif
5. 修改VIP信息nodeapps
note:修改必须在 Oracle Clusterware stack启动状态下进行,因此上面一步要用srvctl stop nodeapps来停止资源而不要使用crsctl stop crs来停掉整个Clusterware
a) 查询vip信息
devdb1$[/home/oracle] srvctl config nodeapps -n devdb1 -a
VIP exists.: /devdb1_vip/192.168.1.114/255.255.255.0/en0
b) 停instance,asm,nodeapps
查看crs运行情况
crs_stat -t
停止数据库
srvctl stop instance -d orcl -i orcl1(tail alert)
srvctl stop instance -d orcl -i orcl2(tail alert)
停止ASM
srvctl stop nodeapps -n devdb1
srvctl stop nodeapps -n devdb2
停止nodeapps
srvctl stop nodeapps -n devdb1
srvctl stop nodeapps -n devdb2
c) 修改vip信息 root用户
srvctl modify nodeapps -n devdb1 -A 192.168.195.111/255.255.255.0/en0
srvctl modify nodeapps -n devdb2 -A 192.168.195.112/255.255.255.0/en0
6. 启动crs服务,级联instance, asm, nodeapps
devdb1:/u01/app/oracle/product/10.2.0/crs_1/bin/crsctl start crs
devdb2:/u01/app/oracle/product/10.2.0/crs_1/bin/crsctl start crs
7. 检查RAC状态
devdb1$[/home/oracle] crs_stat -t
8. 启用开机自动启动crs服务
devdb1#[/] /etc/init.crs enable
devdb2#[/] /etc/init.crs enable
9.如果是RAC环境的话,需要手工修改LOCAL_LISTENER参数。
alter system set local_listener=‘(ADDRESS=(PROTOCOL=TCP)(HOST=NEW_VIP1_ADDRESS)(PORT=1521))'scope=both sid='devdb1';
alter system set local_listener=‘(ADDRESS=(PROTOCOL=TCP)(HOST=NEW_VIP2_ADDRESS)(PORT=1521))'scope=both sid='devdb2';
参考文献:1. http://space.itpub.net/?uid-9252210-action-viewspace-itemid-630879
2. http://space.itpub.net/9252210/viewspace-573149
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9252210/viewspace-630883/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9252210/viewspace-630883/