Description:–
In this article we are going to see about ORA-09817:Write to audit file failed. SVR4 Error: 28: No space left on device
Problem:-
Sqlplus “/ as sysdba” failing with ORA-09817 error.
SQL*Plus: Release 19.18.0.0.0 – Production on Wed Jun 14 14:21:09 2023
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-09817: Write to audit file failed.
SVR4 Error: 28: No space left on device
ORA-01075: you are currently logged on
Solution:
Check the file system space for ORACLE_HOME using df -h command
It must be 100% full and it is not allowing oracle to create audit files.
Try to find out some unwanted file from the file system and remove those.
Remove .aud, .trc, trm files from the file system
cd /u01/app/oracle/admin/orcl/adump
find . -name *aud -print|more
./rdbms/audit/ora_2420.aud
./rdbms/audit/ora_5458.aud
Connect with me on:-
Telegram App:https://t.me/oracledbwr
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
