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

原创粉丝点击