Integrated Replicat PL/SQL Error Handler Stops Working or Does Not Get Invoked, Transactions Will Fail With ORA-1403. (Doc ID 2111039.1)

Last updated on APRIL 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

A custom PL/SQL DML or Error handler configured with IE stops working.

It may get invoked at the very first time its called to handle the exception after IR re-start, but after that it does not get invoked anymore and the transaction ends up at the IR error queue and discard file with ORA-1403 error.

Note that manually executing the failed transaction thru the Streams API (dbms_apply_adm.execute_error) will work fine and the handler will be invoked normally to resolve the conflict.

 

 

Changes

Upgraded replication environment from Oracle Streams to Oracle Goldengate.

Configured CDR for Oracle Goldengate thru DBMS_APPLY_ADM.SET_DML_HANDLER.

Migrated Streams to OGG using Streams2OGG tool.

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