My Oracle Support Banner

DBMS_AUDIT_MGMT: Unable to initialize cleanup (Doc ID 1558585.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Initializing the cleanup for DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB_STD is failing although it is not explicitly initialized:

 

 

SQL> begin
  2      IF sys.DBMS_AUDIT_MGMT.is_cleanup_initialized (
  3        audit_trail_type => sys.DBMS_AUDIT_MGMT.audit_trail_db_std ) THEN
  4          dbms_output.put_line('is initialized');
  5      ELSE
  6          dbms_output.put_line('is not initialized');
  7      END IF;
  8  end;
  9  /
is not initialized

PL/SQL procedure successfully completed.

SQL> begin
  2      sys.DBMS_AUDIT_MGMT.init_cleanup (
  3        audit_trail_type => sys.DBMS_AUDIT_MGMT.audit_trail_db_std
  4        ,default_cleanup_interval => 1 );
  5  end;
  6  /
begin
*
ERROR at line 1:
ORA-46265: Subset of audit trail is already initialized
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 61
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 780
ORA-06512: at line 2


SQL> begin
  2      sys.DBMS_AUDIT_MGMT.deinit_cleanup (
  3        audit_trail_type => sys.DBMS_AUDIT_MGMT.audit_trail_db_std );
  4  end;
  5  /
begin
*
ERROR at line 1:
ORA-46272: Subset of audit trail is already deinitialized
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 61
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1161
ORA-06512: at line 2

 

 

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.