PROBLEM:
Users are getting below error, while trying to connect to the database.
ERROR:
ORA-09925: Unable to create audit trail file
Linux-ia64 Error: 28: No space left on device
Additional information: 9925
ORA-01075: you are currently logged on
SOLUTION:
The error occurs , because the mount point where audit logs are written is filled.
check the mount point :
[oracle@ram ~]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 20G 9.6G 8.7G 53% / tmpfs 3.0G 276K 3.0G 1% /dev/shm /dev/sda1 194M 105M 79M 58% /boot /dev/sda5 45G 40G 3.4G 93% /u01 .host:/ 293G 203G 91G 70% /mnt/hgfs [oracle@ram ~]$
We can see that mount point is filled, so database is not able to write audit logs in adump location.
To fix this, clear space from that mount point And make sure free space is available for the audit logs.
Once space is available, user can connect easily.
Catch Me On:- Hariprasath Rajaram Telegram:https://t.me/joinchat/I_f4DkeGfZuxgMIoJSpQZg LinkedIn:https://www.linkedin.com/in/hariprasathdba Facebook:https://www.facebook.com/HariPrasathdba FB Group:https://www.facebook.com/groups/894402327369506/ FB Page: https://www.facebook.com/dbahariprasath/? Twitter: https://twitter.com/hariprasathdba