-
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
-
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.
-
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?
-
Originally Posted by BeefStu
... is it fixed in Oracle 11?
Please check documentation, this is not a bug.
Originally Posted by BeefStu
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|