ORA-09925: Unable to create audit trail file

Today I got a strange error while connecting to SQL plus using

sqlplus "/as sysdba"

The error was
ORA-09925: Unable to create audit trail file
Linux Error: 13: Permission denied
Additional information: 9925
ORA-01075: you are currently logged on

I exited and tried connecting again to sql plus but never seen this again.

What can be the cause of the error.
systemsautomationAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
tomcatkevConnect With a Mentor Commented:
show parameter audit

look at where your AUDIT_FILE_DEST= is pointing.  Verify that the directory exists and Oracle owner has write permission.

A common standard location is $ORACLE_BASE/admin/$ORACLE_SID/adump
0
 
k_murli_krishnaCommented:
I would guess that you've got the AUDIT_TRAIL parameter set to OS, and the AUDIT_FILE_DEST parameter set to a diretory that doesn't exist on your new server.

You could find the same issue handeled in Metalink Note: 1018924.102
Have you got enought disk space to write the audit files?

Check u have proper OS permission on AUDIT_FILE_DEST dir
also check the location of audit trail file under audit_file_dest in pfile.
It may be also since u don't have proper permission of Oracle Home.

First see:
http://ora-09925.ora-code.com/

Now check out:
ORA-09925: Unable to create audit trail file
http://www.experts-exchange.com/Databases/Oracle/Q_21961763.html
http://forums.oracle.com/forums/thread.jspa?threadID=384361
http://pangwords.spaces.live.com/Blog/cns!17F01800524B6479!340.entry?sa=158311994
http://arjudba.blogspot.com/2008/08/ora-09925-unable-to-create-audit-trail.html
http://laurentschneider.com/wordpress/2007/12/how-to-resolve-ora-09925.html
0
All Courses

From novice to tech pro — start learning today.