How to solve the "oracle file system full" problem?

Question

When I try to mount an Oracle database on Linux, it causes the following errors:

SQL> conn / as sysdba
ERROR:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space left on device

The df command indicates that there is no free space and the file system is full. I want to know the size of each table space and how to free up free table space. Thank!

Answer 1

First, see which section is full:

# df -h

Oracle needs to be written to the audit file whenever someone logs in. Free up space and add a monitor to the mount point to alert you before it runs out.

I recommend NAGIOS for free monitoring of Linux (and much more).