Setting up slewing NTP option in Linux for Oracle Database

Many times while installing/configuring Oracle Cluster, DBA’s  receive the following error message.

Checking NTP daemon command line for slewing option “-x”Check: NTP daemon command line

Node Name                     Slewing Option Set?  ————————————  ————————

vcsnode1                         no

vcsnode2                         no

Result:NTP daemon slewing option check failed on some nodes PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option “-x”Result: Clock synchronization check using Network Time Protocol(NTP) failed

To fix this error, slewing needs to be configured.

Follow the below steps to configure slewing in Linux.

• Stop ntpd daemon using the following command.

[root@vcsnode1 ~]# service ntpd stop

Shutting down ntpd:                                        [  OK  ]

[root@vcsnode1 ~]#

• Edit /etc/sysconfig/ntpd file.  Usually the file looks as given below.

[root@vcsnode1 sysconfig]# cat ntpd
# Drop root to id ‘ntp:ntp’ by default.
OPTIONS=”-u ntp:ntp -p /var/run/ntpd.pid”

# Set to ‘yes’ to sync hw clock after successful ntpdate
SYNC_HWCLOCK=no
[root@vcsnode1 sysconfig]#

• Edit the file and add “-x” to  ”OPTIONS=”-u ntp:ntp -p /var/run/ntpd.pid”" line befor e”-u”
• After editing the file, the contents should look like given below

[root@vcsnode1 sysconfig]# cat ntpd
# Drop root to id ‘ntp:ntp’ by default.
OPTIONS=”-x -u ntp:ntp -p /var/run/ntpd.pid”

# Set to ‘yes’ to sync hw clock after successful ntpdate
SYNC_HWCLOCK=no
[root@vcsnode1 sysconfig]#

• Start ntpd daemon using the following command

[root@VCSNode2 ~]# service ntpd start

Starting ntpd:                                             [  OK  ]

[root@VCSNode2 ~]#

• Ask the DBA to install/proceed to configure Oracle Cluster