一个测试库好久没用了，今天登上去报ora-09817的错误。

查oracle文档是这么说的，

ORA-09817: Write to audit file failed.
Cause: ORACLE was unable to write an entry to the file used as the audit trail.
Action: Check the UNIX error number for a possible operating system error. If
there is no error, contact Oracle Support Services.

SQL> conn / as sysdba
ERROR:
ORA-09817: Write to audit file failed.
HPUX-ia64 Error: 28: No space left on devic
ORA-01075: you are currently logged on

安装oracle的目录/home果然是满了
$ bdf
Filesystem kbytes used avail %used Mounted on
/dev/vg00/lvol3 5144576 1222816 3891144 24% /
/dev/vg00/lvol1 1835008 127504 1694272 7% /stand
/dev/vg00/lvol8 12288000 2839664 9378784 23% /var
/dev/vg00/lvol7 15368192 5894504 9399744 39% /usr
/dev/vg00/lvol4 10256384 2157328 8036816 21% /tmp
/dev/vg01/lvoradata
102400000 99232147 2969897 97% /oradata
/dev/vg00/lvol6 20480000 8659984 11727768 42% /opt
/dev/vg00/lvol5 20480000 20480000 0 100% /home
$

$ ll
total 11982992
-rw-r--r-- 1 oracle dba 0 Mar 4 2010 dmp
-rw-r--r-- 1 oracle dba 3 Dec 30 18:10 #未命名的#
drwxrwxr-x 3 oracle dba 96 Aug 1 2008 app
-rw-r--r-- 1 oracle dba 2521833472 Mar 3 16:21 backup.dmp
drwxr-xr-x 4 oracle dba 96 Jun 7 2010 u_bk
-rw-r--r-- 1 oracle dba 0 Mar 3 16:22 31.dmp
-rw-r--r-- 1 oracle dba 0 Mar 3 16:24 p531.dmp
-rw-r--r-- 1 oracle dba 646 May 16 2010 516.log
-rw-r--r-- 1 oracle dba 18793 Aug 29 2010 830.log
-rw-r--r-- 1 oracle dba 105251 Dec 9 01:53 test11.log
-rw------- 1 oracle dba 126795 Dec 9 01:53 nohup.out
-rw-r--r-- 1 oracle dba 672 Dec 9 01:13 patch.log
drwxr-xr-x 3 oracle dba 96 Aug 31 2010 private
-rw-r--r-- 1 oracle dba 195 Dec 30 14:48 spcpkg.lis
-rw-r--r-- 1 oracle dba 2458 Dec 30 14:48 spctab.lis
-rw-r--r-- 1 oracle dba 3410 Dec 30 14:48 spcusr.lis
-rw-r--r-- 1 oracle dba 3612192768 Dec 30 11:15 warehouse.dmp

删掉不再用的.dmp文件

$ rm *.dmp

SQL> conn / as sysdba
Connected.
SQL>
OK啦