ORA-09925: Unable to create audit trail file

今天在恢复一个库的时候遇到了ORA-09925: Unable to create audit trail file的错误。
错误信息如下：

SQL*Plus: Release 11.2.0.3.0 Production on Wed Mar 14 13:51:32 2012
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on


Enter user-name: 
ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name: 
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

 

MOS中[ID 1227964.1] 记录了这个问题：
我遇到的就是第二种情况，audit_file_dest路径不存在。创建这个目录即可。
SQL> show parameter audit_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /opt/ora11g/admin/devdb/adump
                                                

If for any reason an Oracle process cannot write to an audit file an ORA-9925 error
will be encountered. The typical reasons for this problem are:

1) The free space on the mount point used to dump the audit records is exhausted:

$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 448G 448 G 0 100% /
/dev/sda1 190M 26M 155M 15% /boot
tmpfs 3.9G 2.5G 1.4G 65% /dev/shm

2) The mount point is not available or the directory specified by the AUDIT_FILE_DEST parameter does not exist.

3) The number of inodes is exhausted
$ df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/sda3 121012224 121012224 0 100% /
/dev/sda1 50200 46 50154 1% /boot
tmpfs 1001034 803 1000231 1% /dev/shm

4) The oracle user does not have enough privileges to write to the audit file destination folder 

Due to the architectural changes introduced in 11g  the number of the audit records will be larger
when compared to the earlier versions .
If not cleaned periodically this will clutter the adump folder and can cause this problem .