Error Code 2309 - System statistics update failed

Products

• Data Loss Prevention Enforce
• Data Loss Prevention
• Data Loss Prevention Core Package

Issue/Introduction

The Enforce console displays the following message on the System > Servers and Detectors > Events page:

 <date/timestamp> | Enforce Server | <host/IP address> | 2309 | System statistics update failed. 

Additionally, the following message is found in the Enforce server's localhost log file:

SEVERE [com.vontu.manager.system.statistics.DatabaseSpaceMonitor] Unable to verify database tablespace usage
Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

 

 

Cause

The database user (default username: protect) is missing permissions in the Oracle database.

Resolution

Grant the following permissions to the protect account:

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_$PARAMETERS
SELECT	V_$SESSION
SELECT	V_$SQLAREA
EXECUTE	DBMS_LOCK
SELECT	V_$SQL
SELECT	V_$SQL_PLAN
SELECT	V_$SQL_PLAN_STATISTICS_ALL

See also: KB 160076: verify or grant oracle database permissions