R12 E-Business Suite Autoconfig Fails On Script jtfictx.sh With Errors ORA-29874: warning in the execution of ODCIINDEXALTER routine And DRG-100595 and DRG-11000 After An Upgrade To 12.1.3 And RDBMS 22.214.171.124
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Applications DBA - Version 12.1.3 and later
Information in this document applies to any platform.
E-Business Suite R12 Applications DBA, Upgrade Related issues
After an upgrade from R12.0.6 to R12.1.3 including a database migration from 126.96.36.199 to 188.8.131.52, AutoConfig fails with the following error:
jtfictx.sh started at Mon Jan 16 09:00:00 2017
SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jan 16 09:00:00 2017
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter value for 1: Enter value for 2: Enter value for 3: Connected.
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
Disconnected from Oracle Database 12c Enterprise Edition Release 184.108.40.206.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
jtfictx.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
AutoConfig could not successfully execute the following scripts:
jtfictx.sh INSTE8_PRF 1
AutoConfig is exiting with status 1
The issue can be reproduced at will with the following steps:
1. Upgrade R12.0.6 to R12.1.3
2. Upgrade database from 220.127.116.11 to 18.104.22.168.
3. Run AutoConfig on DB Tier and then run AutoConfig on AP Tier.
Upgraded EBS from R12.0.6 to R12.1.3 and Database from 22.214.171.124 to 126.96.36.199
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms