Autoconfig fails with DRG-10502: Index JTF.JTF_AMV_ITEMS_URL

Autoconfig fails with DRG-10502: Index JTF.JTF_AMV_ITEMS_URL_CTX

Error:

Autoconfig failing with the below error:

Executing script in InstantiateFile:

jtfictx.sh

script returned:

****************************************************

jtfictx.sh started at Fri Jul 7 18:32:47 UTC 2023

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Jul 7 18:32:48 2023

Enter value for 1: Enter value for 2: Enter value for 3: Connected.

DECLARE

ERROR at line 1:

ORA-20000: Oracle Text error:

DRG-10502: index JTF.JTF_AMV_ITEMS_URL_CTX does not exist

ORA-06512: at "CTXSYS.DRUE", line 186

ORA-06512: at "CTXSYS.CTX_DDL", line 1231

ORA-06512: at "CTXSYS.AD_CTX_DDL", line 336

ORA-06512: at line 96

Solution:

1. Connect to Mid-tier node to directory: $JTF_TOP/patch/115/sql

2. sqlplus apps/apps_pwd

@jtfiimt.sql jtf jtf

@jtfiaitd.sql jtf jtf

@jtfiaitn.sql jtf jtf

@jtfiaitt.sql jtf jtf

@jtfiappr.sql apps

@jtfiaibu.sql jtf jtf apps

@jtfntsci.sql jtf jtf

@jtftkimi.sql jtf jtf

3. Verify all status columns are with VALID status

select index_name, domidx_status, domidx_opstatus, funcidx_status, status

from dba_indexes where index_type='DOMAIN' and index_name like 'JTF_AMV_ITEMS%';

4. Rerun autoconfig.

If you like please follow and comment