两节点时间不同步导致CRS-0184


节点二:
[oracle@rac2 ~]$ crs_stat -t
CRS-0184: Cannot communicate with the CRS daemon

节点一:
[root@rac1 ~]# crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    rac1
ora.FRA.dg     ora....up.type ONLINE    ONLINE    rac1
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac1
ora....TING.dg ora....up.type ONLINE    ONLINE    rac1
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac1
ora.dave.db    ora....se.type ONLINE    ONLINE    rac1
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE
ora....network ora....rk.type ONLINE    ONLINE    rac1
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac1
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1
ora....SM1.asm application    ONLINE    ONLINE    rac1
ora....C1.lsnr application    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    OFFLINE   OFFLINE
ora.rac1.ons   application    ONLINE    ONLINE    rac1
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac1
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac1

查看节点二alert日志:

 tail -150f alertrac2.log | less
2013-08-17 09:26:08.534
[ctssd(2257)]CRS-2405:The Cluster Time Synchronization Service on host rac2 is shutdown by user
2013-08-17 09:26:17.886
[ctssd(2265)]CRS-2401:The Cluster Time Synchronization Service started on host rac2.
2013-08-17 09:26:17.887
[ctssd(2265)]CRS-2407:The new Cluster Time Synchronization Service reference node is host rac1.
2013-08-17 09:26:22.222
[ctssd(2265)]CRS-2404:The Cluster Time Synchronization Service detects that the local time is significantly different from the mean cluster time. Details in /u01/app/grid/11.2.0/log/rac2/ctssd/octssd.log.
2013-08-17 09:26:22.493
[ctssd(2265)]CRS-2402:The Cluster Time Synchronization Service aborted on host rac2. Details at  in /u01/app/grid/11.2.0/log/rac2/ctssd/octssd.log.
2013-08-17 09:26:34.347
[ctssd(2284)]CRS-2401:The Cluster Time Synchronization Service started on host rac2.
2013-08-17 09:26:34.347
[ctssd(2284)]CRS-2407:The new Cluster Time Synchronization Service reference node is host rac1.
2013-08-17 09:26:52.911

节点二octssd.log日志:
[root@rac2 cssd]# tail -f /u01/app/grid/11.2.0/log/rac2/ctssd/octssd.log
2013-08-17 10:10:23.046: [    CTSS][1231296256]ctssslave_msg_handler4_1: Waiting for slave_sync_with_master to finish sync process. sync_state[3].
2013-08-17 10:10:23.047: [    CTSS][1227093760]ctssslave_swm2_3: Received time sync message from master.
2013-08-17 10:10:23.047: [    CTSS][1227093760]ctssslave_swm: The magnitude [37935421] of the offset [37935421 usec] is larger than [10000000 usec] which is the CTSS limit that can be synced up in a short period.
2013-08-17 10:10:23.047: [    CTSS][1227093760]ctssslave_swm: The magnitude of the systime diff is larger than max adjtime limit. Offset [37935421] usec will be changed to max adjtime limit [+/- 131071].
2013-08-17 10:10:23.047: [    CTSS][1227093760]ctssslave_swm15: The CTSS master is behind this node. The local time offset [-131071 usec] is being adjusted. Sync method [2]
2013-08-17 10:10:23.047: [    CTSS][1227093760]ctssslave_swm17: LT [1376705423sec 46690usec], MT [1376705385sec 140716013630117usec], Delta [14739usec]
2013-08-17 10:10:23.047: [    CTSS][1227093760]ctssslave_swm19: The offset is [131071 usec] and sync interval set to [4]
2013-08-17 10:10:23.047: [    CTSS][1227093760]ctssslave_swm: Received from master (mode [0xcc] nodenum [1] hostname [rac1] )
2013-08-17 10:10:23.047: [    CTSS][1231296256]ctssslave_msg_handler4_3: slave_sync_with_master finished sync process. Exiting clsctssslave_msg_handler
2013-08-17 10:10:23.047: [    CTSS][1227093760]ctsselect_msm: Sync interval returned in [4]
2013-08-17 10:10:24.056: [    CTSS][1227093760]ctsselect_msm: CTSS mode is [0xc4]
2013-08-17 10:10:24.057: [    CTSS][1227093760]ctssslave_swm1_2: Ready to initiate new time sync process.
2013-08-17 10:10:24.059: [    CTSS][1227093760]ctssslave_swm2_1: Waiting for time sync message from master. sync_state[2].
2013-08-17 10:10:24.070: [    CTSS][1231296256]ctsscomm_recv_cb2: Receive incoming message event. Msgtype [2].
2013-08-17 10:10:24.070: [    CTSS][1231296256]ctssslave_msg_handler4_1: Waiting for slave_sync_with_master to finish sync process. sync_state[3].
2013-08-17 10:10:24.070: [    CTSS][1227093760]ctssslave_swm2_3: Received time sync message from master.

从日志看两个节点时间不同步,时间差超过CTSS的限制。

2013-08-17 10:10:23.047: [    CTSS][1227093760]ctssslave_swm: The magnitude [37935421] of the offset [37935421 usec] is larger than [10000000 usec] which is the CTSS limit that can be synced up in a short period.

SQL> select 10000000/1000000 from dual;

10000000/1000000
----------------
              10

SQL> select 37935421/1000000 from dual;

37935421/1000000
----------------
       37.935421

 

同步两节点时间后:

[root@rac2 ~]# crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    rac1
ora.FRA.dg     ora....up.type ONLINE    ONLINE    rac1
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac1
ora....TING.dg ora....up.type ONLINE    ONLINE    rac1
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac1
ora.dave.db    ora....se.type ONLINE    ONLINE    rac1
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE
ora....network ora....rk.type ONLINE    ONLINE    rac1
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac1
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1
ora....SM1.asm application    ONLINE    ONLINE    rac1
ora....C1.lsnr application    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    OFFLINE   OFFLINE
ora.rac1.ons   application    ONLINE    ONLINE    rac1
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1
ora....SM2.asm application    ONLINE    ONLINE    rac2
ora....C2.lsnr application    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    OFFLINE   OFFLINE
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac1

 

 

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值