ORA-09817: Write To Audit File Failed
2 min readORACLE_HOME disk (filesystem) became full and caused an ASM error... Got the following errors in the alert log file:
ORA-01148: Message 1148 not found; No message file for product=RDBMS, facility=ORA; arguments: [71]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments:
[71] [+DG1/asrblg/datafile/tts000061.dbf]
ORA-09817: Write to audit file failed.
Solaris-AMD64 Error: 28: No space left on device
Tue Nov 18 01:50:31 2008
Automatic datafile offline due to media error on
file 71: +DG1/asrblg/datafile/tts000061.dbf
ORACLE_HOME disk (filesystem) became full leaving no space for writing audit records to $ORACLE_HOME/rdbms/audit. 10g and higher in particular generate a lot of informational trace files for various internal operations, and if these can not be written due to a full disk, you can see this type of problem. The only way to avoid this is making sure that there is enough free space in $ORACLE_HOME. You could change the location for bdump and udump to another path.
Check the file system space for ORACLE_HOME using df -h command It must be 100% full and it is not allowing oracle to create audit files. Try to find out some unwanted file from the file system and remove those. Remove .aud, .trc, trm files from the file system
cd /u01/app/oracle/admin/orcl/adump
find . -name *aud -print|more
./rdbms/audit/ora_1786.aud
./rdbms/audit/ora_2398.aud
To delete .trc, .trm , .aud Files:
--Check for list of files you want to delete keeping 3 days files.
[oracle@primary trace]$ find /u01/app/oracle/diag/rdbms/orcl/orcl/trace -name '*.trm' -mtime +3 -exec ls -ltrh} \;
--Check the count of number of files.
[oracle@primary trace]$
[oracle@primary trace]$ ls -ltrh |wc -l
4944
--Delete the files.
[oracle@primary trace]$ find /u01/app/oracle/diag/rdbms/orcl/orcl/trace -name '*.trm' -mtime +1 -exec rm {} \;
-- You can find files got deletes as Count decreases.
[oracle@primary trace]$ ls -ltrh |wc -l
2889
[oracle@primary trace]$ ls -ltrh *trm
-rw-r-----. 1 oracle oinstall 1.2K Nov 14 21:21 orcl_m001_29940.trm
-rw-r-----. 1 oracle oinstall 1.1K Nov 14 21:23 orcl_m005_31046.trm
-rw-r-----. 1 oracle oinstall 884 Nov 14 21:30 orcl_m000_1777.trm
Hope it helped !! 🙂
