asked on

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.

ASKER CERTIFIED SOLUTION

tomcatkev

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

k_murli_krishna

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
https://www.experts-exchange.com/questions/21961763/ORA-09925-Unable-to-create-audit-trail-file.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