Fix-ORA-09817: Write to audit file failed


oracle@borvik:~> . oraenv

ORACLE_SID = [ord3067b1] ?
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.1.0/db is /u01/app/oracle
oracle@borvik:~> sqlplus / as sysdba

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

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

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@borvik:/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@borvik: /u01/app/oracle/product/11.1.0/db/dbs: cat initord306b1.ora | grep adump


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.





Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s