NTP sync issue!!!

[Fenny]

Hi Team,

I have a customer with NTP server running on HPUX11.31 and we have 3 servers running HPUX 11.31 as NTP clients. Now customer is running Oracle (RAC 11.2.03)cluster verification script and the script is reporting NTP sync issue’s below is the error message and attached is the oracle script 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

It’s a very basic NTP configuration when I check the ntpq –p output, I don’t find any issues. But I have no idea why oracle script is reporting NTP sync errors ,your support is required to help me resolve this issue.

NTP server:

frspdb3 #ntpq -p

     remote           refid      st t when poll reach   delay   offset    disp

==============================================================================

*LOCAL(1)        LOCAL(1)        10 l   11   64  377     0.00    0.000   10.01

NTP Client:

frspdb4 #ntpq -p

     remote           refid      st t when poll reach   delay   offset    disp

==============================================================================

*frspdb3.moe.loc LOCAL(1)        11 u   21  512  377     0.31    0.102    0.05

frstdb3 #ntpq -p

     remote           refid      st t when poll reach   delay   offset    disp

==============================================================================

*frspdb3.moe.loc LOCAL(1)        11 u  675 1024  377     0.70   -0.003    0.02

frstdb4 #ntpq -p

     remote           refid      st t when poll reach   delay   offset    disp

==============================================================================

*frspdb3.moe.loc LOCAL(1)        11 u   50   64  377     0.64    0.038    0.02

P.S. This thread has been moved from HP-UX>System Administration to HP-UX > networking. -HP Forum Moderator

[pooderbill]

ntpq -p looks normal, so I would assume that the Oracle script is defective. Since it is a script, just search for ntp in the script. Most likely the script was not tested on HP-UX. If you find the code, post it and we can take a look at what it is trying to do. The error messages are not useful.

[Fenny]

Customer DBA doesn’t know which command oracle script is using to check the ntp synchronization. Now the customer is insisting that our NTP server and client synchronization isn’t working properly.

For testing, customer is changing the NTP client time manually by using DATE command and after sometime I can see in syslog that NTP client is sending synchronization request and getting synchronized but in reality the time on Client stays behind.

And I can the below error messages in the syslog file.

Apr 22 16:23:52 frspdb4 xntpd[10624]: synchronisation lost

Apr 22 16:23:52 frspdb4 xntpd[10624]: Unsynchronized, possible remote server failure or defective hardware clock

Apr 22 16:25:39 frspdb4 lvmpud[4656]: Read task ticket=180 type=1

Apr 22 16:25:39 frspdb4 lvmpud[4656]: Process task ticket=180 type=1

Apr 22 16:25:39 frspdb4 lvmpud[4656]: Complete task ticket=180 type=1 status=0

Apr 22 16:26:33 frspdb4 xntpd[10624]: Unsynchronized, possible remote server failure or defective hardware clock

Apr 22 16:27:58 frspdb4  above message repeats 3 times

Apr 22 16:28:41 frspdb4 xntpd[10624]: synchronized to 10.1.162.41, stratum=11

Apr 22 16:38:16 frspdb4 xntpd[10624]: time reset (slew) 636.786331 s

Apr 22 16:38:16 frspdb4 xntpd[10624]: synchronisation lost

Apr 22 16:38:18 frspdb4 xntpd[10624]: Previous time adjustment incomplete; residual 0.022198 sec

Apr 22 16:38:19 frspdb4 xntpd[10624]: Previous time adjustment incomplete; residual 0.023800 sec

Apr 22 16:38:22 frspdb4 xntpd[10624]: Previous time adjustment incomplete; residual 0.023399 sec

Apr 22 16:38:32 frspdb4 xntpd[10624]: Previous time adjustment incomplete; residual 0.023400 sec

Apr 22 16:38:51 frspdb4 sshd[23861]: SSH: Server;Ltype: Kex;Remote: 10.1.35.182-61748;Enc: aes256-ctr;MAC: hmac-sha1;Comp: none

Apr 22 16:38:27 frspdb4 xntpd[10624]: Previous time adjustment incomplete; residual 0.023399 sec

Apr 22 16:40:45 frspdb4 lvmpud[4656]: Read task ticket=181 type=1

Apr 22 16:40:45 frspdb4 lvmpud[4656]: Process task ticket=181 type=1

Apr 22 16:38:37 frspdb4 xntpd[10624]: Previous time adjustment incomplete; residual 0.023800 sec

Apr 22 16:40:45 frspdb4  above message repeats 15 times

Apr 22 16:40:45 frspdb4 lvmpud[4656]: Complete task ticket=181 type=1 status=0

Apr 22 16:43:36 frspdb4 xntpd[10624]: synchronized to 10.1.162.41, stratum=11

Apr 22 16:56:20 frspdb4 lvmpud[4656]: Read task ticket=182 type=1

Apr 22 16:56:20 frspdb4 lvmpud[4656]: Process task ticket=182 type=1

Apr 22 16:56:20 frspdb4 lvmpud[4656]: Complete task ticket=182 type=1 status=0