My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.