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)