On SharePlex 7 and up capture process is in an idle state for an hour after the time change to reflect end of daylight saving time (DST).
When SharePlex starts, capture inherits the system time and compares it with the database transaction time before processing. The SharePlex parameter SP_OCT_REDOLOG_ENSURE which by default is enabled (set to 2) ensures that the capture process never gets ahead of Oracle by ensuring that capture is always 2 seconds behind oracle. During the time change when the system clock gets set back 1 hour, the capture process compares the system time with the transaction time and as they are different, capture waits for one hour and 2 seconds before it was processed. There are couple of ways to resolve this issue
WORKAROUND 1:
Not change the system clock.
WORKAROUND 2:
For version below 7.5.2.34:
Disable the SP_OCT_REDOLOG_ENSURE parameter (set it to 0) (Use this with caution, as disabling this can cause SharePlex to try and read ahead of Oracle, thus causing corruption).
For version 7.5.2.34 and up:
Disable the SP_OCT_USE_DST parameter (set it to 0).
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy