在oracle11G R2版本中,oracle自己增加了集群中的时间同步服务,如果操作系统没有配置NTP,就会启用oracle 自带的 Cluster Time Synchronization Service ,以下为官方文档说明:

 Cluster Time Synchronization Service

Cluster node times should be synchronized. With this release, Oracle Clusterware
provides Cluster Time Synchronization Service (CTSS), which ensures that there is a
synchronization service in the cluster. If Network Time Protocol (NTP) is not  during cluster configuration, then CTSS is configured to ensure time synchronization

 

 配置过程:禁用NTP服务

stopsrc -s xntpd

 

新环境安装后，发现一台节点出现很多如下报错

2013-08-02 11:52:47.590

[ctssd(9030)]CRS-2412:The Cluster Time Synchronization Service detects that the local time is significantly different from the mean cluster time. Details in /oracle/app/11.2.0/grid/product/db_1/log/hp7/ctssd/octssd.log.

2013-08-02 12:22:47.970

[ctssd(9030)]CRS-2412:The Cluster Time Synchronization Service detects that the local time is significantly different from the mean cluster time. Details in /oracle/app/11.2.0/grid/product/db_1/log/hp7/ctssd/octssd.log.

2013-08-02 12:52:48.280

[ctssd(9030)]CRS-2412:The Cluster Time Synchronization Service detects that the local time is significantly different from the mean cluster time. Details in /oracle/app/11.2.0/grid/product/db_1/log/hp7/ctssd/octssd.log.

 

查看双节点时间发现，date不同步

hp7:[/]#ssh hp6 date;date

Fri Aug  2 14:55:23 EAT 2013

Fri Aug  2 14:55:02 EAT 2013

 

 

用cluvfy comp clocksync -verbose 检查也没同步
[grid@hp7:/grid/app/11.2.0/grid/bin]$cluvfy comp clocksync -verbose

Verifying Clock Synchronization across the cluster nodes

 

Checking if Clusterware is installed on all nodes...

Check of Clusterware install passed

 

Checking if CTSS Resource is running on all nodes...

Check: CTSS Resource running on all nodes

  Node Name                             Status                 

  ------------------------------------  ------------------------

  hp7                                   passed                 

Result: CTSS resource check passed

 

 

Querying CTSS for time offset on all nodes...

Result: Query of CTSS for time offset passed

 

Check CTSS state started...

Check: CTSS state

  Node Name                             State                  

  ------------------------------------  ------------------------

  hp7                                   Observer               

CTSS is in Observer state. Switching over to clock synchronization checks using NTP

 

 

Starting Clock synchronization checks using Network Time Protocol(NTP)...

 

NTP Configuration file check started...

The NTP configuration file "/etc/ntp.conf" is available on all nodes

NTP Configuration file check passed

 

Checking daemon liveness...

 

Check: Liveness for "xntpd"

  Node Name                             Running?                

  ------------------------------------  ------------------------

  hp7                                   no                     

Result: Liveness check failed for "xntpd"

PRVF-5494 : The NTP Daemon or Service was not alive on all nodes

PRVF-5415 : Check to see if NTP daemon or service is running failed

Result: Clock synchronization check using Network Time Protocol(NTP) failed

 

 

PRVF-9652 : Cluster Time Synchronization Services check failed

 

Verification of Clock Synchronization across the cluster nodes was unsuccessful on all the specified nodes.

这时检查$GRID_HOME/log/alert_p7.log

报以下错误:

[ctssd(790696)]CRS-2409:The clock on host p520 is not synchronous with the mean cluster time. No action has been taken as the Cluste
r Time Synchronization Service is running in observer mode.

从这里我们可以看出，在NTP没有运行的情况下，CTSS依然处于observer mode.

 

通过查询metalink 文档 ID为ID 1054006.1

If you choose to let CTSSD handle time synchronization, de-configure the vendor time sync service.  For example, for NTP you may need to move or remove /etc/ntp.conf or /etc/xntp.conf.

After choosing option 2 (and removing /etc/ntp.conf in my case), I now see a good time status reported by cluvfy:

按MT上的说法，做以下操作

在两个UNIX 节点上mv /etc/ntp.conf  /etc/ntp.conf.bak

然后重新运行 cluvfy comp clocksync –verbose

 

grid@hp7[+ASM2]:/home/grid$ cluvfy comp clocksync -verbose                                                                                                             

 

Verifying Clock Synchronization across the cluster nodes

 

Checking if Clusterware is installed on all nodes...

Check of Clusterware install passed

 

Checking if CTSS Resource is running on all nodes...

Check: CTSS Resource running on all nodes

  Node Name                             Status                 

  ------------------------------------  ------------------------

  hp7                                   passed                 

Result: CTSS resource check passed

 

 

Querying CTSS for time offset on all nodes...

Result: Query of CTSS for time offset passed

 

Check CTSS state started...

Check: CTSS state

  Node Name                             State                  

  ------------------------------------  ------------------------

  hp7                                   Active                 

CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...

Reference Time Offset Limit: 1000.0 msecs

Check: Reference Time Offset

  Node Name     Time Offset               Status                 

  ------------  ------------------------  ------------------------

  hp7           0.0                       passed                 

 

Time offset is within the specified limits on the following set of nodes:

"[hp7]"

Result: Check of clock time offsets passed

 

 

Oracle Cluster Time Synchronization Services check passed

 

Verification of Clock Synchronization across the cluster nodes was successful.

 

 

最后，我们再观察下时间

grid@hp7[+ASM2]:/home/grid$ ssh hp6 date;date

Fri Aug  2 15:03:36 EAT 2013

Fri Aug  2 15:03:36 EAT 2013