ORA-09925: Unable to create audit trail file

jiawang

报错现象：[oracle@node1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu May 4 15:26:01 2023
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925

当发生上面错误的时候，有以下三种可能：

• 磁盘空间已满，导致无法创建审核文件，使用df -h查询磁盘空间；
• 磁盘inodes已经占用完了，导致无法打开新的文件，使用df -i查看inode使用情况；
• 路径权限不足，无法创建审核文件，查看路径权限情况ls -l。
  

但是三种可能都会有不同差异的报错：
磁盘空间不足或inodes用完：Linux-x86_64 Error： 28： No space left on device
权限不足：Linux-x86_64 Error: 30: Read-only file system  或者 Linux Error: 13: Permission denied
根据上面报错情况，是由于权限不足，经过检查，是因为/U01路径的权限是root:root，修改为Oracle：oinstall之后正常
　　当inode占用完是，需要删除对应路径下面的一些文件，如下inode已使用100%。

[grid@node1]$ df -i /u01/app/grid/product/11.2.0/grid/rdbms/audit
Filesystem Inodes   IUsed    IFree IUse% Mounted on
/dev/xvdaz 13107200 13107200 0     100%  /u01       <<<<<<<<----------- Here, IUse% is 100
　　此时删除该路径下面一些不用的文件就可以。



MOS上的一段描述及解决：
Problem Description -------------------   
Problem occurs when:   $ORACLE_HOME/rdbms/audit directory is full or   $ORACLE_HOME/rdbms/audit directory doesn't exist   as a side effect of this problem oracle asks for password  after connect internal

Solution Description  --------------------   
Make space available in $ORACLE_HOME/rdbms/audit by removing files that are  not needed     or    Make sure the directory exists and is readable by oracle    or    Change init.ora audit_file_dest to an existing directory.   Change init.ora parameter means restart instance as workaround kill pmon.                                                

Explanation  -----------   
The behavior on Unix is to write a file named ora_<process_id>.aud into   the directory specified by audit_file_dest.    The default directory is /rdbms/audit.    The file will contain an entry for the audited action, which would be internal  logins or startup. On ports which support an OS audit trail, these records will be   written there.   This feature is not affected by the settings of the audit_trail parameter.                                                      

ORA-09925: "Unable to create audit trail file"                                
  Cause: ORACLE was not able to create the file being used to hold   audit trail records.                                                   

Action: Check the UNIX error number for a possible operating system error.              
If there is no error, contact ORACLE customer support.                  

References  ----------
[NOTE:1018924.102] ORA-09925 ON DATABASE STARTUP  [NOTE:1056988.6]   ORA-09925 DURING HOT BACKUPS  [NOTE:21073.1]   
OERR:  ORA-9925   "Unable to create audit trail  [BUG:723955]       SQLPLUS ALLOWS DB STARTUP (BUT NOT SHUTDOWN)                    
IF AUDIT_FILE_DEST DOESN'T EXIST   
Search Words  ------------   ORA-09925 audit trail audit_file_dest