Issue: When trying to login via SQLPLUS, getting ORA-09925
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
Cause of Error:
Error message indicates that either Oracle is not able to find audit directory or it is not able to write/create file there.
It could also occur due to space issue at OS level.
Solution:
Check value of AUDIT_FILE_DEST, make sure directory provided here exists on OS level.
If it is RAC, then OS directory should be present on all nodes.
The directory must be writable, in case it is not then use following command:
chown +w $AUDIT_FILE_DEST
If out of space, then consider deleting older aud files (with valid backup or as per process) or increase space for the mount point.
Note: The deletion can be made using OS commands.
For more details on deleting files check this post about deleting files.
