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 188.8.131.52.0 and later
Information in this document applies to any platform.
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
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
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