OGG-01004, OCI Error ORA-04098: trigger ‘User.Trigger’ is invalid and failed re-validation (status = 4098)

Issue:

WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, replicat_1.prm: Aborted grouped transaction on ‘<user>.<Table_name>’, Database error 4098
(OCI Error ORA-04098: trigger ‘<User>.<Trigger>’ is invalid and failed re-validation (status = 4098), SQL <DELETE FROM “<user>”.”<table_name>” WHERE “R
OW_ID” = :b0>)

 

Cause:

Triggers are causing issue while data is being loaded to table.

 

Resolution:

You could use the option “SUPRESSTRIGGERS” in the Replicat processes. If it still abends the Replicat process, you may have to disable the trigger in the database and restart the process.

sql> alter trigger ‘<User>.<Trigger>’ disable;

Advertisements
This entry was posted in Oracle Golden Gate. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s