Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Files in adump directory

sandeep_dbaJun 2 2009 — edited Jun 2 2009
Hi,

In my database i am not enabled auditing, but files are generating in the adump directory.
Here is the output of show parameter audit
SQL> show parameter audit

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /home/oracle/admin/orcl/adump
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string NONE

files in adump contains information of users who are logged in as sysdba to database.
Here i am posting content inside of files in adump directory

Audit file /home/oracle/admin/orcl/adump/ora_31292.aud
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /home/oracle/product/10.2.0/Db_1
System name: Linux
Node name: testserver.xxxxx.com
Release: 2.6.9-42.ELsmp
Version: #1 SMP Wed Jul 12 23:32:02 EDT 2006
Machine: x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 173
Unix process pid: 31292, image: oracle@testserver.xxxxx.com (TNS V1-V3)

Tue Jun 2 14:37:21 2009
ACTION : 'CONNECT'
DATABASE USER: '/'
PRIVILEGE : SYSDBA
CLIENT USER: oracle
CLIENT TERMINAL: pts/5
STATUS: 0


How to disable these files generation? is there any specific reason for these files generation?

Thanks,
Sandeep
This post has been answered by Paul M. on Jun 2 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2009
Added on Jun 2 2009
2 comments
3,767 views