ORA-06512: At "SYS.DBMS_AUDIT_MGMT"

刘泽宇

SYMPTOMS

Customer has already applied a fix for Bug 21385422 but still the below procedure errors:

begin
dbms_audit_mgmt.set_last_archive_timestamp(audit_trail_type =>
dbms_audit_mgmt.audit_trail_unified,last_archive_time => sysdate-100);
dbms_audit_mgmt.clean_audit_trail(audit_trail_type =>
dbms_audit_mgmt.audit_trail_unified, use_last_arch_timestamp => FALSE);
end;
/
begin
*
ERROR at line 1:
ORA-46264: Error during DBMS_AUDIT_MGMT operation
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 5244
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1296
ORA-06512: at line 3

The procedure execution cleans/purges the audit records but at end it errors out with above error message

CAUSE

Bug 27264464 - HIT: ORA-00054 WHILE CLEANUP THE UNIFIED AUDIT TRAIL
The same issue as that of bug 7264464 for 12.1.2.x is tracked in Bug 26634831
Bug 26634831 - ORA-54 DURING CLEANUP OF UNIFIED AUDIT TRAIL WITH LAT=>FALSE
In Bug 26634831, it was suggested to apply patch for bug#25985768 to resolve the error ORA-06512.
Bug 25985768 has been replaced by new bug 28186466