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