My Oracle Support Banner

Replicat Abends with ORA-29861 (Doc ID 1911446.1)

Last updated on FEBRUARY 22, 2019

Applies to:

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

Symptoms

On : 12.1.2.0.0 version, 1 - Oracle DB backend

When attempting to ,
the following error occurs.

ERROR
-----------------------
Wildcard MAP resolved (entry <schema>.*):
MAP "<schema>"."<table>",TARGET "<schema>"."<table>";
Using following columns in default map by name:
  col1, col2, col3, col4, col5, col6, col7, col8, col9, col10

2014-07-23 13:19:03 WARNING OGG-00869 OCI Error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE (status = 29861), SQL .

2014-07-23 13:19:03 WARNING OGG-01004 Aborted grouped transaction on '<schema>.<table>', Database error 29861 (OCI Error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE (status = 29861), SQL ).

2014-07-23 13:19:03 WARNING OGG-01003 Repositioning to rba 96834343 in seqno 13.

2014-07-23 13:19:04 WARNING OGG-01154 SQL error 29861 mapping <schema>.<table> to <schema>.<table> OCI Error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE (status = 29861), SQL .


2014-07-23 13:19:04 ERROR OGG-01296 Error mapping from <schema>.<table> to <schema>.<table>.

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
References


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