RAC Nodes Time Difference issue bcoz of NTP in 11gR2

In One of our client Time difference between the nodes were keep on increasing drastically.

I fed up by setting that manually between the nodes.

Finally Got a permanent Solution.

We have configured time synchronization using NTP network protocol. But late we have decided oracle to manage the time sync.

For this we have to stop NTP & enable CTSS thats it.. :)

CTSS - Cluster time synchronization Service.

 Time Synchronization – Steps

(Needs to be tested on a test Setup  -  Not tested)

1.       Stop the database

Oracle]$srvctl stop database –d erpdb –o immediate

2.Stop all cluster related services on both the nodes (stopping HAS would stop all the services)

Grid]$crsctl stop has

3.Stop ntp process and remove all the configuration files related to ntpd

# /sbin/service ntpd stop

#/sbin/service ntpd status

#chkconfig ntpd off

#mv  /etc/ntp.conf   /etc/ntp.conf_bkp

Remove the ntpd.pid file.

#rm  /var/run/ntpd.pid

Or  #mv /var/run/ntpd.pid /var/run/ntpd.pid_bkp

4.Now set the date by using date command in Linux by keeping 3 seconds difference between both Nodes

For Example:

Node1]date –s   12:00:00

Node]date –s  12:00:03

       5.As of Now ctss is in observer Mode.

       Reboot Both Nodes, Start high availability Service,

      6. Now check ctss status

      Grid]$crsctl check ctss

      It should be in Active Mode

      7.Start the database and related Services.