Oracle Golden Gate Replicat Abends With "OCI Error ORA-04098 Trigger Is Invalid And Failed Revalida (Doc ID 1621946.1)

Last updated on APRIL 08, 2016

Applies to:

Oracle GoldenGate - Version 11.2.1.0.17 and later
Information in this document applies to any platform.

Symptoms

 Replicat is abending with the following

2014-01-28 11:30:16  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, reptlpmc.prm:  Aborted grouped transaction on 'Q_FUTURE_DB.ACCESS_CHANNEL', Database error 4098 (OCI Error ORA-04098: trigger 'Q_FUTURE_DB.MH_ACCESS_CHANNEL' is invalid and failed re-validation (status = 4098). UPDATE "Q_FUTURE_DB"."ACCESS_CHANNEL" SET "UPDATE_USER" = :a1 WHERE "ACCESS_CHANNEL_ID" = :b0).
2014-01-28 11:30:16  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, reptlpmc.prm:  Repositioning to rba 1392 in seqno 10.
2014-01-28 11:30:16  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, reptlpmc.prm:  SQL error 4098 mapping Q_FUTURE_DB.ACCESS_CHANNEL to Q_FUTURE_DB.ACCESS_CHANNEL OCI Error ORA-04098: trigger 'Q_FUTURE_DB.MH_ACCESS_CHANNEL' is invalid and failed re-validation (status = 4098). UPDATE "Q_FUTURE_DB"."ACCESS_CHANNEL" SET "UPDATE_USER" = :a1 WHERE "ACCESS_CHANNEL_ID" = :b0.
2014-01-28 11:30:16  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, reptlpmc.prm:  Repositioning to rba 1392 in seqno 10.
2014-01-28 11:30:16  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, reptlpmc.prm:  Error mapping from Q_FUTURE_DB.ACCESS_CHANNEL to Q_FUTURE_DB.ACCESS_CHANNEL.
2014-01-28 11:30:16  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, reptlpmc.prm:  PROCESS ABENDING.

 

 

Changes

 

 

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