My Oracle Support Banner

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 MARCH 19, 2019

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

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.