Ora-09925:unable to create audit trail file Rollup

Today a brother's library ora-09925:unable to create audit trail file, then check df-h have free space, directory permissions are correct, not df-i view inodes use, Audit directory has nearly 24W files, Preliminary guess is because the audit generated too many files caused the directory is the partition of the inodes ran out, then deleted part of the audit trace file after the normal did not see inodes usage.

summed up the following: the reasons for the ORA-09925 are roughly three:--in fact, according to the error to determine whether the issue of permissions or disk space problem

Reason one: Directory permissions issue--directory permissions are changed, no permissions to the directory to write audit data

The owner of the Oracle Bin directory (actually the entire Oracle directory) was changed:--ls-al bin

Solving method

Chown-r Oracle.oinstall/opt/orace

Reason two: The disk does not have space--df-h

Reason three: Disk inodes light--df-i reference: Simulate Linux disk partition has free space available inodes times wrong: No space left on device

Example of an error:--Partial network

Example 1: Can be judged according to the error information is directory permissions problems caused not write

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 (may be a file system problem)

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

Sample 3:--No free space

##############################

A description and resolution on MOS:

Problem Description-------------------

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

Problem occurs when: $ORACLE _home/rdbms/audit directory are 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 spaces available in $ORACLE _home/rdbms/audit by removing files this are not needed or make sure the directory   exists and is readable by Oracle or change Init.ora audit_file_dest to a existing directory. Change Init.ora parameter means restart instance as workaround kill Pmon.

Explanation-----------

The behavior on Unix are 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 would contain an entry to the audited action, which would be internal logins or startup.   On ports which support a OS audit trail, these records would be written there. This feature isn't affected by the settings of the Audit_trail parameter.

ORA-09925: "Unable to create audit trail file"

Cause:oracle wasn't 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