My Oracle Support Banner

Audit purge job fails with ORA-06512: at "SYS.DBMS_AUDIT_MGMT",ORA-06512: at "SYS.SET_ARCHIVE_RETENTION", (Doc ID 2438949.1)

Last updated on FEBRUARY 25, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 18.3.0.0.0 [Release 10.2 to 18]
Information in this document applies to any platform.

Symptoms

Audit purge job with in the database fails with below error

Wed Aug 8 02:33:02 2018
Errors in file /oracle/product/admin/dmlive/bdump/dmlive2_j000_26791.trc:
ORA-12012: error on auto execute of job 595644
ORA-46258: Message 46258 not found; product=RDBMS; facility=ORA
; arguments: [ORA-46258: Message 46258 not found; product=RDBMS; facility=ORA
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 41
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1711
ORA-06512: at "SYS.SET_ARCHIVE_RETENTION", line 4
ORA-06512: at line 1

Changes

There is no scheduled job to purge audit records however we can see that in the database we have procedure to advance the archivetimestamp. It is also important to note this error is not caused by the database release i.e 10.2.0.4 as in this release the patch to include DBMS_AUDIT_MGMT package to pure audit records is included.

The data can be verified with below sql queries

SQL> SELECT job_action FROM dba_scheduler_jobs WHERE job_name = 'STANDARD_AUDIT_TRAIL_PJ';

no rows selected

SQL> SELECT * from DBA_AUDIT_MGMT_CLEANUP_JOBS;

no rows selected

SQL> SELECT job_action FROM dba_scheduler_jobs WHERE job_name = 'ADVANCE_ARCHIVE_TIMESTAMP';

JOB_ACTION
--------------------------------------------------------------------------------
SET_ARCHIVE_RETENTION

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
Changes
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.