Google it ....

Monday, July 14, 2014

ORA-09817: Write to audit file failed

In my alert log file appear this error
ERROR:
ORA-09817: Write to audit file failed.
Linux-x86_64 Error: 28: No space left on device
Additional information: 12
ORA-09945: Unable to initialize the audit trail file
Linux-x86_64 Error: 28: No space left on device

Its because there is not left space on mount point where my audit files are generated.
check it :
df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_node1230231-lv_root
                       34G   33G   0G   100% /
tmpfs                 4.0G  1.9G  2.2G  46% /dev/shm
/dev/sda1             485M   55M  405M  12% /boot

my audit destination is /u01/app/oracle/admin/orcl/adump, which you can find with parameter audit_file_dest.

solution:
1) You can add some space on your mount point.
2) Delete some audit files from /u01/app/oracle/admin/orcl/adump.

i don't need that audit files, so i deleted it
cd /u01/app/oracle/admin/orcl/adump
rm *

after that everything goes fine.

5 comments:

  1. it works thanks for this posting

    ReplyDelete
  2. hello,

    I have this error while server is booting, so i cant get the server up again in order to free space, what shall i do ?

    Thx in advance!

    ReplyDelete
  3. Hello,

    you can boot server in safe mode or emergency mode or something like that, depends on your operating system.

    ReplyDelete
  4. worked.thanks for your valuable time, which saved ours.

    ReplyDelete