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!!!