Intermittently LCR Propagation in a Streams environment does not restart when Latency > 0
Last updated on JULY 01, 2015
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 126.96.36.199 [Release 10.2 to 12.1]
Information in this document applies to any platform.
Intermittently propagation of LCRs from one database to another stops and the propagation schedule has to be stopped and restarted in order for the LCRs to flow again and the latency of the schedules is > 0.
In addition to this the affected schedules have been created via the DBMS_PROPAGATION_ADM.CREATE_PROPAGATION api.
DBMS_AQADM.ALTER_PROPAGATION_SCHEDULE may have been used to alter the latency to 0 from the default value of 3 seconds in an attempt to resolve the issue.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms