APPLIES TO: Oracle Database - Enterprise
Edition - Version 9.2.0.8 and later Connections to the database or database startups fail with any of these errors: ORA-09925: Unable to create
audit trail file
ERROR:
ERROR:
1) The free space on the mount point used to dump the audit records is exhausted:
$ df -h
3) The number of inodes is exhausted
$ df -i 4) The oracle user does not have enough privileges to write to the audit file destination folder
1.Check if directory $ORACLE_BASE/admin/$ORACLE_SID/adump exists. If ORACLE_BASE is not set, then the default audit directory is $ORACLE_HOME/rdbms/audit. Make sure the permissions on the directory are set to 755. 2.Make sure that there is enough space on the file system to accommodate the newly created audit files. 3.If the inodes are exhausted and cleaning the unwanted files does not help, format the filesystem again with lower bytes per inode to increase the number of inodes for the filesystem. Your system adminsitrator can help you with this task. 4.On 11.2.0.3, this error may be seen when ORACLE_PATH environmentatl variable is set. As a workaround ORACLE_PATH can be unset.It can be fixed by applying Patch 14488943.
This document has been taken from Oracle Support Doc ID 1993887.1 |