ORA-09817: Write to audit file failed. - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 27

Thread: ORA-09817: Write to audit file failed.

  1. #11
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by budh
    ... ON the web, I have only found articles regarding permissions and space...
    Perhaps this is because the issue is just related to permissions and space... but you should keep your mind open to other possibilities like alien abduction -as Gandolf has pointed out in other cases
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  2. #12
    Join Date
    Nov 2001
    Posts
    335
    As I told you, trace file can not be created due to the either lack of space or permissions. It only gets created when you connect as a sysdba. Check your bdump and udump directoties settings and locations.

    background_dump_dest
    user_dump_dest
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  3. #13
    Join Date
    Apr 2008
    Posts
    22
    hi,

    any suggestions?

  4. #14
    Join Date
    Nov 2001
    Posts
    335
    Did you do what was suggested already?
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  5. #15
    Join Date
    Apr 2008
    Posts
    22
    yes.. everything.. still same problem..

  6. #16
    Join Date
    Apr 2008
    Posts
    22
    The OS User currently being used to do the exports are in the local administrators group. The user I have logged onto the box with is also a member of domain admins and has been added to the local admin group. There is 40GB of free space on the drive.

  7. #17
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    No underlying OS errors? (error codes, error msgs). can you check a few trace files?
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  8. #18
    Join Date
    Apr 2008
    Posts
    22
    nope.. nothing.. That's the problem.. I don't know where to look... I have checked all the common places, event viewer, logs etc etc. but nothing...

  9. #19
    Join Date
    Nov 2001
    Posts
    335
    Can you connect to the database as a sysdba using sqlplus ?
    What are the values of these parameters :

    background_dump_dest
    user_dump_dest
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  10. #20
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    BV1963... you are a Saint!
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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