Jtfictx.sh" Failed During Autoconfig On Application Tier, ORA-29874, DRG-10595

• Shut down the database and applications.

•  Make sure ORA_NLS10 is unset on dbTier

$ unset ORA_NLS10

• Startup the database.

$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 30 10:36:12 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1.2827E+10 bytes

Fixed Size                  2240344 bytes

Variable Size            1040187560 bytes

Database Buffers         1.1744E+10 bytes

Redo Buffers               40890368 bytes

Database mounted.

Database opened.

• Drop index jtf.JTF_AMV_ITEMS_URL_CTX

SQL> drop index jtf.JTF_AMV_ITEMS_URL_CTX FORCE;

Index dropped.

• Re-run  jtfictx.sh again

cd $COMMON_TOP/admin/install/CONTEXT_NAME

$ . ./jtfictx.sh

 

bash started at Wed Oct 30 10:40:35 PDT 2013

Enter the APPS username: apps

Enter the APPS password:

SQL*Plus: Release 8.0.6.0.0 - Production on Wed Oct 30 10:40:40 2013

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

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

  

PL/SQL procedure successfully completed.

 

Commit complete.