ORA-09925: Unable to create audit trail file彙總

今天一兄弟的庫報ORA-09925: Unable to create audit trail file，當時查 df -h有可用空間，目錄的許可權也正確，未df -i檢視Inodes使用情況，審計目錄下有將近24W個檔案，初步猜測是因為審計生成檔案過多導致目錄所在分割槽的Inodes用光了，當時刪除部分審計TRACE檔案後正常未檢視 Inodes使用情況。

彙總了下：ORA-09925的原因大致有以下三種：--其實可以根據報錯判斷是許可權問題還是磁碟空間問題

原因一：目錄許可權問題--目錄許可權被改，無許可權向目錄寫審計資料
oracle bin目錄（實際是整個oracle目錄）的屬主被更改:  --ls -al bin
解決方法
chown -R oracle.oinstall /opt/orace
原因二：確實磁碟沒空間了  --df -h
原因三：磁碟Inodes用光--df -i     參考：模擬LINUX磁碟分割槽有可用空間無可用Inodes時報錯：No space left on device

報錯示例：--部分網路

示例1：可以根據報錯資訊判斷是目錄許可權問題導致不能寫入

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

示例2：--只讀檔案系統--沒有寫許可權（可能是檔案系統出問題）

ORA-09925: Unable to create audit trail file  
Linux-x86_64 Error: 30: Read-only file system  
Additional information: 9925  
ORA-01075: you are currently logged on

示例3：--沒有可用空間

##############################
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