Error of ORA-09925: Unable to create audit trail file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Error of ORA-09925: Unable to create audit trail file

  1. #1
    Join Date
    Aug 2007
    Posts
    62

    Error of ORA-09925: Unable to create audit trail file

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

  2. #2
    Join Date
    Dec 2001
    Posts
    320
    You could find the same issue handeled in Metalink Note: 1018924.102


    HTH
    Anyone can hold the helm when the sea is calm.

  3. #3
    Join Date
    Feb 2003
    Posts
    63
    Have you got enought disk space to write the audit files?

  4. #4
    Join Date
    Aug 2007
    Posts
    62
    I found the problem! Thanks alot for your help!!!

  5. #5
    Join Date
    Feb 2009
    Posts
    1
    I am also facing the same problem..... please let me know the solution

    thanx

  6. #6
    Join Date
    Feb 2003
    Posts
    63

    Have you got enough space?

    Check the filesystem space

  7. #7
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    Quote Originally Posted by gxangel View Post
    I found the problem! Thanks alot for your help!!!
    Can you share your solution to your problem???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width