ORA-09925: Unable to create audit trail file

Issues with Database login (ORA-09925)

ERROR:

ORA-09925: Unable to create audit trail file

SVR4 Error: 49: Disc quota exceeded

Additional information: 9925

ORA-01075: you are currently logged on

This error occurs when the filesystem is filled up and oracle is not able to allocate any space to connect to the database. To troubleshoot, we need to check the mountpoint and cleanup the log files or any old dump files. 

cd to Oracle base Directory and run

cd $ORACLE_BASE

du -sh * 

see which folder is consuming the most of the space and then remove the old log and dump files. 

df -h . 

cd <folder>

rm <filename>

df -h .  

will show the space utilization and once you cleanup the files, try to connect to the database again and it should be working.

If this is helpful or you need any additional help on diagnosing this error, leave a comment and I would be happy to get back.

Thanks for your time.