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.
it works thanks for this posting
ReplyDeleteGracias me sirvió mucho.
ReplyDeletehello,
ReplyDeleteI 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!
Hello,
ReplyDeleteyou can boot server in safe mode or emergency mode or something like that, depends on your operating system.
worked.thanks for your valuable time, which saved ours.
ReplyDelete