The internal time of Oracle sysdate is inconsistent with that of the Operating System

Source: Internet
Author: User
Tags oracle sysdate

Oracle 11g RAC, internal time is synchronized through the ctss service, during installation, ntpd will be removed by default, using ctss.
However, after running for a period of time, it is found that there is a time difference between the oracle internal time and the operating system. Therefore, the oracle database and the operating system need a time synchronization server;

/Sbin/service ntpd status
Ntpd (pid 4403) is running...

Ps-ef | grep ntp
Ntp 2113 1 0 Dec09? At 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
The CRS-4701: The Cluster Time Synchronization Service is in Active mode.
CRS-4702: Offset (in msec): 0
 
When the ctss detects that there is ntp on the system, it automatically switches the mode to the passive mode.
[Grid @ HBCADB001 ~] $ Crsctl check ctss
The 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
14:14:10 20121029

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.