Audit Vault Data Warehouse Refresh Fails With ORA-1031 (Doc ID 764058.1)

Last updated on AUGUST 11, 2009

Applies to:

Oracle Audit Vault - Version: 10.2.3.1.0 to 10.2.3.2.0
This problem can occur on any platform.

Symptoms

Audit Vault data warehouse refresh is failing with the following errors:

avctl refresh_warehouse -wait
AVCTL started
Refreshing warehouse...
Waiting for refresh to complete...
Error executing task refresh_warehouse: ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
ORA-06512: at "AVSYS.DBMS_AUDIT_VAULT", line 854
ORA-06512: at line 1


Changes

This problem occurs only if the AV Server Oracle Home is patched with the latest CPU patches.

Cause

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