| Error of ORA-09925: Unable to create audit trail file [message #258136] |
Fri, 10 August 2007 06:32  |
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  |
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
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 |
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
jesuisantony
Messages: 44
Registered: July 2006
Location: Chennai |
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 |
jesuisantony
Messages: 44
Registered: July 2006
Location: Chennai |
Member |
|
|
That was a silly mistake. The directory adump was not created. Now the issue has been resolved.
Thanks.....
|
|
|
]
Members
Search
Help
Register
Login
Home
