Oracle ORA-09817: Write to audit file failed.

ORA-09817: Write to audit file failed

case1

oracle@mytestdb:~> sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 – Production on Wed Mar 9 10:51:01 2016

Copyright (c) 1982, 2008, Oracle. All rights reserved.

ERROR:

ORA-09817: Write to audit file failed.

Linux-x86_64 Error: 28: No space left on device

ORA-01075: you are currently logged on

Work around: 

1.) Check the free space of mount point /u01

oracle@mytestdb:/u01/app/oracle/product/11.1.0/db/dbs> df -Ph /u01/

Filesystem      Size             Used                              Avail                         Use%                          Mounted on

/dev/mapper/rootvg-u01lv1  20G  20G           0                               100%                             /u01

2.) Check the audit file location in init.ora file.

oracle@mytestdb: /u01/app/oracle/product/11.1.0/db/dbs: cat initord306b1.ora | grep adump

*.audit_file_dest=’/u01/app/oracle/product/11.1.0/oradump/ord3067b1/adump’

*.core_dump_dest=’/u01/app/oracle/product/11.1.0/oradump/ord3067b1/cdump’

3) Removed any old unwanted audit files.

4) Remove any old trace files.

5) Check the free space on /u01 mount point.

6) Now try to connect oracle database as SYS user.

7) You should be able to connect to the database.

____________________________________________________________

case2 

Sqlplus “/ as sysdba” failing with ORA-09817 error.

bash-3.00$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jun 14 14:21:09 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:

ORA-09817: Write to audit file failed.

SVR4 Error: 28: No space left on device

ORA-01075: you are currently logged on

Solution:

Check the file system space for ORACLE_HOME. It must be 100% full and it is not allowing oracle to create audit files. Try to find out some unwanted file from the file system and remove those. Make some room for new audit files.

Remove .aud, .trc, trm files from the file system

/export/home/oracle/product/10.2.0/Db_1/admin/orcl/adump

bash-3.00$ find . -name *aud -print|more

./rdbms/audit/ora_3430.aud

./rdbms/audit/ora_3459.aud

./rdbms/audit/ora_3527.aud

./rdbms/audit/ora_3578.aud

./rdbms/audit/ora_7423.aud

./rdbms/audit/ora_7556.aud

./rdbms/audit/ora_7732.aud

-- 刘轶鹤