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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.