Oracle sysdate内部时间与操作系统不一致

2014-11-24 18:28:01 · 作者: · 浏览: 0

/sbin/service ntpd status
ntpd (pid 4403) is running...


ps -ef|grep ntp
ntp 2113 1 0 Dec09 00:00:00 ntpd -u ntp:ntp -p /var/run/ntpd.pid -x


grep OPTIONS /etc/sysconfig/ntpd
OPTIONS="-u ntp:ntp -p /var/run/ntpd.pid -x"


To start:


/sbin/service ntpd start


[grid@rac01 ~]$ crsctl check ctss
CRS-4701: The Cluster Time Synchronization Service is in Active mode.
CRS-4702: Offset (in msec): 0

当ctss检测到系统上有ntp时,会自动将模式切换到被动模式
[grid@HBCADB001 ~]$ crsctl check ctss
CRS-4700: The Cluster Time Synchronization Service is in Observer mode.

SQL> select sessiontimezone,to_char(sysdate,'yyyymmdd hh24:mi:ss') from dual;
SESSIONTIMEZONE
---------------------------------------------------------------------------
TO_CHAR(SYSDATE,'
-----------------
+08:00
20121029 14:14:10


SQL> !date
Mon Oct 29 14:14:13 CST 2012
SQL>