ORA-09817: Write to audit file failed Linux-x86_64 Error: 28: No space left.

54yg

连接数据库报错

[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


[iyunv@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