在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