ORA-09817 Write to audit file failed错误处理
报错如下：
[oracle@rhel5 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon May 16 14:39:36 2016
Copyright (c) 1982, 2009, 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
处理：
[oracle@rhel5 arch]$ oerr ora 9817
09817, 00000, "Write to audit file failed."
// *Cause: ORACLE was unable to write an entry to the file used as the
// audit trail.
// *Action: Check the UNIX error number for a possible operating system error.
// If there is no error, contact Oracle Support Services.
提示oracle无法进行写操作，由于数据库原来正常运行，中间插入了数据，并且创建了数据文件，可能是空间不足导致
使用df -h命令查看系统空间占用情况，发现/u01文件系统空间已用完
解决方法：1、为/u01文件系统增加空间
2、清除oracle数据库归档
[oracle@rhel5 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon May 16 14:39:36 2016
Copyright (c) 1982, 2009, 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
处理：
[oracle@rhel5 arch]$ oerr ora 9817
09817, 00000, "Write to audit file failed."
// *Cause: ORACLE was unable to write an entry to the file used as the
// audit trail.
// *Action: Check the UNIX error number for a possible operating system error.
// If there is no error, contact Oracle Support Services.
提示oracle无法进行写操作，由于数据库原来正常运行，中间插入了数据，并且创建了数据文件，可能是空间不足导致
使用df -h命令查看系统空间占用情况，发现/u01文件系统空间已用完
解决方法：1、为/u01文件系统增加空间
2、清除oracle数据库归档
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30373263/viewspace-2100786/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
