Autoconfig Failed On Apps Tier "jtfictx.sh INSTE8_PRF" . Running manually "jtfictx.sh " Failed on "DRG-10758: index owner does not have the privilege"
Last updated on JANUARY 04, 2018
Applies to:Oracle Applications Technology Stack - Version 12.1.1 to 12.1.3 [Release 12.1]
Oracle Applications Manager - Version 11.5.9 to 11.5.9 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 10-April-2013***
On : 12.1.1 version (upgraded from 12.0.6), running AutoConfig on The APPS Tier failed on the error below:
Executing script in InstantiateFile:
igccmprf.sh started at Mon Sep 12 10:44:57 BST 2011
The environment settings are as follows ...
ORACLE_HOME : /app/oracle/test/apps/tech_st/10.1.2
TWO_TASK : test
PATH : /app/oracle/test/inst/apps/test_testfis/admin/scripts:/app/oracle/test/apps/tech_st/10.1.3/perl/bin:/app
Purging the table ADX_PRE_AUTOCONFIG of rows containing attribute test_testfis
Restore Profile utility ran successfully
adcvmlog.xml renamed to /app/oracle/test/inst/apps/test_testfis/admin/log/09121043/adcvmlog.xml.09121045
[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:
<filename> <phase> <return code where appropriate>
AutoConfig could not successfully execute the following scripts:
jtfictx.sh INSTE8_PRF 1
AutoConfig is exiting with status 1
AutoConfig execution completed on Mon Sep 12 10:45:01 2011
Time taken for AutoConfig execution to complete : 1 mins 18 secs
b- When trying to execute manually this failed script " jtfictx.sh", the below errors generated:
jtfictx.sh started at Mon Sep 12 12:42:46 BST 2011
APPS username: apps
SQL*Plus: Release 10.1.0.5.0 - Production on Mon Sep 12 12:42:51 2011
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-10758: index owner does not have the privilege to use file or URL datastore
ORA-06512: at "SYS.DBMS_SQL", line 1199
ORA-06512: at line 96
Upgrade from R12.0.6 to 12.1.1
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms