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 18.104.22.168
(Doc ID 2223844.1)
Last updated on FEBRUARY 07, 2019
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 22.214.171.124 to 126.96.36.199, 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 188.8.131.52.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 184.108.40.206 to 220.127.116.11.
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 18.104.22.168 to 22.214.171.124
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document