I got ” ORA-09925: Unable to create audit trail file ” error in Oracle.
ORA-09925: Unable to create audit trail file
Details of error are as follows.
ORA-09925: Unable to create audit trail file Cause: ORACLE was not able to create the file being used to hold audit trail records. Action: Check the UNIX error number for a possible operating system error. If there is no error, contact ORACLE customer support.
Unable to create audit trail file
This ORA-09925 errors are related with the audit_file_dest directory and its permission. audit_file_dest directory permission should be 755.
Or it is caused by an out-of-space audit_file_dest directory.
Check if $ORACLE_BASE/admin/$ORACLE_SID/adump directory exists or not and this directory is writable. If ORACLE_BASE is not set, then the default audit directory is $ORACLE_HOME/rdbms/audit.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )