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% /bootmy 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.