Ora-29861: Domain Index Is Marked Loading/Failed/Unusable (Doc ID 1275948.1)

Last updated on MAY 28, 2014

Applies to:

Oracle Human Resources - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms


Applying <patch 9062727>, worker failed with the following error:

 

ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

while running
/u21/oracle/findevappl/per/11.5.0/patch/115/sql/perauaddrstatupg.sql

Nothing in the log to indicate a space issue. Did receive several ORA-00600: with argument of [17069] not dealing
with PER_ADDRESSES

SQL> select index_name, domidx_status, domidx_opstatus, funcidx_status, status
from dba_indexes where index_type='DOMAIN';

INDEX_NAME DOMIDX_STATU DOMIDX FUNCIDX_ STATUS
------------------------------ ------------ ------ -------- --------
IRC_DOCUMENTS_CTX1 VALID FAILED VALID
IRC_DOCUMENTS_CTX VALID VALID VALID
IRC_SEARCH_CRITERIA_CTX VALID FAILED VALID
IRC_POSTING_CON_TL_CTX VALID FAILED VALID
PER_ADDRESSES_N4 VALID FAILED VALID
PER_ADDRESSES_SPT VALID VALID VALID
HR_LOCATIONS_N1 VALID FAILED VALID
HR_LOCATIONS_SPT VALID VALID VALID

select index_name from dba_indexes where table_name = 'PER_ADDRESSES';

INDEX_NAME
------------------------------
PER_ADDRESSES_N4
PER_ADDRESSES_SPT
SYS_IL0000044598C00068$$
SYS_IL0000044598C00069$$
PER_ADDRESSES_FK1
PER_ADDRESSES_N2
PER_ADDRESSES_PK
PER_ADDRESSES_N3

SQL> ALTER INDEX HR.PER_ADDRESSES_N4 REBUILD
ALTER INDEX HR.PER_ADDRESSES_N4 REBUILD
*
ERROR at line 1:
ORA-29858: error occurred in the execution of ODCIINDEXALTER

---------

Error Message:

ORA-29861

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms