rac 中節點的vip在該節點啟動不了,在其他節點正常啟動。,racvip
本實驗是在虛擬機器中!
與實驗相同的問題:http://blog.csdn.net/wanghui5767260/article/details/38850335
問題描述:
節點1、節點2和節點3同時我做了斷電處理,結果節點1 和節點2 都正常啟動了,而節點3的vip在自己的節點上啟動報錯而在其他節點上啟動正常。
註:節點3隻裝入了叢集。
查看狀態:
[root@rac3 bin]# ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE rac1
ora....B2.inst application ONLINE ONLINE rac2
ora.RACDB.db application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
ora.rac3.gsd application ONLINE ONLINE rac3
ora.rac3.ons application ONLINE ONLINE rac3
ora.rac3.vip application ONLINE ONLINE rac1
在節點3的crs日誌中報錯:
2014-08-27 22:16:55.013: [ CRSRES][2740304784]0Attempting to stop`ora.rac3.vip` on member `rac1`
2014-08-27 22:16:55.204: [ CRSRES][2740304784]0Stop of `ora.rac3.vip` onmember `rac1` succeeded.
2014-08-27 22:16:55.552: [ CRSRES][2740304784]0ora.rac3.gsd target setto OFFLINE before stop action
2014-08-27 22:16:55.552: [ CRSRES][2740304784]0StopResource: setting CLIvalues
2014-08-27 22:16:55.627: [ CRSRES][2740304784]0Attempting to stop`ora.rac3.gsd` on member `rac3`
2014-08-27 22:16:56.658: [ CRSRES][2740304784]0Stop of `ora.rac3.gsd` onmember `rac3` succeeded.
2014-08-27 22:17:06.343: [ CRSRES][2740304784]0startRunnable: settingCLI values
2014-08-27 22:17:06.374: [ CRSRES][2740304784]0Attempting to start`ora.rac3.gsd` on member `rac3`
2014-08-27 22:17:07.455: [ CRSRES][2740304784]0Start of `ora.rac3.gsd`on member `rac3` succeeded.
2014-08-27 22:17:07.878: [ CRSRES][2740304784]0startRunnable: settingCLI values
2014-08-27 22:17:07.897: [ CRSRES][2740304784]0Attempting to start`ora.rac3.vip` on member `rac3`
2014-08-27 22:17:14.916: [ CRSAPP][2740304784]0StartResource error forora.rac3.vip error code = 1
2014-08-27 22:17:18.262: [ CRSRES][2740304784]0Start of `ora.rac3.vip` on member `rac3`failed.
做了一些檢查都正常
[root@rac3 bin]# ./oifcfg getif
eth0 192.168.90.0 global public
eth1 192.168.91.0 global cluster_interconnect
[root@rac3 bin]#
[root@rac3 bin]#
[root@rac3 bin]# ./crsctl start crs
Attempting to start CRS stack
The CRS stack will be started shortly
查看日誌還是報錯
2014-08-27 22:27:37.202: [ CRSRTI][2253600]0CSS is not ready. Receivedstatus 3 from CSS. Waiting for good status ..
2014-08-27 22:27:38.654: [COMMCRS][114084752]clsc_connect: (0x94cfed0) no listener at(ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_rac3_crs))
2014-08-27 22:27:38.654: [CSSCLNT][2253600]clsssInitNative: connect failed, rc 9
2014-08-27 22:27:38.654: [ CRSRTI][2253600]0CSS is not ready. Receivedstatus 3 from CSS. Waiting for good status ..
2014-08-27 22:27:40.096: [ COMMCRS][114084752]clsc_connect:(0x95238e0) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_rac3_crs))
2014-08-27 22:27:40.096: [CSSCLNT][2253600]clsssInitNative: connect failed, rc 9
2014-08-27 22:27:40.096: [ CRSRTI][2253600]0CSS is not ready. Receivedstatus 3 from CSS. Waiting for good status ..
2014-08-27 22:27:41.575: [COMMCRS][114084752]clsc_connect: (0x95238e0) no listener at(ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_rac3_crs))
2014-08-27 22:27:41.575: [CSSCLNT][2253600]clsssInitNative: connect failed, rc 9
2014-08-27 22:27:41.575: [ CRSRTI][2253600]0CSS is not ready. Receivedstatus 3 from CSS. Waiting for good status ..
關掉虛擬機器,重新換了兩塊網卡,
[root@rac3 bin]# ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE rac1
ora....B2.inst application ONLINE ONLINE rac2
ora.RACDB.db application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
ora.rac3.gsd application ONLINE ONLINE rac3
ora.rac3.ons application ONLINE ONLINE rac3
ora.rac3.vip application ONLINE ONLINE rac3
恢複正常,可能是由於虛擬機器網卡的問題吧!!!
Oracle rac 單節點vip不可以啟動的問題
一種可能是你的VIP漂在了第二個節點上。。。這樣你使用VIPCA或手工修改相應的IP地址即可。
另外一種可能就是你的OCR出現問題,請用srvctl config database -d 命令查看資料庫狀態,看看相應的狀態。。檢查一下共用儲存是否掛載成功!
我想問下對於Oracle RAC crs-vip漂移的問題
你這個有點奇怪,一般情況都是2個vip在一個節點上,你這裡的情況是2個vip的位置互換了。
雖然根據你提供的資訊還不能判斷為什麼會這樣,但是你可以試試crs_stop和crs_start命令,關閉vip再在正確的節點上重啟vip資源。然後應該就可以啟動監聽了。