ORA-09925: Unable to create audit trail file

ORA-09925: Unable to create audit trail file

SVR4 Error: 2: No such file or directory
Additional information: 9925


Solution:

Some of the reasons are below which can cause error ORA-09925:


1) Check audit trail files directories exist at appropriate location, as mentioned in PFILE.
If not existing there then create at location as mentioned in pfile as:

Mkdir –p /adump

Example:
Mkdir –p $ORACLE_BASE/admin//adump
Mkdir –p $ORACLE_BASE/admin//bdump
Mkdir –p $ORACLE_BASE/admin//cdump
Mkdir –p $ORACLE_BASE/admin//udump


2) If directories are existing there


a) Then check the appropriate permissions (read/write) and ownership given at those directories.
If permissions and ownership are not there then give using following commands in solaris and linux OS:


For permission:


Chmod


Example:
Chmod –R 755 $ORACLE_BASE/admin/


For ownership:

Chown


Example:
Chown –R oracle:oinstall $ORACLE_BASE/admin/


b) Have you enought disk space to write the audit files?


Check the disk space of the mount where these files are residing with following command in solaris and linux OS:
df –h


If space is not there then reclaim space at that mount point.


You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply