Oracle中ora-09817,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数据库归档

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30373263/viewspace-2100786/，如需转载，请注明出处，否则将追究法律责任。