EXACC ORA-46264 SYS"."AUDIT_TRAIL_UNIFIED_PJ Error In Executing Audit Cleanup Job (Doc ID 2472340.1)

Last updated on FEBRUARY 15, 2022

Applies to:

Symptoms

ISSUE CLARIFICATION
===================

 Exadata Cloud Machine Server Name (2 db nodes)

Everytime the cleanup job runs. reports:

KZAM_CAT: Audit Trail Cleanup error = 46366 on instance 4

kzam_clean_atrail: ORA-46264

*** 2018-10-16T10:30:13.136586-03:00 (CDB$ROOT(1))
ORA-12012: error on auto execute of job "SYS"."AUDIT_TRAIL_UNIFIED_PJ"
ORA-46264: Error during DBMS_AUDIT_MGMT operation
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 5355
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 264
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 5340
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1358
ORA-06512: at line 1
~

SQL> select count(*) from unified_audit_trail;
select count(*) from unified_audit_trail
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server PPA7, instance
Cloud01.oraclecloudatcustomer.com:TESTC014 (4)
ORA-46366: File
'/u02/app/oracle/audit/TESTC014/XXXXXXXXXXXXXXXXXXXXXXX/.ora_audit_0436.bin' is not a recognized Oracle audit file.

Cause

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