[grid@va-stg-orac01 patch]$ sudo ntpq -p remote refid st t when poll reach delay offset jitter ============================================================================== *ntp4.thexchange .GPS. 1 u 55 64 37 82.308 1.482 1.986 dns3.thexchange 132.163.4.101 2 u 56 64 37 0.324 0.871 0.436 dns2.thexchange 132.163.4.101 2 u 56 64 37 0.250 1.304 0.397 dns1.thexchange 192.5.41.41 2 u 57 64 37 8.523 2.419 0.415 [grid@va-stg-orac01 patch]$ [grid@va-stg-orac02 va-stg-orac02]$ sudo ntpq -p remote refid st t when poll reach delay offset jitter ============================================================================== ntp4.thexchange .GPS. 1 u 57 64 37 83.017 40.120 77.907 *dns3.thexchange 132.163.4.101 2 u 59 64 37 1.394 155.990 106.775 dns2.thexchange 132.163.4.101 2 u 57 64 37 0.253 0.990 107.482 dns1.thexchange 192.5.41.41 2 u 55 64 37 8.446 119.842 75.718 [grid@va-stg-orac02 va-stg-orac02]$ [grid@va-stg-orac02 va-stg-orac02]$ /u01/app/11.2.0/grid/bin/cluvfy comp clocksync -noctss -n va-stg-orac01,va-stg-orac02 -verbose Verifying Clock Synchronization across the cluster nodes Starting Clock synchronization checks using Network Time Protocol(NTP)... NTP Configuration file check started... The NTP configuration file "/etc/ntp.conf" is available on all nodes NTP Configuration file check passed Checking daemon liveness... Check: Liveness for "ntpd" Node Name Running? ------------------------------------ ------------------------ va-stg-orac02 yes va-stg-orac01 yes Result: Liveness check passed for "ntpd" Checking NTP daemon command line for slewing option "-x" Check: NTP daemon command line Node Name Slewing Option Set? ------------------------------------ ------------------------ va-stg-orac02 yes va-stg-orac01 yes Result: NTP daemon slewing option check passed Checking NTP daemon's boot time configuration, in file "/etc/sysconfig/ntpd", for slewing option "-x" Check: NTP daemon's boot time configuration Node Name Slewing Option Set? ------------------------------------ ------------------------ va-stg-orac02 yes va-stg-orac01 yes Result: NTP daemon's boot time configuration check for slewing option passed NTP common Time Server Check started... NTP Time Server "192.5.41.41" is common to all nodes on which the NTP daemon is running NTP Time Server ".GPS." is common to all nodes on which the NTP daemon is running NTP Time Server "132.163.4.101" is common to all nodes on which the NTP daemon is running Check of common NTP Time Server passed Clock time offset check from NTP Time Server started... Checking on nodes "[va-stg-orac02, va-stg-orac01]"... Check: Clock time offset from NTP Time Server Time Server: 192.5.41.41 Time Offset Limit: 1000.0 msecs Node Name Time Offset Status ------------ ------------------------ ------------------------ va-stg-orac02 41.129 passed va-stg-orac01 2.271 passed Time Server "192.5.41.41" has time offsets that are within permissible limits for nodes "[va-stg-orac02, va-stg-orac01]". Time Server: .GPS. Time Offset Limit: 1000.0 msecs Node Name Time Offset Status ------------ ------------------------ ------------------------ va-stg-orac02 40.12 passed va-stg-orac01 1.482 passed Time Server ".GPS." has time offsets that are within permissible limits for nodes "[va-stg-orac02, va-stg-orac01]". Time Server: 132.163.4.101 Time Offset Limit: 1000.0 msecs Node Name Time Offset Status ------------ ------------------------ ------------------------ va-stg-orac02 41.183 passed va-stg-orac01 1.304 passed Time Server "132.163.4.101" has time offsets that are within permissible limits for nodes "[va-stg-orac02, va-stg-orac01]". Clock time offset check passed Result: Clock synchronization check using Network Time Protocol(NTP) passed Oracle Cluster Time Synchronization Services check passed Verification of Clock Synchronization across the cluster nodes was successful. [grid@va-stg-orac02 va-stg-orac02]$ [grid@va-stg-orac02 va-stg-orac02]$ /u01/app/11.2.0/grid/bin/cluvfy comp clocksync -noctss -n va-stg-orac01,va-stg-orac02 -verbose Verifying Clock Synchronization across the cluster nodes Starting Clock synchronization checks using Network Time Protocol(NTP)... NTP Configuration file check started... The NTP configuration file "/etc/ntp.conf" is available on all nodes NTP Configuration file check passed Checking daemon liveness... Check: Liveness for "ntpd" Node Name Running? ------------------------------------ ------------------------ va-stg-orac02 yes va-stg-orac01 yes Result: Liveness check passed for "ntpd" Checking NTP daemon command line for slewing option "-x" Check: NTP daemon command line Node Name Slewing Option Set? ------------------------------------ ------------------------ va-stg-orac02 yes va-stg-orac01 yes Result: NTP daemon slewing option check passed Checking NTP daemon's boot time configuration, in file "/etc/sysconfig/ntpd", for slewing option "-x" Check: NTP daemon's boot time configuration Node Name Slewing Option Set? ------------------------------------ ------------------------ va-stg-orac02 yes va-stg-orac01 yes Result: NTP daemon's boot time configuration check for slewing option passed NTP common Time Server Check started... NTP Time Server "192.5.41.41" is common to all nodes on which the NTP daemon is running PRVF-5408 : NTP Time Server "192.5.41.40" is common only to the following nodes "va-stg-orac01" NTP Time Server ".GPS." is common to all nodes on which the NTP daemon is running NTP Time Server "192.43.244.18" is common to all nodes on which the NTP daemon is running PRVF-5408 : NTP Time Server "132.163.4.101" is common only to the following nodes "va-stg-orac02" Check of common NTP Time Server passed Clock time offset check from NTP Time Server started... Checking on nodes "[va-stg-orac02, va-stg-orac01]"... Check: Clock time offset from NTP Time Server Time Server: 192.5.41.41 Time Offset Limit: 1000.0 msecs Node Name Time Offset Status ------------ ------------------------ ------------------------ PRVF-5413 : Node "va-stg-orac02" has a time offset of -13689.0 that is beyond permissible limit of 1000.0 from NTP Time Server "192.5.41.41" va-stg-orac02 -13689.0 failed va-stg-orac01 2.227 passed Time Server "192.5.41.41" has time offsets that are within permissible limits for nodes "[va-stg-orac02, va-stg-orac01]". Time Server: .GPS. Time Offset Limit: 1000.0 msecs Node Name Time Offset Status ------------ ------------------------ ------------------------ PRVF-5413 : Node "va-stg-orac02" has a time offset of -13859.0 that is beyond permissible limit of 1000.0 from NTP Time Server ".GPS." va-stg-orac02 -13859.0 failed va-stg-orac01 -1.973 passed Time Server ".GPS." has time offsets that are within permissible limits for nodes "[va-stg-orac02, va-stg-orac01]". Time Server: 192.43.244.18 Time Offset Limit: 1000.0 msecs Node Name Time Offset Status ------------ ------------------------ ------------------------ PRVF-5413 : Node "va-stg-orac02" has a time offset of -13822.0 that is beyond permissible limit of 1000.0 from NTP Time Server "192.43.244.18" va-stg-orac02 -13822.0 failed va-stg-orac01 0.625 passed Time Server "192.43.244.18" has time offsets that are within permissible limits for nodes "[va-stg-orac02, va-stg-orac01]". Clock time offset check passed Result: Clock synchronization check using Network Time Protocol(NTP) passed Oracle Cluster Time Synchronization Services check passed Verification of Clock Synchronization across the cluster nodes was successful. [grid@va-stg-orac02 va-stg-orac02]$ |
DBA's Home Page - A website for Oracle, Greenplum and PostgreSQL DBA's > DBA's Forum, Routine Tasks and Activities >