Solved

ORA-09817: Write to audit file failed.  Oracle 10g

Posted on 2008-09-30
5
2,415 Views
Last Modified: 2012-05-05
When i try to connect using sqlplus "sys/password@tns as sysdba" I am getting this error

ORA-09817: Write to audit file failed.

It was working fine till now
0
Comment
Question by:anup001
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 168 total points
ID: 22612131
ORA-09817:      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.
0
 

Assisted Solution

by:gaubasm
gaubasm earned 166 total points
ID: 22612703
Check if the filesystem is not full where the audit file is located. "df -k", if you are running Oracle on UX like platform.
0
 
LVL 48

Assisted Solution

by:schwertner
schwertner earned 166 total points
ID: 22617438
The above suggestions are good.
Check also if 'oracle' user has write privilege over the subdirectory where this file resides.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to recover a database from a user managed backup

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question