Arhdqcp1.Sql Errors with ORA-01031: insufficient privileges

(Doc ID 443655.1)

Last updated on JULY 11, 2017

Applies to:

Oracle Trading Community - Version to [Release 11.5]
Information in this document applies to any platform.


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




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