Oracle rac修改vip地址后,vip服务启动不成功的处理过程
Oracle rac修改vip地址后,vip服务启动不成功的处理过程
1 概述
问题简述:数据库测试更改vip地址后,vip服务启动不成功。
100.192.168.88 p595test1 --改为200.200.200.1
100.192.168.89 p595test1-vip --改为200.200.200.2
192.168.4.100 p595test1-priv --改为192.168.5.100
100.192.168.90 p595test2 --改为200.200.200.3
100.192.168.91 p595test2-vip --改为200.200.200.4
192.168.4.101 p595test2-priv --改为192.168.5.101
操作系统:aix 5309
数据库:oracle 10.2 rac+ asm
2 问题描述
测试更改VIP地址,vip服务启动不了,启动服务时报以下错误:
更改命令:
./srvctl modify nodeapps -n p595test1 -A 200.200.200.2/255.255.255.0/en0
./srvctl modify nodeapps -n p595test2 -A 200.200.200.4/255.255.255.0/en0
#./srvctl start nodeapps -n p595test1
p595test1:ora.p595test1.vip:Invalid parameters, or failed to bring up VIP (host=p595test1)
CRS-0215: Could not start resource 'ora.p595test1.LISTENER_p595test1.lsnr'.
#./srvctl start nodeapps -n p595test1
p595test1:ora.p595test1.vip:Invalid parameters, or failed to bring up VIP (host=p595test1)
CRS-0215: Could not start resource 'ora.p595test1.LISTENER_p595test1.lsnr'.
3 处理过程
3.1. crs_stat -t查看状态 vip服务offline
ora.p595test1.gsd application ONLINE ONLINE p595test1
ora.p595test1.ons application ONLINE ONLINE p595test1
ora.p595test1.vip application ONLINE OFFLINE
3.2. 检查日志
Cd /crs/app/oracle/product/crs_1/log/p595test1/racg
查看ora.p595test1.vip.log日志
2009-12-08 20:40:26.024: [ RACG][1] [774270][1][ora.p595test2.vip]: clsrcexecut: cmd = /crs/app/oracle/product/crs_1/bin/racgeut -e
_USR_ORA_DEBUG=0 54 /crs/app/oracle/product/crs_1/bin/racgvip check p595test2
2009-12-08 20:40:26.024: [ RACG][1] [774270][1][ora.p595test2.vip]: clsrcexecut: rc = 1, time = 1.202s
2009-12-08 20:40:26.024: [ RACG][1] [774270][1][ora.p595test2.vip]: end for resource = ora.p595test2.vip, action = start, status = 1, time = 2.505s
2009-12-08 20:45:18.426: [ RACG][1] [606268][1][ora.p595test2.vip]
Invalid parameters, or failed to bring up VIP (host=p595test1)
3.3. 用srvctl config nodeapps命令查看显示更改vip命令成功
#./srvctl config nodeapps -n p595test1 -a
VIP exists.: /p595test1-vip/200.200.200.2/255.255.255.0/en0
#./srvctl config nodeapps -n p595test2 -a
VIP exists.: /p595test2-vip/200.200.200.4/255.255.255.0/en0
3.4.检查public公网ip所对应的网关还是为1.45.128.254
用smitty tcpip 修改en0网关为200.200.200.254
启动vip服务成功
4 总结
修改VIP地址后,一定要注意更改public网卡所对应的网关和public,vip地址在同一个网段