客户报告说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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11590946/viewspace-1073579/