Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-09925: Unable to create audit trail file

861979May 15 2011 — edited May 16 2011
Hi,

Actually I am creating a db manually, after creating my pfile, When I enter "sqlplus / as sysdba" in Linux Env. to startup on nomount, I came cross the below error. What could be the reason behind this error.

Below are the snapshots.

SQL*Plus: Release 11.2.0.2.0 Production
Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on


Enter user-name:


MY BASH PROFILE:


db_name='dbname'
memory_target=2000M
processes = 150
audit_file_dest='/u01/app/oracle/admin/dbname/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE...


ALERT LOG:
Could not open audit file: /u01/app/oracle/product/11.2.0.2/dbs/u01/app/oracle/admin/orcl/adump/dbname_ora_20097_1.aud
Retry Iteration No: 1 OS Error: 2
Retry Iteration No: 2 OS Error: 2
Retry Iteration No: 3 OS Error: 2
Retry Iteration No: 4 OS Error: 2
Retry Iteration No: 5 OS Error: 2
OS Audit file could not be created; failing after 5 retries

What could be the reason behind this error. Could you suggest me solution on this...

Thanks,
858976
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2011
Added on May 15 2011
13 comments
11,994 views