How to Investigate and Solve the Errors (ORA-46258, ORA-46263) Related to Audit Trail Cleanup Init/Deinit Operations (Doc ID 1355142.1)

Last updated on NOVEMBER 02, 2015

Applies to:

Oracle Audit Vault - Version 10.2.3.2 and later
Information in this document applies to any platform.
Checked for relevance on 08-MAR-2013

Symptoms

This note is dedicated to the situations when attempting to initialize or deinitialize the audit trail cleanup (ATC) options, these are failing with these errors:
ORA-46263: The audit trail is already initialized for cleanup
for initialize operations and
ORA-46258: Cleanup not initialized for the audit trail
for deinitialize operations.
These problems tend to appear mostly when trying to initialize or deinitialize all the ATC options, using:

Init:
begin
  dbms_audit_mgmt.init_cleanup (
  audit_trail_type => dbms_audit_mgmt.audit_trail_all,
  default_cleanup_interval => 1);
end;
/
Deinit:
begin
  dbms_audit_mgmt.deinit_cleanup (
  audit_trail_type => dbms_audit_mgmt.audit_trail_all);
end;
/

Changes

These errors would appear mostly after ATC has been running for a while and changes have been performed. As a general rule, the changes are not actually known.

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