ORA-09817: Write to audit file failed Linux-x86_64 Error: 28: No space left on device
浏览数：486 /
时间：2015年06月20日
连接数据库报错 [oracle@tips ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 29 18:44:03 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. ERROR: ORA-09817: Write to audit file failed. Linux-x86_64 Error: 28: No space left on device Additional information: 12 ORA-01075: you are currently logged on 通过使用 -prelim方式也无法进行连接 [oracle@tips ~]$ sqlplus -prelim / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 29 18:51:45 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. ERROR: ORA-09817: Write to audit file failed. Linux-x86_64 Error: 28: No space left on device Additional information: 12 ORA-09817: Write to audit file failed. Linux-x86_64 Error: 28: No space left on device Additional information: 12 经查询造成的原因是audit所在的文件系统满了，没有多余的空间 ORACLE_HOME disk (filesystem) became full leaving no space for writing audit records to oracle_home/rdbms/audit [root@tips ~]# df -k Filesystem 1K-blocks Used Available Use% Mounted on /dev/sda1 304718484 32931328 0 100% / /dev/sda2 101105 5725 90159 6% /home 清理oracle所在的文件系统空间后，问题解决 [oracle@tips ~]$ df -k Filesystem 1K-blocks Used Available Use% Mounted on /dev/sda1 304718484 209605104 33213321 90% / /dev/sda2 101105 5725 90159 6% /home tmpfs 8218332 0 8218332 0% /dev/shm [oracle@tips ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 29 18:54:16 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
本文出自 “O Record” 博客，请务必保留此出处http://evils798.blog.51cto.com/8983296/1420892
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
