Symptoms

When attempting to run autoconfig on the applications tier, jtfictx.sh causes the following error to occur.


Error

SQL*Plus: Release 10.1.0.5.0 - Production ON Sun Feb 3 05:05:55 2013
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-10561: INDEX JTF_AMV_ITEMS_URL_CTX IS NOT valid FOR requested operation
ORA-06512: at "SYS.DBMS_SQL", line 1199
ORA-06512: at line 96
Disconnected FROM Oracle DATABASE 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing options
jtfictx.sh exiting WITH STATUS 1
ERRORCODE = 1 ERRORCODE_END

Solution

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

  • Back-up your database
  • Rebuild the JTF_AMV_ITEMS_URL_CTX index.
  • DROP INDEX JTF_AMV_ITEMS_URL_CTX FORCE
sqlplus uname/pwd @jtfiaibu.SQL JTF JTF APPS
  • Re-Run Autoconfig
  • 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 APPS JTF
  • Migrate the solution as appropriate to other environments.

Metalink ID : 1334405.1

Tagged with →  
Share →
0 comments
Skip to toolbar