Error of ORA-09925: Unable to create audit trail file
I was unable to startup my database. The following error message was shown instead:
ORA-09925: Unable to create audit trail file
SVR4 Error: 2: No such file or directory
Additional information: 9925
I've checked my audit_file_dest parameter and have made sure that it is pointing to a valid directory: /opt/app/admin/HYDB/adump.
I've also ensure that my $ORACLE_HOME/bin/oracle has authorization of this directory by setting it to 6755.
When i enter the command 'ls -l $ORACLE_HOME/bin/oracle', I got this
-rwsr-sr-x 1 oracle oinstall 118441880 Jul 19 16:24 /opt/app/oracle/product/10.2.0/bin/oracle
I've also checked that i have the permission to write to the directory by running 'ls -al /opt/app/admin/HYDB/adump'. It gives the following results:
drwxr-x--- 2 oracle oinstall 17920 Aug 10 17:30 .
drwxr-x--- 8 oracle oinstall 512 Aug 10 17:29 ..
-rw-r----- 1 oracle oinstall 589 Aug 10 17:30 ora_4970.aud
My listener was also started up successfully as shown below:
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
Version TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
Start Date 10-AUG-2007 16:54:19
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
Listener Parameter File /opt/app/oracle/product/10.2.0/network/admin/listener.ora
Listener Log File /opt/app/oracle/product/10.2.0/network/log/listener.log
Listening Endpoints Summary...
The listener supports no services
The command completed successfully
However, i am still unable to start up my database with the same error message coming up. Can someone please advice?
Thanks in advance!!!
You could find the same issue handeled in Metalink Note: 1018924.102
Anyone can hold the helm when the sea is calm.
Have you got enought disk space to write the audit files?
I found the problem! Thanks alot for your help!!!
I am also facing the same problem..... please let me know the solution
Have you got enough space?
Check the filesystem space
Can you share your solution to your problem???
Originally Posted by gxangel
Click Here to Expand Forum to Full Width