ERROR: 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.

2 thoughts on “ERROR: ORA-09817: Write to audit file failed.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s