ORA-09817: Write to audit file failed Linux-x86_64 Error: 28: No space left on device
来源:互联网 发布:云计算 大数据 物联网 编辑:程序博客网 时间:2024/05/22 04:24
连接数据库报错[oracle@tips ~]$ 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通过使用 -prelim方式也无法进行连接[oracle@tips ~]$ 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经查询造成的原因是audit所在的文件系统满了,没有多余的空间ORACLE_HOME disk (filesystem) became full leavingno 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% /hometmpfs 8218332 0 8218332 0% /dev/shm[oracle@tips ~]$ 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