首页 > 代码库 > ORA-09817: Write to audit file failed Linux-x86_64 Error: 28: No space left on device
ORA-09817: Write to audit file failed Linux-x86_64 Error: 28: No space left on device
连接数据库报错 [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
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。