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

book

Article ID: 160739

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction


ERROR CODE/ MESSAGE:
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
Cause:
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

Resolution

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.