Intermittently LCR Propagation in a Streams environment does not restart when Latency > 0

(Doc ID 2026411.1)

Last updated on JULY 01, 2015

Applies to:

Oracle Database - Enterprise Edition - Version to [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