Ora-09817:write to audit file failed linux-x86_64 Error:28:no space left on device

Connection Database Error [[email protected] ~]$ sqlplus  /  as sysdbasql*plus:  Release 11.2.0.3.0 production on fri jun 29 18:44:03 2012copyright   (c)  1982, 2011, oracle.  all rights reserved. Error:ora-09817: write to audit file failed. Linux-x86_64 error: 28: no space left on deviceadditional information:  12ora-01075: you are currently logged on cannot be connected by using  -prelim mode [[email  protected] ~]$ sqlplus -prelim / as sysdbasql*plus: release 11.2.0.3.0  Production on Fri Jun 29 18:51:45 2012Copyright  (c)  1982,  2011, oracle.  all rights reserved. Error:ora-09817: write to audit file failed. Linux-x86_64 error: 28: no space left on deviceadditional information: 12ora-09817: write to audit file  Failed. Linux-x86_64 error: 28: no space left on deviceadditional information:  12 is caused by a query because the filesystem audit is full, there is no extra space oracle_home disk  (filesystem)  became full  leavingno space for writing audit records to oracle_home/rdbms/audit [ [email protected] ~]# df -k filesystem            1K-blocks      Used Available Use%  mounted on/dev/sda1              304718484  32931328         0 100% //dev/sda2                101105       5725&Nbsp;    90159   6% /home cleaning up the file system space where Oracle is located, the problem is resolved [[email protected ] ~]$ df -k filesystem            1k-blocks      used available use% mounted on/dev/sda1              304718484  209605104    33213321  90% //dev/sda2                101105      5725      90159   6% /hometmpfs                   8218332         0    8218332   0% /dev/shm[[email protected] ~]$ sqlplus   / as   sysdbasql*plus: release 11.2.0.3.0 production on fri jun 29 18:54:16  2012Copyright  (c)  1982, 2011, oracle.  all rights reserved. connected to:oracle database 11g enterprise edition release 11.2.0.3.0  - 64bit productionwith the partitioning, olap, data mining and  real application testing options

This article is from the "O Record" blog, so be sure to keep this source http://evils798.blog.51cto.com/8983296/1420892