Google it ....

Showing posts with label ORA-09817. Show all posts
Showing posts with label ORA-09817. Show all posts

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.