My Oracle Support Banner

Replicat Abends With ORA-12543: TNS:Destination Host Unreachable (Doc ID 2620755.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

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" = 

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.