Last updated on AUGUST 07, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
In CDC “Asynchronous Distributed Hotlog” with upstream capture you see following error in alert log file from source database:
ORA-26840: Optimized capture and apply is disabled because an Apply operation for the source database can not be identified.
ORA-26840: Optimized combined capture and apply is disabled because streams can not identify an Apply operation for the source database "ORCL"
ORA-02063: previous line of DBLINK_NAME
Although capture starts just fine, no changes are propagated to destination.
After setting up second change set for CDC
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms