AIX 5.3下Oracle 10g RAC 啟動故障--vip漂移
成都創(chuàng)新互聯(lián)主營婁底網(wǎng)站建設的網(wǎng)絡公司,主營網(wǎng)站建設方案,app軟件定制開發(fā),婁底h5微信小程序開發(fā)搭建,婁底網(wǎng)站營銷推廣歡迎婁底等地區(qū)企業(yè)咨詢系統(tǒng)環(huán)境：
操作系統(tǒng)： AIX 5300-09
集群軟件： CRS 10.2.0.1
數(shù)據(jù)庫： Oracle 10.2.0.1
系統(tǒng)架構(gòu)圖
故障現(xiàn)象：
系統(tǒng)重啟后，在節(jié)點上CRS 啟動失敗或CRS服務啟動成功，CRS Resource無法ONLINE。
[root@aix213 racg] cat /etc/hosts
127.0.0.1 loopback localhost # loopback (lo0) name/address 192.168.8.214 aix214 192.168.8.106 aix106 192.168.8.213 aix213 192.168.8.115 aix213-vip 10.10.10.213 aix213-priv 192.168.8.113 aix214-vip 10.10.10.214 aix214-priv每個node都綁定了其他節(jié)點的vip ip ，vip ip address 綁定到了所有的節(jié)點上！
[oracle@aix214 ~]$ifconfig -a
en0: flags=5e080863,c0[oracle@aix213 ~]$ifconfig -a
en0: flags=5e080863,c0[root@aix214 /]$crsctl check crs
CSS appears healthy CRS appears healthy EVM appears healthy[root@aix214 /]$crs_stat -t
Name Type Target State Host ------------------------------------------------------------ ora....13.lsnr application ONLINE OFFLINE ora.aix213.gsd application ONLINE OFFLINE ora.aix213.ons application ONLINE OFFLINE ora.aix213.vip application ONLINE OFFLINE ora....14.lsnr application ONLINE OFFLINE ora.aix214.gsd application ONLINE OFFLINE ora.aix214.ons application ONLINE OFFLINE ora.aix214.vip application ONLINE OFFLINE ora.prod.db application ONLINE OFFLINE ora....d1.inst application ONLINE OFFLINE ora....d2.inst application ONLINE OFFLINE查看日志：
[root@aix213 racg]cd /u01/crs_1/log/aix213/racg
[root@aix213 racg]$more ora.aix213.vip.log Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle. All rig hts reserved. 2014-05-09 17:07:05.624: [ RACG][1] [385112][1][ora.aix213.vip]: Invalid parameters, or failed to bring up VIP (host=aix213) 2014-05-09 17:07:05.624: [ RACG][1] [385112][1][ora.aix213.vip]: clsrcexecut: env ORACLE _CONFIG_HOME=/u01/crs_1 2014-05-09 17:07:05.625: [ RACG][1] [385112][1][ora.aix213.vip]: clsrcexecut: cmd = /u01 /crs_1/bin/racgeut -e _USR_ORA_DEBUG=0 54 /u01/crs_1/bin/racgvip start aix213 2014-05-09 17:07:05.625: [ RACG][1] [385112][1][ora.aix213.vip]: clsrcexecut: rc = 1, ti me = 0.345s 2014-05-09 17:07:06.832: [ RACG][1] [385112][1][ora.aix213.vip]: Invalid parameters, or failed to bring up VIP (host=aix213)......
初步判斷是在節(jié)點上VIP配置有問題！
解決方法1：
1、關(guān)閉所有node上的nodeapps
[oracle@aix213 ~]$srvctl stop nodeapps -n aix213
[oracle@aix213 ~]$srvctl stop nodeapps -n aix214
[oracle@aix213 ~]$srvctl modify nodeapps -A 192.168.8.115/255.255.255.0/en0 -n aix213 -o $ORACLE_HOME
[oracle@aix213 ~]$srvctl modify nodeapps -A 192.168.8.113/255.255.255.0/en0 -n aix214 -o $ORACLE_HOME
2、停止所有節(jié)點的crs
[oracle@aix213 ~]$crsctl stop crs
[oracle@aix214 ~]$crsctl stop crs
3、重新啟動所有節(jié)點的crs
[oracle@aix213 ~]$crsctl start crs
[oracle@aix214 ~]$crsctl start crs
解決方法2：
1、更新CRS中VIP信息
[root@aix213 racg] cat /etc/hosts
127.0.0.1 loopback localhost # loopback (lo0) name/address 192.168.8.214 aix214 192.168.8.106 aix106 192.168.8.213 aix213 192.168.8.115 aix213-vip 10.10.10.213 aix213-priv 192.168.8.113 aix214-vip 10.10.10.214 aix214-priv2、修改VIP
[root@aix214 /]$srvctl modify nodeapps -n aix213 -o /u01/app/oracle/product/10.2.0/db_1/ -A 192.168.8.115/255.255.255.0/en0 [root@aix214 /]$srvctl modify nodeapps -n aix214 -o /u01/app/oracle/product/10.2.0/db_1/ -A 192.168.8.113/255.255.255.0/en03、以root身份執(zhí)行vipca
4、重新啟動CRS服務
[root@aix214 /]$crsctl check crs CSS appears healthy CRS appears healthy EVM appears healthy[root@aix214 /]$crs_stat -t
Name Type Target State Host ------------------------------------------------------------ ora....13.lsnr application OFFLINE OFFLINE ora.aix213.gsd application ONLINE ONLINE aix213 ora.aix213.ons application ONLINE ONLINE aix213 ora.aix213.vip application ONLINE ONLINE aix213 ora....14.lsnr application ONLINE OFFLINE ora.aix214.gsd application ONLINE ONLINE aix214 ora.aix214.ons application ONLINE ONLINE aix214 ora.aix214.vip application ONLINE ONLINE aix214 ora.prod.db application ONLINE OFFLINE ora....d1.inst application OFFLINE OFFLINE ora....d2.inst application ONLINE OFFLINE手工啟動Listener service：
[root@aix214 /]$crs_stat |grep lsn NAME=ora.aix213.LISTENER_AIX213.lsnr NAME=ora.aix214.LISTENER_AIX214.lsnr [root@aix214 /]$crs_start -f ora.aix214.LISTENER_AIX214.lsnr Attempting to start `ora.aix214.LISTENER_AIX214.lsnr` on member `aix214` Start of `ora.aix214.LISTENER_AIX214.lsnr` on member `aix214` succeeded. [root@aix214 /]$crs_start -f ora.aix213.LISTENER_AIX213.lsnr Attempting to start `ora.aix213.LISTENER_AIX213.lsnr` on member `aix213` Start of `ora.aix213.LISTENER_AIX213.lsnr` on member `aix213` succeeded.至此CRS啟動成功：
[oracle@aix213 ~]$crs_stat -t
Name Type Target State Host ------------------------------------------------------------ ora....13.lsnr application ONLINE ONLINE aix213 ora.aix213.gsd application ONLINE ONLINE aix213 ora.aix213.ons application ONLINE ONLINE aix213 ora.aix213.vip application ONLINE ONLINE aix213 ora....14.lsnr application ONLINE ONLINE aix214 ora.aix214.gsd application ONLINE ONLINE aix214 ora.aix214.ons application ONLINE ONLINE aix214 ora.aix214.vip application ONLINE ONLINE aix214 ora.prod.db application ONLINE ONLINE aix213 ora....d1.inst application ONLINE ONLINE aix213 ora....d2.inst application ONLINE ONLINE aix214@至此，問題基本解決
另外有需要云服務器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務器、裸金屬服務器、高防服務器、香港服務器、美國服務器、虛擬主機、免備案服務器”等云主機租用服務以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務可用性高、性價比高”等特點與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應用場景需求。
重慶分公司
重慶分公司
