重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-09925: Unable to create audit trail file [打印本页]

作者: jiawang    时间: 2024-5-24 14:11
标题: ORA-09925: Unable to create audit trail file
本帖最后由 jiawang 于 2024-5-24 14:11 编辑

报错现象:[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

当发生上面错误的时候,有以下三种可能:但是三种可能都会有不同差异的报错:
磁盘空间不足或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








欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2