What is the cause and solution for Oracle error :
ORA-09817: Write to audit file failed.
Linux-x86_64 Error: 28: No space left on device
Additional information: 12
ORA-09945: Unable to initialize the audit trail file
Linux-x86_64 Error: 28: No space left on device
Ezana Answered question 20/04/2023
Cause:
The “u01” folder on the Database as a Service (DBaaS) instance is full.
Solution:
Delete unnecessary audit and/or trace files on /u01, or any other unnecessary temporary files. After restarting the DBaaS instance, the database will now be able to write the audit in the available space.
Ezana Answered question 20/04/2023