Fix-ORA-09817: Write to audit file failed


Problem:

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 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@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

*.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.

 

 

 

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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