My Oracle Support Banner

Replicat Abends With ORA-29861 Domain Index Is Marked LOADING/FAILED (Doc ID 2701108.1)

Last updated on AUGUST 17, 2020

Applies to:

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

Symptoms

Replicat is abended with following errors:

2020-08-14 02:14:02 WARNING OGG-01004 Aborted grouped transaction on <SCHEMANAME>.<TABLENAME>, Database error 29861 (OCI Error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE (status = 29861), SQL <INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "SCHEMANAME"."TABLENAME" ("COL1","COL2","COL3","COL4","COL5","COL6") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6)>).



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
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.