We help IT Professionals succeed at work.

Oracle TRC and TRM files are taking too much space at Oracle client computer.

joe_echavarria
on
3,071 Views
1 Endorsement
Last Modified: 2018-02-02
Hi,

  For some reason a lot of  TRC & TRM oracle files are being generated in a Oracle Client computer
when the user is performing some custom utility to extract Extract documents and metadata from a 2TB Oracle database.

  The path where those files are generated when the utility is running is C:\Users\xxxxx\Oracle\oradiag_hpateladmin\diag\clients\user_xxxxx\host_2046089961_xx\trace.

  I had to move those files to another location because of running out of space with the C:\ drive.

  How can i stop the generation of those files ?  --- for now i do not need them.

  Thanks.
Example-of-trc-file.txt
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
joe_echavarriaDatabase Administrator

Author

Commented:
What option in the sqlnet.ora files enables tracing ?
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
There are several:
http://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF006

Most of them have TRACE somewhere in it.



When you say client:  Do you mean a client's database server or a client machine connecting to a database server?

If a database server, you might also check the alert log to see if something in there is telling you what is generating TRC files.
joe_echavarriaDatabase Administrator

Author

Commented:
My SQLNET.ORA files  looks like  below now.  I made the changes to the parameter TRACE_LEVEL_CLIENT to value 0

# sqlnet.ora Network Configuration File: E:\app\oracle\product\11.2.0\client\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)
[b]TRACE_LEVEL_CLIENT=0[/b]   

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Open in new window


Is a client machine connecting to a database server.   It is actually the app server of the application.   The developer is running an utility recently provided by the vendor to extract documents and metadata.

I check the alert log of the database instance..., and there is nothing there about tracing files.

After having TRACE_LEVEL_CLIENT=0   in the sqlnet.ora file no trace files are generated now.

Thanks.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
Glad to help.  Unless you need something else, don't forget to close this out.