SQLPLUS Connect, Startup Fails with ORA-09925: Unable to create audit trail file SVR4 Error: 13

Error Description:
Sqlplus / as sysdba or database startup command fails with ORA-09925: Unable to create audit trail file.
The subsequent OS errors will be different like
Linux-ia64 Error: 28: No space left on device
Linux-x86_64 Error: 27: File too large
SVR4 Error: 13: Permission denied
Solution Description:
Check the following item in your database.
  1. Check whether your Audit directory physically exist or not
Location would be for 10gR2 and above $ORACLE_HOME/admin/<YOUR DB SID>/adump and prior release it would be $ORACLE_HOME/rdbms/audit
If you are able to connect to sqlplus / as sysdba check the parameter value for audit_file_dest to get the exact location
  1. Check the directory permissions are set to 755 unix privileges
  2. Make sure the file system which belongs to this Audit directory has enough free space to create the audit files. If there is no room for new audit files, remove old files using operating system commands.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google