ORA-27486: insufficient privileges Error While Executing Purge Script
Last updated on APRIL 23, 2018
Applies to:Oracle Communications Unified Inventory Management - Version 220.127.116.11.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
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