oracle 11GR2新特性 Cluster Time Synchronization Service 配置

    在oracle 11gR2 RAC版本中,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

安装完grid后,检查时间同步,发现没有同步

[grid@p520:/grid/app/grid]$ssh p650 date;date
Fri Feb 26 14:44:22 BEIST 2010
Fri Feb 26 14:44:26 BEIST 2010

用cluvfy comp clocksync -verbose 检查也没同步
[grid@p520:/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                 
  ------------------------------------  ------------------------
  p520                                  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                  
  ------------------------------------  ------------------------
  p520                                  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?               
  ------------------------------------  ------------------------
  p520                                  no                     
Result: Liveness check failed for "xntpd"
PRVF-5415 : Check to see if NTP daemon 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_p520.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.

通过查询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:

在两个AIX 节点上mv   /etc/ntp.conf   /etc/ntp.conf.bak 后,然后重新运行 cluvfy comp clocksync -verbose

[grid@p520:/grid/app/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                 
  ------------------------------------  ------------------------
  p520                                  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                  
  ------------------------------------  ------------------------
  p520                                  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                 
  ------------  ------------------------  ------------------------
  p520          0.0                       passed                 

Time offset is within the specified limits on the following set of nodes:
"[p520]"
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@p520:/grid/app/grid]$ssh p650 date;date
Fri Feb 26 17:42:12 BEIST 2010
Fri Feb 26 17:42:12 BEIST 2010

配置成功

 

 

 

 

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-628439/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-628439/