DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: auditing

  1. #1
    Join Date
    Jul 2006
    Posts
    195

    auditing

    I am running Oracle 10.2.0.1.0 on AIX 5.3.

    My question is why am I getting audit files in my audit directory and how
    can I disable this functionality.

    SQL> SHOW PARAMETER AUDIT

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    audit_file_dest string /oracle/data/pri/audit
    audit_sys_operations boolean FALSE
    audit_syslog_level string
    audit_trail string FALSE


    ls -tl /oracle/data/pri/audit
    total 24
    -rw-rw---- 1 oracle dba 567 Jul 01 10:17 ora_618544.aud
    -rw-rw---- 1 oracle dba 574 Jul 01 10:17 ora_450632.aud
    -rw-rw---- 1 oracle dba 569 Jul 01 10:17 ora_618542.aud


    Thanks in advance to all that answer the post

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Ora10gR2 generates some auditing by default including: Database startup, Database shutdown and SYSDBA connections
    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.

  3. #3
    Join Date
    Jul 2006
    Posts
    195
    I take it there is no way to disable this or is it fixed in Oracle 11?

    Lastly, to remove the files would it be okay to use a find command and remove them from disk or is there an oracle command that I need to run that will remove them from both oracle tables/views and the disk?

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by BeefStu View Post
    ... is it fixed in Oracle 11?
    Please check documentation, this is not a bug.

    Quote Originally Posted by BeefStu View Post
    Lastly, to remove the files would it be okay to use a find command and remove them from disk or is there an oracle command that I need to run that will remove them from both oracle tables/views and the disk?
    Unix commands would do.
    Last edited by PAVB; 07-01-2010 at 11:40 AM. Reason: typo
    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