How can I stop .aud files from generating.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: How can I stop .aud files from generating.

  1. #1
    Join Date
    Jun 2006
    Location
    Ithaca, NY
    Posts
    4

    How can I stop .aud files from generating.

    We're running 10.2.0.2 RAC on Solaris 2.9 using GRID control.

    I have a question about .aud audit files the instances are generating. Since our GRID CONTROL connects constantly we generate multiple .aud files in both the $ORACLE_HOME/rdbms/audit and the $ORACLE_BASE/admin/SID/adump directories.

    We've put a script in place to clean these files out daily but is there a way to turn this feature off? Our system is generating thousands of these files a day!

    I tried setting the parameter "audit_sys_operations" to FALSE and it didn't stop the system from generating these files. I even tried setting the "audit_file_dest" to /dev/null on a test RAC system (which I knew it wouldn't like ) and as suspected it wouldn't let me set it to that.

    Any input would be appreciated!
    Last edited by Eztarget; 06-30-2006 at 11:26 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    do you have auditing turned on, is gc connecting as sysdba to the database?

  3. #3
    Join Date
    Jun 2006
    Location
    Ithaca, NY
    Posts
    4
    I'm pretty sure it's connecting as sysdba, which is why all the .aud files are being generataed I would think, unless CRS is doing it?

    I thought turning audit_sys_operations was turning off auditing?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    connections to sysdba are always logged, the operations arent unless you have that turned on

  5. #5
    Join Date
    Jun 2006
    Location
    Ithaca, NY
    Posts
    4
    Quote Originally Posted by davey23uk
    connections to sysdba are always logged, the operations arent unless you have that turned on
    So then there's no way to stop sysdba from being logged then. I guess I'll talk to the GRID guy who set that up. With the amount of times grid connects it's ridiculous.

  6. #6
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Have your DBA's use system as your default login from 10g OEM instead of sys.
    .
    Also, stick the .aud files on your backup. You may want this information some day.
    .
    My 2 cents.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  7. #7
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Grid (10g OEM) should be using the dbsnmp and NOT sys for metric collection.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  8. #8
    Join Date
    Jun 2006
    Location
    Ithaca, NY
    Posts
    4
    Quote Originally Posted by KenEwald
    Grid (10g OEM) should be using the dbsnmp and NOT sys for metric collection.
    I just dug a little deeper and found a custom script that connects every minute as sysdba about 10 times for EVERY database we have on each box. I talked to the other DBA that wrote it and he's going to change it to system instead.

    Thanks for the answers guys, I still wish there was a way to turn this off.

  9. #9
    Join Date
    Jul 2011
    Posts
    1
    how do i stop .aud files getting generated even for the sys login.

  10. #10
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    you can't ...

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

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