ORACLE_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
