My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.