ORA-27486: insufficient privileges Error While Executing Purge Script

(Doc ID 2389073.1)

Last updated on APRIL 23, 2018

Applies to:

Oracle Communications Unified Inventory Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Customer using OOTB purging utility to purge the DISCONNECTED services from the UIM DB. Though the report is generated without any issue but deletion fails with following error:
/servicePurge.sh execute -ed 04/04/2018 -status disconnected
Please enter DB Credentials:
Username : XXXX
Password :
Report Generated : ServicePurgeReport-04-11-18-14-41-14.txt
==================================================================================
Warning: Records matching specified criteria will be permanently deleted.
  Please take backup before executing purge.
  The purge end date is within last 12 months.
==================================================================================
Number of services to be purged : 1
Are you sure you want to continue with service purge? (Y|N) Y
Populating data to temporary table.
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 146
ORA-06512: at "SYS.DBMS_SCHEDULER", line 288
ORA-06512: at "XXX.ASYNC_POPULATE_SERVICE_PURGE", line 11

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