ORA-09925: Unabletocreateaudittrailfile Summary

Today a brother of the database reported ORA-09925: Unabletocreateaudittrailfile, at that time check df-h available space, directory permissions are also correct, not df-I view Inode

Today a brother of the library reported ORA-09925: Unable to create audit trail file, at that time check df-h available space, directory permissions are also correct, not df-I view Inode

Today, a brother library reported ORA-09925: Unable to create audit trail file, at that time query df-h available space, directory permissions are also correct, not df-I view Inodes usage, there are nearly files in the Audit directory. It is preliminarily estimated that the Inodes in the partition where the directory is located are used up due to the large number of audit generated files. After deleting some audit TRACE files, the Inodes usage is normally not checked.

Summary: ORA-09925 has the following reasons:-In fact, you can determine whether the problem of permission or disk space based on the error

Cause 1: directory permission problem-the directory permission has been changed and the audit data has no permission to be written to the directory.
The owner of the Oracle bin directory (actually the entire oracle directory) is changed: -- ls-al bin
Solution
Chown-R oracle. oinstall/opt/release E
Cause 2: the disk does not have space -- df-h
Cause 3: disk Inodes used up -- df-I reference: Simulate Linux Disk Partitions with available space No available Inodes error: No space left on device

Error example: -- some network Example 1: You can identify the cause of directory permission failure based on the error message.

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

Example 2: -- read-only file system -- no write permission (possibly due to file system problems)

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

Example 3: -- no available space

##############################
Description and Solution on 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 _ . Aud into the directory specified by audit_file_dest. the default directory is/rdbms/audit. the file will contain in an entry for the audited action, which wocould 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