SVR4 Error: 28: No space left on device

From: Richard <RSL101_at_gmail.com>
Date: Fri, 15 May 2009 12:57:33 -0700 (PDT)
Message-ID: <6327fde5-8052-453b-a015-79717840cc6a_at_n8g2000vbb.googlegroups.com>



/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. Received on Fri May 15 2009 - 14:57:33 CDT

Original text of this message