ITPub博客

首页 > 数据库 > Oracle > 10gRAC VIP无法启动

10gRAC VIP无法启动

原创 Oracle 作者:super_sky 时间:2014-01-21 16:34:51 0 删除 编辑

客户报告说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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: OCM实验-分区表
请登录后发表评论 登录
全部评论

注册时间:2011-01-11

  • 博文量
    77
  • 访问量
    757575