GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Integrated Replicat

edited Sep 4, 2017 5:01AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered

Hello

I noticed something interesting with an integrated replicat I have.

Environment:

OGG 12.2.0.1.1

DB - Oracle 12.1.0.2

Platform : EXADATA with Linus as OS

Issue:

I have integrated replicat running.  Most tables have an additional column in the Target PK and have DML Handler Rules defined on them.  The DML Handler Rules add the additional columns and assign values and also convert updates and deletes into inserts.

The replicat abended and when I checked the report, it had an unhandled error reported from the DML Handler User Procedure while replicating a delete and converting it into an insert.

The rpt file also reported that the replicat retried in direct mode.  This failed with a no_data_found.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center