Unable To Create Audit File When Connecting As Sysdba Into Database (Doc ID 549651.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 12-Jan-2012***


Symptoms

When you try to connect to the database as sysdba, you get and following error message:

ERROR:
ORA-09925: Unable to create audit trail file
Linux-ia64 Error: 28: No space left on device
Additional information: 9925
ORA-01075: you are currently logged on.


You checked and found you have enough disk space on the filesystem for audit_file_dest.
You tried solutions in
<Note 69642.1> - UNIX: Checklist for Resolving Connect AS SYSDBA Issues
and yet you can not solve the problem.
When you delete the files in the audit_file_dest, the error does not occur.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms