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

From: Mladen Gogala <mladen_at_bogus.email.com>
Date: Fri, 15 May 2009 21:36:09 +0000 (UTC)
Message-ID: <gukn89$lom$1_at_solani.org>

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':
>>
>> ERROR:
>> 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.

-- 
http://mgogala.freehostia.com

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