Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
Autoconfig DRG-10502: Index JTF.JTF_AMV_ITEMS_URL_CTX DNE
ERROR:
Autoconfig failing with the below error:
jtfictx.sh
script returned:
****************************************************
jtfictx.sh started at Tue Oct 10 02:23:11 UTC 2023
SQL*Plus: Release 10.1.0.5.0 – Production on Tue Oct 10 02:23:11 UTC 2023
Copyright (c) 1982, 2005, Oracle. All rights reserved.
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
ORA-06512: at line 96
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
jtfictx.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
SOLUTION:
1. Connect to Mid-tier node to directory: $JTF_TOP/patch/115/sql
2. sqlplus apps/(password)
@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.
