Link to home
Create AccountLog in
Avatar of joe_echavarria
joe_echavarriaFlag 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
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of joe_echavarria

ASKER

What option in the sqlnet.ora files enables tracing ?
Avatar of slightwv (䄆 Netminder)
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.
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.
Glad to help.  Unless you need something else, don't forget to close this out.