EBS R12.1.1 Maintenance Pack7303030 is failing with ORA-29861: domain index is marked LOADING/FAILED
Hi Nagaraju,
Welcome to patching community !!!
Issue:
EBS R12.1.1 Maintenance Pack7303030 is failing with following error in the worker logs.
sqlplus -s APPS/***** @/u01/dev/apps/apps_st/appl/per/12.0.0/patch/115/sql/perauaddrstatupg.sql
DECLARE
*
ERROR at line 1:
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
ORA-06512: at line 5
SQL> select INDEX_NAME, STATUS,DOMIDX_STATUS, DOMIDX_OPSTATUS, index_type from dba_indexes where table_name='PER_ADDRESSES';
INDEX_NAME STATUS DOMIDX_STA DOMIDX_OPS INDEX_TYPE
-------------------- ---------- ---------- ---------- ----------
PER_ADDRESSES_SPT VALID VALID FAILED DOMAIN
PER_ADDRESSES_N4 VALID VALID FAILED DOMAIN
sqlplus -s APPS/***** @/u01/dev/apps/apps_st/appl/per/12.0.0/patch/115/sql/perauaddrstatupg.sql
DECLARE
*
ERROR at line 1:
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
ORA-06512: at line 5
SQL> select INDEX_NAME, STATUS,DOMIDX_STATUS, DOMIDX_OPSTATUS, index_type from dba_indexes where table_name='PER_ADDRESSES';
INDEX_NAME STATUS DOMIDX_STA DOMIDX_OPS INDEX_TYPE
-------------------- ---------- ---------- ---------- ----------
PER_ADDRESSES_SPT VALID VALID FAILED DOMAIN
PER_ADDRESSES_N4 VALID VALID FAILED DOMAIN
Thanks and Regards
Samya Sourav
Tagged:
0