golden gate replication error

[Roshan]

OGGREP.txtOracle Database 12.1.0.2(source)

Oracle Database 12.2.0 (target)

RHEL 7.4 (target)

 

Hello Erman,

I am getting the 3 errors attached whenever  I am replicating tables.
OGGREP.txt

Error is gone whenever I am using reperror (4098,DISCARD) and reperror (1403,DISCARD) respectively. However, it is not a wise method since this can lead to data discrepencies.

Can you please advise on how to correct?

Thanks,

Roshan

[ErmanArslansOracleBlog]

You have  ORA-01403 and ORA-04098 errors.. ( ofcourse you have OGG errors but having ORA- errors are better for diagnosing)

What is your Goldengate version?

[Roshan]

18.0

[ErmanArslansOracleBlog]

Check the notes below and update me;

Bug 13821170 - ORA-1403 raised by GoldenGate (Doc ID 13821170.8)
Oracle Replicat Abends with ORA-1403 (Doc ID 1981780.1)
GoldenGate Configuring DDL Replication - one Way (Doc ID 1950942.1) -- for error 4098
Also check this Oracle Golden Gate Replicat Abends With "OCI Error ORA-04098 Trigger Is Invalid And Failed Revalida (Doc ID 1621946.1) -- for error 4098

[Roshan]

Hi,

I applied latest PSU path for 12.2. I removed the reperror parameters. I removed the triggers which were not required. Then I reloaded the tables.

Error is now gone

[ErmanArslansOracleBlog]

Good for you then :)