SVR4 Error: 28: No space left on device+ORA-09925: Unable to create audit trail file

When we are trying to connect to sqlplus getting below error.


oradev@ctssd $ sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Mon May 27 05:39:58 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter user-name: /as sysdba
ERROR:
ORA-09925: Unable to create audit trail file
SVR4 Error: 28: No space left on device
Additional information: 9925
ORA-01075: you are currently logged on

Enter user-name:

Cause:
The mount point got filled and when you are trying to connect sqlplus as sysdba privileges it is throwing this message SVR4 Error: 28: No space left on device.

Solution:

oradev@ctssd df -h|grep -i u01|grep -i oracle

u01_oracle 31G 31G 0K 100% /u01/oracle

oradev@ctssd 

Remove the trace files which are older /unwanted using below command.

find . -name "*.trc" -mtime +30 -exec rm {} \;&

Sometimes huge files are generated in trace folder you can use below command to find out it.

find . -name "*.trc" -size +500000 -mtime +0 -exec ls -ltrh {} \;

above command will list files whcih are more than 200MB.

I cleaned up the un used files and now the mount point size is.

oradev@ctssd df -h | grep -i /u01/oracle
u01_oracle 31G 24G 6.8G 79% /u01/oracle
oradev@ctssd

After doing above steps i am able to connect to sqlplus with out any issues.