Oracle E - Business suite : R12.1.3 on Linux 64 bits and Oracle Database 11.2.0.3 on same plateform.

I have upgraded E-business suite application from R12.1.1 to R12.1.3. all steps were completed successfully except autoconfig. I faced following error during autoconfig.

Error:

Autoconfig completed with errors.

 =============

DECLARE
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11422: linguistic initialization failed
DRG-11446: supplied knowledge base file
/u01/app/orar12/db/tech_st/11.2.0/ctx/data/enlx/droldUS.dat not installed
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366
ORA-06512: at "SYS.DBMS_SQL", line 1199
ORA-06512: at line 37

 =============

Cause:

An Issue is the CTXSTS.DEFAULT_LEXER. INDEX_THEMES attribute was made to YES.

 
Solutions:

  1.  Shut down the database and applications.

  2.  Make sure ORA_NLS10 is unset on dbTier

        $ unset ORA_NLS10

  3.  Startup the database.

  4.  Drop index jtf.JTF_AMV_ITEMS_URL_CTX

                        SQL> drop index jtf.JTF_AMV_ITEMS_URL_CTX FORCE;

                        Index dropped.

  5.  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.