Autoconfig Failed On Apps Tier "jtfictx.sh INSTE8_PRF" . Running manually "jtfictx.sh " Failed on "DRG-10758: index owner does not have the privilege" (Doc ID 1357760.1)

Last updated on AUGUST 03, 2016

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

Symptoms

On : 12.1.1 version (upgraded from 12.0.6), running AutoConfig on The APPS Tier failed on the error below:

ERROR
-----------------------
Executing script in InstantiateFile:
/app/oracle/test/inst/apps/test_testfis/admin/install/igccmprf.sh
script returned:
****************************************************
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
ORACLE_SID :
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
/oracle/test/apps/tech_st/10.1.2/bin:/app/oracle/test/apps/apps_st/appl/fnd/12.0.0/bin:/app/oracle/test/apps/apps_st/appl/ad/
12.0.0/bin:/app/oracle/test/apps/tech_st/10.1.3/appsutil
.....
..
Purging the table ADX_PRE_AUTOCONFIG of rows containing attribute test_testfis
Purging completed

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>

[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /app/oracle/test/inst/apps/test_testfis/admin/install

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

jtfictx.sh started at Mon Sep 12 12:42:46 BST 2011

APPS username: apps

APPS password:

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

 



Changes

Upgrade from R12.0.6 to 12.1.1

Cause

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