Re: SVR4 Error: 28: No space left on device
From: Tony Sequeira <nobody_at_127.0.0.1>
Date: Fri, 15 May 2009 21:10:32 +0100
Message-ID: <4a0dcc38$0$26986$db0fefd9_at_news.zen.co.uk>
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.
Date: Fri, 15 May 2009 21:10:32 +0100
Message-ID: <4a0dcc38$0$26986$db0fefd9_at_news.zen.co.uk>
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.
-- S. Anthony Sequeira ++ The rain it raineth on the just And also on the unjust fella, But chiefly on the just, because The unjust steals the just's umbrella. -- Lord Bowen ++Received on Fri May 15 2009 - 15:10:32 CDT