ORA-09925: Unable To Create Audit Trail File

Cause:

If for any reason an Oracle process cannot write to an audit file an ORA-9925 error will be encountered. The typical reasons for this problem are:

1. The free space on the mount point used to dump the audit records is exhausted:

   $ df -h
      Filesystem Size Used Avail Use% Mounted on
      /dev/sda3 448G 448 G 0 100% /
      /dev/sda1 190M 26M 155M 15% /boot
      tmpfs 3.9G 2.5G 1.4G 65% /dev/shm

2. The mount point is not available or the directory specified by the AUDIT_FILE_DEST parameter does not exist.
3. The number of inodes is exhausted:

   $ df -i
      Filesystem Inodes IUsed IFree IUse% Mounted on
      /dev/sda3 121012224 121012224 0 100% /
      /dev/sda1 50200 46 50154 1% /boot
      tmpfs 1001034 803 1000231 1% /dev/shm

4. The oracle user does not have enough privileges to write to the audit file destination folder Due to the architectural changes introduced in 11g the number of the audit records will be larger when compared to the earlier versions . If not cleaned periodically this will clutter the adump folder and can cause this problem .

Solution:

Clean up the audit file destination directory regularly. For that one can use the DBMS_AUDIT_MGMT package. See Note 731908.1 for details.

To solve the problem immediately get the value of the audit_file_dest parameter and remove as many files as possible from the directory.