R12 Autoconfig failed on jtfictx.sh INSTE8_PRF 1 – ORA-29874

Introduction: –

In this post we will know how to resolve R12 Autoconfig failed on jtfictx.sh INSTE8_PRF 1 – ORA-29874: warning in the execution of ODCIINDEXALTER routine.

How to R12 Autoconfig failed on jtfictx.sh INSTE8_PRF 1?

 
During EBS clone I faced the following error while try to run adcfgclone.pl on appsTier then autoconfig failed at appsTier. 
 
 
Autoconfig completed with errors.
/apps/inst/apps/TEST_test/admin/install/jtfictx.sh
script returned:
****************************************************
jtfictx.sh started at Thu Mar 30 15:28:49 IST 2017
SQL*Plus: Release 10.1.0.5.0 – Production on Thu Mar 30 15:28:49 2017
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-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,
DRG-10595: ALTER INDEX JTF_AMV_ITEMS_URL_CTX failed
DRG-11000: invalid keyword SYNC
ORA-06512: at “SYS.DBMS_SQL”, line 1120
ORA-06512: at line 96
 
 

Cause:-

 
 
The JTF_AMV_ITEMS_URL_CTX index is invalid for some reason.
 
 

Solution:-

 
 
The simple fix for this is to drop and recreate the index.

 

1:- Back-up your database

2:- Rebuild the JTF_AMV_ITEMS_URL_CTX index.

a. DROP INDEX JTF_AMV_ITEMS_URL_CTX FORCE

b. sqlplus uname/pwd @jtfiaibu.sql JTF JTF APPS

3:- Re-Run Autoconfig

4:- If the above command does not compile the index correctly then please retry the process again running step 2b as:

sqlplus uname/pwd @jtfiaibu.sql JTF JTF APPS


5:- Migrate the solution as appropriate to other environments.

 

May resolved R12 Autoconfig failed on jtfictx sh INSTE8_PRF 1.

If not, you may check below another helpful content to resolve R12 Autoconfig failed on jtfictx sh INSTE8_PRF 1.

References:

“Jtfictx.sh” Failed During Autoconfig On Application Tier, ORA-29874, DRG-10595 (Doc ID 1271186.1)
Oracle Text may not include Theme Functionality after Installation (Doc ID 262701.1)

How to resolve Cause: cmlmcm() failed due to ORA-20100:

Leave a Comment