Thursday, March 17, 2016

ORA-09817 ORA-09945 HP-UX Error: 28: No space left on device

ORA-09817 ORA-09945 HP-UX Error: 28: No space left on device 

When Starting the database, below Errors occurred
ERROR:
ORA-09817: Write to audit file failed.
HP-UX Error: 28: No space left on device
ORA-09945: Unable to initialize the audit trail file

Cause:
Running df -k found that the Mount point where Oracle is installed is full causing the Startup to throw errors

Solution:

To implement the solution, please execute the following steps::

Free some space from the Mountpoint

Files that can be deleted are tracefiles in the UDUMP / BDUMP / CDUMP

Note: its advisable to backup the files before they are dropped since they might be useful in future

No comments:

Post a Comment