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

joe_echavarria
joe_echavarria used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
Check the client machines sqlnet.ora files to see if they have enabled tracing.
joe_echavarriaDatabase Administrator

Author

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

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.
Most Valuable Expert 2012
Distinguished Expert 2018

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial