在使用duplicate…from active database模式给一套RAC搭建备库，修改备库参数文件后，启动到nomount的时候遇到了ORA-09925: Unable to create audit trail file错误。

[oracle@SL010M6-DB-ERPSTD dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 11 01:29:19 2015

Copyright (c) 1982, 2013, 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

告警日志显示如下报错:

Tue Aug 11 01:29:24 2015
OS Audit file could not be created; failing after 6 retries
OS Audit file could not be created; failing after 6 retries

之前也遇到过这个错误，是由于ORACLE_HOME/bin目录下的oracle文件的权限不对导致的，可是经查看，这个文件权限是对的。

[oracle@SL010M6-DB-ERPSTD bin]$ cd $ORACLE_HOME/bin
[oracle@SL010M6-DB-ERPSTD bin]$ ll oracle
-rwsr-s--x 1 oracle oinstall 239626731 8月   7 00:17 oracle

导致这个错误的原因要么是dump目录不存在，要么是没有写权限，要么就是oracle文件权限不对，既然权限对，那么就是dump目录的问题了，bdump、cdump、udump在启动数据库的时候，如果不存在，会自动创建，adump则不会，很有可能是adump的问题，查看参数文件，adump信息如下：

*.audit_file_dest='/u01/app/oracle/admin/erpdb/adump'

经查看，在/u01/app/oracle/admin目录下面，没有erpdb这个目录，创建后问题解决。

oracle@SL010M6-DB-ERPSTD oracle]$ mkdir -p /u01/app/oracle/admin/erpdb/adump
[oracle@SL010M6-DB-ERPSTD oracle]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 11 02:04:25 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 3.7413E+10 bytes
Fixed Size                  2261048 bytes
Variable Size            5368713160 bytes
Database Buffers         3.1944E+10 bytes
Redo Buffers               98385920 bytes

本文固定链接: http://www.dbdream.com.cn/2015/08/%e5%8f%88%e9%81%87ora-09925-unable-to-create-audit-trail-file/ | 信春哥，系统稳，闭眼上线不回滚！