Avatar of joe_echavarria
joe_echavarria
Flag for Dominican Republic asked on

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

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
Oracle Database

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
joe_echavarria

ASKER
What option in the sqlnet.ora files enables tracing ?
slightwv (䄆 Netminder)

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_echavarria

ASKER
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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
slightwv (䄆 Netminder)

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