Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article we will talk about ORA-09817: Write To Audit File Failed error.
When I wanted to work in my test database, I got an error as follows.
1 2 3 4 5 6 | 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 |
1 2 3 4 5 6 | 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 |
The solution is as follows;
1 | /u01/oracle/app/oracle/admin/orcl/adump |
When we clean the audit files in it, our problem will be fixed.
1 2 | cd /u01/oracle/app/oracle/admin/orcl/adump rm * |
