ORA-09945: Unable to initialize the audit trail file
本文将呈现的错误如题所示。
它更具体的描述如下所示:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
[ora11g@rhel5u10 log]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 9 20:48:38 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. 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 Enter user-name: [ora11g@rhel5u10 log]$ |
发生该错误的原因:
对应实例的AUDIT TRAIL所在的路径没有剩余空间。
1 2 3 4 5 6 7 8 9 |
[ora11g@rhel5u10 log]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 9.7G 6.7G 59% / /dev/sda1 289M 17M 258M 7% /boot tmpfs 500M 0 500M 0% /dev/shm /dev/sr0 4.1G 4.1G 0 100% /iso /dev/mapper/vg_oracle-lv_oracle 19G 18G 0 100% /u01 [ora11g@rhel5u10 log]$ |
解决方法:
清[……]