| Oracle generating audit & trace files when auditing/tracing not specified [message #51245] |
Wed, 08 May 2002 15:49  |
Hector M. Villarreal
Messages: 8
Registered: January 2002
|
Junior Member |
|
|
I cannot turn off auditing when application users log into the database.
I am trying to determine why auditing is ocurring when it was not specified in my init.ora or anywhere else.
Anothe effect of this is it is generating hundreds of trace files (with nothing in them except a message regarding dump file size. another problem is the trace files are not going to specified dump dest. All trace files end up in $ORACLE_HOME/log directory.
Is this an Oracle bug?How do you stop this?
Appreciate help with this one.
This bug is genrating 10,000 trace files/week and hundreds of audit files.
1.) Below example of contents in all the trace files generated:
kanacon1_ora_25542.trc
** DUMP FILE SIZE IS LIMITED TO 0 BYTES *
######################################################################################
2.) Example of audit file contents:
Audit file /ora01/app/oracle/products/8.1.6/rdbms/audit/ora_24163.aud
Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
ORACLE_HOME = /ora01/app/oracle/products/8.1.6
System name: SunOS
Node name: kanadb03.ofoto.com
Release: 5.7
Version: Generic_106541-16
Machine: sun4u
Instance name: kanacon1
Redo thread mounted by this instance: 1
Oracle process number: 0
24163
Wed May 8 15:23:49 2002
ACTION : 'connect internal' OSPRIV : DBA
CLIENT USER: oracle
CLIENT TERMINAL: pts/4
Wed May 8 15:23:50 2002
ACTION : 'connect internal' OSPRIV : DBA
CLIENT USER: oracle
CLIENT TERMINAL: pts/4
######################################################################################
3.) Below are the entries in v$parameter relating to auditing:
SVRMGR> connect internal;
Connected.
SVRMGR> select name,value from v$parameter where name like '%aud%';
NAME VALUE
---------------------------------------------------------------- --------------------------------------------------------------------------------
transaction_auditing FALSE
audit_trail FALSE
audit_file_dest ?/rdbms/audit
3 rows selected.
***************************************************************************************
4.) Below is the tracing settings according to v$parameter:
SVRMGR> select name, value from v$parameter where name like '%trac%';
NAME VALUE
---------------------------------------------- --------------------------------------------------------------------------------
log_archive_trace 0
replication_dependency_tracking TRUE
sql_trace FALSE
oracle_trace_enable FALSE
oracle_trace_facility_path ?/otrace/admin/fdf
oracle_trace_collection_path ?/otrace/admin/cdf
oracle_trace_facility_name oracled
oracle_trace_collection_name
oracle_trace_collection_size 5242880
9 rows selected.
SVRMGR>
***************************************************************************************
5.) Below is my init.ora file initialization parameters relating to auditing & tracing:
sql_trace = false
transaction_auditing = false
audit_trail = false # if you want auditing
# timed_statistics = true # if you want timed statistics
max_dump_file_size = 10000 # limit trace file size to 5M each
|
|
|
|
| Re: Oracle generating audit & trace files when auditing/tracing not specified [message #51283 is a reply to message #51245] |
Sun, 12 May 2002 19:08  |
Anil
Messages: 80
Registered: September 2001
|
Member |
|
|
Hello,
I am not sure but i doubt this could be one reason. Try to modify your init.ora file. As you mentioned that paramemtre "max_dump_file_size = 10000 limit trace file size to 5M each" modify this parametre. Decrease the dump files and its size too. Make a fresh startup of the database with the fresh modifications.
Hope so it will work.
Take care,
Regards,
Anil.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
