ORA-09925: Unable to create audit trail file
861979May 15 2011 — edited May 16 2011Hi,
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