Re: SVR4 Error: 28: No space left on device

From: Mladen Gogala <>
Date: Fri, 15 May 2009 21:36:09 +0000 (UTC)
Message-ID: <gukn89$lom$>

On Fri, 15 May 2009 21:10:32 +0100, Tony Sequeira wrote:
> Richard wrote:

>> /u01 got 100% full, I think from user tablespaces in autoextend and
>> stuffs got built in default user tablespace in /u01. The immediate
>> problem is I as oracle admin can't even login to sqlplus to clean up.
>> This I got from sqlplus '/ as sysdba':
>> ORA-09817: Write to audit file failed. SVR4 Error: 28: No space left on
>> device ORA-01075: you are currently logged on
>> I managed to login as system, what do I do next ie, resize
>> tablespaces...etc. Your advice is greatly appreciated. Be specific if
>> you can since I am fairly new to Oracle.
>> Thank you in advance, Richard.
> Backup and remove, or compress large files on /u01.
> The listener and archive logs come to mind....
> Don't do anything with Oracle yet.

Richard, I don't know the version you're on, but if it's 10.2, you have a gazillion of *.aud files to clean up.

Received on Fri May 15 2009 - 16:36:09 CDT

Original text of this message