10gRAC VIP無法啟動

客戶報告說AIX5.3 上的10g RAC 節點1的監聽啟動。檢查發現節點1的VIP已經飄逸到節點2了。從日誌中無法獲取更多有用資訊

在ora.tjtj_ps_wxcs1_db01.vip.log中有如下資訊

2014-01-21 13:17:01.037: [  CRSRES][12463] StopResource: setting CLI values
2014-01-21 13:17:01.061: [  CRSRES][12463] Attempting to stop `ora.tjtj_ps_wxcs1_db01.vip` on member `tjtj_ps_wxcs1_db02`
2014-01-21 13:17:01.555: [  CRSRES][12463] Stop of `ora.tjtj_ps_wxcs1_db01.vip` on member `tjtj_ps_wxcs1_db02` succeeded.
2014-01-21 13:17:01.559: [  CRSRES][12463] startRunnable: setting CLI values
2014-01-21 13:17:01.560: [  CRSRES][12463] Attempting to start `ora.tjtj_ps_wxcs1_db01.vip` on member `tjtj_ps_wxcs1_db01`
2014-01-21 13:17:08.585: [  CRSAPP][12463] StartResource error for ora.tjtj_ps_wxcs1_db01.vip error code = 1
2014-01-21 13:17:09.117: [  CRSRES][12463] Start of `ora.tjtj_ps_wxcs1_db01.vip` on member `tjtj_ps_wxcs1_db01` failed.
2014-01-21 13:17:09.139: [  CRSRES][12463] Attempting to start `ora.tjtj_ps_wxcs1_db01.vip` on member `tjtj_ps_wxcs1_db02`
2014-01-21 13:17:12.889: [  CRSRES][12463] Start of `ora.tjtj_ps_wxcs1_db01.vip` on member `tjtj_ps_wxcs1_db02` succeeded.
2014-01-21 13:17:13.733: [  CRSRES][12733] StopResource: setting CLI values
2014-01-21 13:17:13.747: [  CRSRES][12733] Attempting to stop `ora.tjtj_ps_wxcs1_db01.vip` on member `tjtj_ps_wxcs1_db02`
2014-01-21 13:17:14.232: [  CRSRES][12733] Stop of `ora.tjtj_ps_wxcs1_db01.vip` on member `tjtj_ps_wxcs1_db02` succeeded.
2014-01-21 13:17:14.235: [  CRSRES][12733] startRunnable: setting CLI values
2014-01-21 13:17:14.236: [  CRSRES][12733] Attempting to start `ora.tjtj_ps_wxcs1_db01.vip` on member `tjtj_ps_wxcs1_db01`
2014-01-21 13:17:21.261: [  CRSAPP][12733] StartResource error for ora.tjtj_ps_wxcs1_db01.vip error code = 1
2014-01-21 13:17:21.783: [  CRSRES][12733] Start of `ora.tjtj_ps_wxcs1_db01.vip` on member `tjtj_ps_wxcs1_db01` failed.
2014-01-21 13:17:21.797: [  CRSRES][12733] tjtj_ps_wxcs1_db02 : CRS-1019: Resource ora.tjtj_ps_wxcs1_db01.LISTENER_TJTJ_PS_WXCS1_DB01.lsnr (application) cannot run on tjtj_ps_wxcs1_db02

從日誌中無法判斷問題點，需要做一下配置，獲取更多的日誌資訊

To increase the trace level, issue
crsctl debug log resource :1
To turn off this tracing use:
crsctl debug log res :0

例如：

crsctl debug log resource ora.tjtj_ps_wxcs1_db01.vip:1

這樣，就可以獲取問題的資訊了。

這個故障的原因是因為主機端的預設閘道器丟失了，導致VIP無法再節點1啟動，進而導致了監聽的無法啟動。

 

參考文件：

The listener stops or goes offline randomly due to VIP issue (文件 ID 985170.1)

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/11590946/viewspace-1073579/，如需轉載，請註明出處，否則將追究法律責任。