DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL failed with "OS system dependent operation:FindNextFile failed with status: 0"

(Doc ID 2399210.1)

Last updated on MAY 16, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

 DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL failed with "OS system dependent operation:FindNextFile failed with status: 0"

When executing DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL, ORA-27300 can be caused
and CLEAN_AUDIT_TRAIL is failed.

ex)
SQL> BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(dbms_audit_mgmt.AUDIT_TRAIL_XML,
TRUE); END;
2 /
BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(dbms_audit_mgmt.AUDIT_TRAIL_XML,
TRUE); END;
*
ERROR at line 1:
ORA-46260: Error during audit trail cleanup
ORA-27300: OS system dependent operation:FindNextFile failed with status: 0
ORA-27301: OS failure message: The operation completed successfully.
ORA-27302: failure occurred at: szaudgflst:6
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 3567
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1193
ORA-06512: at line 1

 

Changes

 

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