ORA-09925: Unable to create audit trail file

$ sqlplus / as sysdba
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 28: No space left on device
Additional information: 9925
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 28: No space left on device
Additional information: 9925

   
$ cd /u01/app/oracle/product/11.2.0.4/dbhome_1/rdbms
$ ls -l
total 1039920
drwxr-xr-x 2 oracle oinstall      49152 Aug 22 10:33 admin
drwxr-xr-x 2 oracle oinstall 1063747584 Oct 20 19:20 audit
drwxr-xr-x 2 oracle oinstall       4096 Jun 27 14:47 demo
drwxr-xr-x 2 oracle oinstall       4096 Jun 27 14:47 doc
drwxr-xr-x 5 oracle oinstall       4096 Jun 27 14:48 install
drwxr-xr-x 2 oracle oinstall       4096 Jun 27 14:47 jlib
drwxr-xr-x 2 oracle oinstall       4096 Jul 31 11:45 lib
drwxr-xr-x 2 oracle oinstall       4096 Aug 22 18:30 log
drwxr-xr-x 2 oracle oinstall       4096 Jun 27 14:47 mesg
drwxr-xr-x 2 oracle oinstall       4096 Jun 27 14:47 public
drwxr-xr-x 5 oracle oinstall       4096 Jun 27 14:46 xml

So the solution seems easy. Just remove aud file under the audit directory. Then I run rm command. It runs for a few minutes and finally gave an error message below.

$ rm *.aud
-bash: /bin/rm: Argument list too long

  • September 27, 2018 | 21 views
  • Comments