ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

ORA-06508: PL/SQL: could not find program unit being called: "PROTECT.ID_INCIDENTDELETOR"


Article ID: 160739


Updated On:


Data Loss Prevention Enforce


07 Sep 2012 00:01:30,293- Thread: 18 SEVERE [com.vontu.manager] Incident deletion failed. Incident deletion failed
07 Sep 2012 00:01:30,325- Thread: 18 SEVERE [com.vontu.manager] Incident Deletion Failed
java.sql.SQLException: ORA-04063: package body "PROTECT.ID_INCIDENTDELETOR" has errors
ORA-06508: PL/SQL: could not find program unit being called: "PROTECT.ID_INCIDENTDELETOR"
ORA-06512: at line 1


The following permissions were missing for the protect user on the database :

PRIVILEGE                                TABLE_NAME
     ---------------------------------------- ------------------------------
     DEBUG                                    DBMS_MONITOR
     EXECUTE                                DBMS_MONITOR
     SELECT                                   DBA_DATA_FILES
     SELECT                                   DBA_EXTENTS
     SELECT                                   DBA_SEGMENTS
     SELECT                                   DBA_TABLESPACES
     SELECT                                   DBA_TEMP_FILES
     SELECT                                   V_$DATABASE
     SELECT                                   V_$INSTANCE
     SELECT                                   V_$PARAMETER
     SELECT                                   V_$SESSION
     SELECT                                   V_$SQLAREA
     EXECUTE                                DBMS_LOCK
     SELECT                                   V_$SQL
     SELECT                                   V_$SQL_PLAN
     SELECT                                   V_$SQL_PLAN_STATISTICS_ALL

1. Grant select on V_$session to protect using sys as sysdba. Check to see if the incident deletion error is gone.  if still not resolved then follow step 2.

2. Grant rest of the privileges to "PROTECT" user. These privileges allow protect user to perform not only installation and upgrade, but daily operations too.

For additionally related information if errors persist, contact Technical Support.