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 10.2.0.1 to 12.1.0.2 [Release 10.2 to 12.1]
Information in this document applies to any platform.

Symptoms

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.

Cause

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