Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2454
  • Last Modified:

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
0
anup001
Asked:
anup001
3 Solutions
 
Guy Hengel [angelIII / a3]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
 
gaubasmCommented:
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
 
schwertnerCommented:
The above suggestions are good.
Check also if 'oracle' user has write privilege over the subdirectory where this file resides.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now