ORA-26702 Using Asynchronous Change Data Capture( CDC ) (Doc ID 297842.1)

Last updated on SEPTEMBER 13, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.0 to 10.2.0.5 [Release 8.1.7 to 10.2]
Information in this document applies to any platform.

Symptoms

When using Asynchronous Change Data Capture (CDC) the application of changes
to change tables stop although changes are being captured from the source
tables. The following error is being reported in DBA_APPLY_ERROR on the site
where the change tables are being updated.

ORA-26702 "shut the STREAMS/CDC apply engine down"


Output from DBA_APPLY_ERROR:

SELECT APPLY_NAME, SOURCE_DATABASE,
LOCAL_TRANSACTION_ID, ERROR_MESSAGE
FROM DBA_APPLY_ERROR;

APPLY_NAME SOURCE_DATABASE LOCAL_TRANSACTION_ID
----------------------- ------------------- ----------------------
ERROR_MESSAGE
--------------------------------------------------
CDC$A_POSITIONS_C_SET MAROON.WORLD 3.18.18161
ORA-26702: shut the STREAMS/CDC apply engine down

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