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$>

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.

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

Original text of this message