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

Last updated on JULY 02, 2024

Applies to:

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

Changes

Cause

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