CVU NTP Prerequisite Check Fails With PRVF-5410 and PRVF-5416 [ID 1384298.1]
Applies to:
Oracle Database - Standard Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
Symptoms
11gR2 Grid Infrastructure runcluvfy.sh fails with the following:
CVU output
NTP common Time Server Check started...
PRVF-5410 : Check of common NTP Time Server failed
PRVF-5416 : Query of NTP daemon failed on all nodes
Result: Clock synchronization check using Network Time Protocol(NTP) failed
However, ntp is running fine
# service ntpd status
ntpd (pid 20875) is running
Cause
This is due to bug 12313711, it happens when "ntpq" command returns only LOCAL ( or .LOCL.), i.e.
# ntpq -pn
remote refid st t when poll reach delay offset jitter
==============================================================================
*192.168.1.31 LOCAL(0) 11 u 75 128 377 0.234 0.017 0.203
Solution
At the time of this writing, the bug is still being worked by Development.
The workaround is to ensure ntp is configured properly with slew option, refer to note 1056693.1 for more details.
[root@rac1 ~]# more /etc/hosts
127.0.0.1 localhost.oracle.com localhost
#eth0 - PUBLIC
192.168.8.11 rac1.oracle.com rac1
192.168.8.12 rac2.oracle.com rac2
#VIP
192.168.8.21 rac1-vip.oracle.com rac1-vip
192.168.8.22 rac2-vip.oracle.com rac2-vip
#eth1 - PRIVATE
10.10.10.11 rac1-priv1
10.10.10.12 rac2-priv2
[root@rac1 ~]# nslookup rac-scan
Server: 192.168.8.11
Address: 192.168.8.11#53
Name: rac-scan.oracle.com
Address: 192.168.8.31
Name: rac-scan.oracle.com
Address: 192.168.8.32
Name: rac-scan.oracle.com
Address: 192.168.8.33
[root@rac1 ~]# ntpq -p
remote refid st t when poll reach delay offset jitter
==============================================================================
*192.168.8.180 LOCAL(0) 6 u 44 64 37 0.467 0.437 0.511
[root@rac2 ~]# ntpq -p
remote refid st t when poll reach delay offset jitter
==============================================================================
*192.168.8.180 LOCAL(0) 6 u 63 64 37 0.550 0.184 0.493
[root@rac1 ~]# grep OPTION /etc/sysconfig/ntpd
OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"
NTPDATE_OPTIONS=""
[root@rac1 ~]# ps -ef | grep ntp | grep -v grep
ntp 6004 1 0 10:25 ? 00:00:00 ntpd -x -u ntp:ntp -p /var/run/ntpd.pid
[root@rac2 ~]# grep OPTION /etc/sysconfig/ntpd
OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"
NTPDATE_OPTIONS=""
[root@rac2 ~]# ps -ef | grep ntp | grep -v grep
ntp 7751 1 0 10:25 ? 00:00:00 ntpd -x -u ntp:ntp -p /var/run/ntpd.pid
