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 12.1.0.1 (Doc ID 2223844.1) To BottomTo Bottom
APPLIES TO:
Oracle Applications DBA - Version 12.1.3 and later
Information in this document applies to any platform.
SYMPTOMS
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 11.2.0.3 to 12.1.0.1, AutoConfig fails with the following error:
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.
DECLARE
*
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 12.1.0.1.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:
[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /prodapps/PROD/inst/apps/UPDB8_oupapp/admin/install
jtfictx.sh INSTE8_PRF 1
AutoConfig is exiting with status 1
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade R12.0.6 to R12.1.3
2. Upgrade database from 11.2.0.3 to 12.1.0.1.
3. Run AutoConfig on DB Tier and then run AutoConfig on AP Tier.
CHANGES
Upgraded EBS from R12.0.6 to R12.1.3 and Database from 11.2.0.3 to 12.1.0.1
CAUSE
One of the mandatory patches for the 12.1.3 upgrade was not applied:
Patch 16289505 - INTEROPERABILITY PATCH FOR EBS 12.1.3 ON RDBMS 12C (12.1.0.1)
The case is discussed in the following bug:
BUG 22235648 AFTER 12C DATABASE UPGRADE ISSUE WITH AUTOCONFIG - JTFICTX.SH EXITING WITH STATUS,
Per the above bug the following SQL statement should have been replaced with call to ad_ctx_ddl.sync_index in jtfirip_ux.sql 120.4.12010000.4:
ALTER INDEX REBUILD ON LINE PARAMETERS('sync')
This file should have been provided with patch 16289505 when upgrading DB to 12.1.0.1 as stated in the following document:
Note 1524398.1 - Interoperability Notes EBS 12.0 or 12.1 with RDBMS 12cR1
SOLUTION
To resolve the issue test the following steps in a development instance and then migrate accordingly:
1. Download Patch 16289505 along with any required prerequisite patches.
2. Apply Patch 16289505 along with any required prerequisite patches per the readme instructions.
3. Restart the instance to ensure the changes are successful.
4. Retest AutoConfig and confirm the error is resolved.
APPLIES TO:
Oracle Applications DBA - Version 12.1.3 and later
Information in this document applies to any platform.
SYMPTOMS
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 11.2.0.3 to 12.1.0.1, AutoConfig fails with the following error:
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.
DECLARE
*
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 12.1.0.1.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:
[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /prodapps/PROD/inst/apps/UPDB8_oupapp/admin/install
jtfictx.sh INSTE8_PRF 1
AutoConfig is exiting with status 1
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade R12.0.6 to R12.1.3
2. Upgrade database from 11.2.0.3 to 12.1.0.1.
3. Run AutoConfig on DB Tier and then run AutoConfig on AP Tier.
CHANGES
Upgraded EBS from R12.0.6 to R12.1.3 and Database from 11.2.0.3 to 12.1.0.1
CAUSE
One of the mandatory patches for the 12.1.3 upgrade was not applied:
Patch 16289505 - INTEROPERABILITY PATCH FOR EBS 12.1.3 ON RDBMS 12C (12.1.0.1)
The case is discussed in the following bug:
BUG 22235648 AFTER 12C DATABASE UPGRADE ISSUE WITH AUTOCONFIG - JTFICTX.SH EXITING WITH STATUS,
Per the above bug the following SQL statement should have been replaced with call to ad_ctx_ddl.sync_index in jtfirip_ux.sql 120.4.12010000.4:
ALTER INDEX REBUILD ON LINE PARAMETERS('sync')
This file should have been provided with patch 16289505 when upgrading DB to 12.1.0.1 as stated in the following document:
Note 1524398.1 - Interoperability Notes EBS 12.0 or 12.1 with RDBMS 12cR1
SOLUTION
To resolve the issue test the following steps in a development instance and then migrate accordingly:
1. Download Patch 16289505 along with any required prerequisite patches.
2. Apply Patch 16289505 along with any required prerequisite patches per the readme instructions.
3. Restart the instance to ensure the changes are successful.
4. Retest AutoConfig and confirm the error is resolved.
No comments:
Post a Comment