My Oracle Support Banner

Arhdqcp1.Sql Errors with ORA-01031: insufficient privileges (Doc ID 443655.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Trading Community - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On 11.5.10.2 in Production:
When attempting to use <Note 312640.1> - Oracle Text: Re-installation of Applications 11i (11.5.10)
Oracle Text Indexes- to Re-Install Oracle text Indexes, the following error occurs.

ERROR
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYSTEM.AD_DDL", line 2280
ORA-06512: at line 17



Steps To Reproduce:
This error occurs when running
$AR_TOP/patch/115/sql/arhdqcp1.sql - logged in as APPS -
sql> @arhdqcp1 apps ctxsys ar



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.