Search This Blog

Monday, September 12, 2011

ORA-09817: Write to audit file failed. Linux Error: 28: No space left on device

Today while try to logging with our development box got below error message
-bash-3.00$ sqlplus /nolog

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Sep 12 15:19:38 2011

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

SQL> conn / as sysdba
ERROR:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
ORA-01075: you are currently logged on


SQL> --reason as mentioned above "Linux Error : 28 : No Space left on device"...

SQL> --solution: make some free space on file system.
SQL> exit
-bash-3.00$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                      145G  138G     0 100% /
/dev/sda1              99M   13M   82M  14% /boot
none                 1010M     0 1010M   0% /dev/shm

1 comment:

Anonymous said...

Being completely newbie, I'm able to see where all my space is used, but the next comment about freeing some space up leaves me puzzled. Could someone elaborate how one might do that?

[oracle@rucktec ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 108G 102G 144K 100% /
/dev/sda1 122M 34M 83M 29% /boot
tmpfs 1013M 0 1013M 0% /dev/shm