My Oracle Support Banner

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

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:
script returned:
**************************************************** 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
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>

AutoConfig could not successfully execute the following scripts:
Directory: /app/oracle/test/inst/apps/test_testfis/admin/install               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 "", the below errors generated:

/ started at Mon Sep 12 12:42:46 BST 2011

APPS username: apps

APPS password:

SQL*Plus: Release - 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-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


To view full details, 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 a vibrant support community of peers and Oracle experts.