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 :
rpool/VARSHARE/pkg/repositories 547G 31K 419G 1% /var/share/pkg/repositories database-pool/ORCL 1.0T 727G 297G 72% /ORCL database-pool/ORCL2 500G 409G 91G 82% /ORCL2 oracle-pool/ggate 100G 3.3G 97G 4% /oracle database-pool/dump 500G 499G 0G 100% /dump
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.