Home » SQL & PL/SQL » SQL & PL/SQL » Error of ORA-09925: Unable to create audit trail file
Error of ORA-09925: Unable to create audit trail file [message #258136] Fri, 10 August 2007 06:32 Go to next message
gxangel
Messages: 2
Registered: August 2007
Junior Member
Hi,

I was unable to startup my database. The following error message was shown instead:

SQL> startup
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:

total 40
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
------------------------
Alias 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
SNMP OFF
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...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blade)(PORT=1521)))
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!!!
Re: Error of ORA-09925: Unable to create audit trail file [message #258154 is a reply to message #258136] Fri, 10 August 2007 07:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
show parameter audit

Regards
Michel
Re: Error of ORA-09925: Unable to create audit trail file [message #258505 is a reply to message #258136] Sun, 12 August 2007 20:10 Go to previous messageGo to next message
gxangel
Messages: 2
Registered: August 2007
Junior Member
I've found the problem! Thanks alot !!!
Re: Error of ORA-09925: Unable to create audit trail file [message #258550 is a reply to message #258505] Mon, 13 August 2007 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And why don't you share it with us?

Regards
Michel
Re: Error of ORA-09925: Unable to create audit trail file [message #317254 is a reply to message #258505] Wed, 30 April 2008 04:47 Go to previous messageGo to next message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
Even I am facing the same problem.... Can you please share the solution same with us?????
Re: Error of ORA-09925: Unable to create audit trail file [message #317255 is a reply to message #317254] Wed, 30 April 2008 04:54 Go to previous message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
That was a silly mistake. The directory adump was not created. Now the issue has been resolved.

Thanks.....
Previous Topic: Best (fastest) way to get the number of rows from a table?
Next Topic: spooling error
Goto Forum:
  


Current Time: Tue Dec 06 11:56:16 CST 2016

Total time taken to generate the page: 0.24258 seconds