Replicat Abends With ORA-12543: TNS:Destination Host Unreachable
(Doc ID 2620755.1)
Last updated on DECEMBER 31, 2019
Applies to:Oracle GoldenGate - Version 188.8.131.52.4 and later
Information in this document applies to any platform.
Replicat abends with following errors:
2019-11-22 08:57:10 WARNING OGG-01004 Aborted grouped transaction on <SCHEMNAME>.<TABLENAME>, Database error 4045 (OCI Error ORA-04045: errors during recompilation/revalidation of <SCHEMANAME>.T_XXXX_AAAA_TEST
ORA-04052: error occurred when looking up remote object <SCHEMANAME>.<OBJECTNAME>@VMXXXXXX1
ORA-00604: error occurred at recursive SQL level 2
ORA-12543: TNS:destination host unreachable (status = 4045), SQL <UPDATE /*+ RESTRICT_ALL_REF_CONS */ "<SCHEMANAME>"."<TABLENAME>" x SET x."COl1" = :a91,x."COl2" = :a92,x."COl3" = :a93,x."COL4" = :a94,x."COL5" = :a95,x."COL6" = :a96,x."COL7" = :a97,x."COL8" = :a98,x."COL9" = :a99,x."COL10" =
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