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

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
anup001Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
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
 
gaubasmConnect With a Mentor Commented:
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
 
schwertnerConnect With a Mentor Commented:
The above suggestions are good.
Check also if 'oracle' user has write privilege over the subdirectory where this file resides.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.