How to fix the Oracle error PRVF-09659: The time offset of “{1}” on node “{0}” against reference node “{3}” is NOT within specified limit of “{2}” milliseconds?

In this post, you’ll learn more about the Oracle ErrorPRVF-09659: The time offset of “{1}” on node “{0}” against reference node “{3}” is NOT within specified limit of “{2}” milliseconds with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRVF-09659: The time offset of “{1}” on node “{0}” against reference node “{3}” is NOT within specified limit of “{2}” milliseconds

Reason for the Error PRVF-09659: The time offset of “{1}” on node “{0}” against reference node “{3}” is NOT within specified limit of “{2}” milliseconds

Cause: One of the clocks, either on the current node, or on the reference node has drifted beyond limits.

How to fix the Error PRVF-09659: The time offset of “{1}” on node “{0}” against reference node “{3}” is NOT within specified limit of “{2}” milliseconds ?

You can fix this error in Oracle by following the below steps

Action: Monitor the offset over a longer duration and verify if the offset reduces over this period and falls within the threshold limits. Oracle Time Synchronization Service does periodic adjustments of the clock to attempt to bring it within threshold limits. If the threshold does not fall within limits over a period of time possibly due to a large deviation or drift, it is recommended that the Oracle processes on this node be shutdown, and the clock be adjusted on the problematic node suitably. It is NOT recommended to set a clock backwards.