AIX 5.3下Oracle 10g RAC 啟動(dòng)故障--vip漂移
創(chuàng)新互聯(lián)是專業(yè)的隆化網(wǎng)站建設(shè)公司,隆化接單;提供網(wǎng)站建設(shè)、網(wǎng)站制作,網(wǎng)頁(yè)設(shè)計(jì),網(wǎng)站設(shè)計(jì),建網(wǎng)站,PHP網(wǎng)站建設(shè)等專業(yè)做網(wǎng)站服務(wù);采用PHP框架,可快速的進(jìn)行隆化網(wǎng)站開(kāi)發(fā)網(wǎng)頁(yè)制作和功能擴(kuò)展;專業(yè)做搜索引擎喜愛(ài)的網(wǎng)站,專業(yè)的做網(wǎng)站團(tuán)隊(duì),希望更多企業(yè)前來(lái)合作!
系統(tǒng)環(huán)境:
操作系統(tǒng): AIX 5300-09
集群軟件: CRS 10.2.0.1
數(shù)據(jù)庫(kù): Oracle 10.2.0.1
系統(tǒng)架構(gòu)圖
故障現(xiàn)象:
系統(tǒng)重啟后,在節(jié)點(diǎn)上CRS 啟動(dòng)失敗或CRS服務(wù)啟動(dòng)成功,CRS Resource無(wú)法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
每個(gè)node都綁定了其他節(jié)點(diǎn)的vip ip ,vip ip address 綁定到了所有的節(jié)點(diǎn)上!
[oracle@aix214 ~]$ifconfig -a
en0: flags=5e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN> inet 192.168.8.214 netmask 0xffffff00 broadcast 192.168.8.255 inet 192.168.8.113 netmask 0xffffff00 broadcast 192.168.8.255 inet 192.168.8.115 netmask 0xffffff00 broadcast 192.168.8.255 tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
[oracle@aix213 ~]$ifconfig -a
en0: flags=5e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN> inet 192.168.8.213 netmask 0xffffff00 broadcast 192.168.8.255 inet 192.168.8.113 netmask 0xffffff00 broadcast 192.168.8.255 inet 192.168.8.115 netmask 0xffffff00 broadcast 192.168.8.255 tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
[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é)點(diǎn)上VIP配置有問(wèn)題!
解決方法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é)點(diǎn)的crs
[oracle@aix213 ~]$crsctl stop crs
[oracle@aix214 ~]$crsctl stop crs
3、重新啟動(dòng)所有節(jié)點(diǎn)的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-priv
2、修改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/en0
3、以root身份執(zhí)行vipca
4、重新啟動(dòng)CRS服務(wù)
[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
手工啟動(dòng)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啟動(dòng)成功:
[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
@至此,問(wèn)題基本解決
當(dāng)前文章:AIX5.3下Oracle10gRAC啟動(dòng)故障--vip漂移
標(biāo)題URL:http://bm7419.com/article38/jdjssp.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供App開(kāi)發(fā)、電子商務(wù)、微信公眾號(hào)、網(wǎng)站內(nèi)鏈、網(wǎng)站設(shè)計(jì)、網(wǎng)站導(dǎo)航
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)