Oracle datbase is generating lot and lot of .trc and .trm files

[Mohammed Hamed]

Hello Erman,

My oracle database holding the ebs 12.1 applaction is generating lot and lot or .trc and .trm files and generating files of around 12 GB  daily. Modifications we had is the we enabled tls to our 12.1.3 application.

EX.

-rw-r----- 1 oradv4 dba      599 May 21 21:02 DV4_m002_21098.trm
-rw-r----- 1 oradv4 dba    98706 May 21 21:02 DV4_m002_21098.trc
-rw-r----- 1 oradv4 dba      654 May 21 21:02 DV4_j000_21100.trm
-rw-r----- 1 oradv4 dba  9470018 May 21 21:02 DV4_j000_21100.trc
-rw-r----- 1 oradv4 dba       70 May 21 21:03 DV4_m001_21114.trm
-rw-r----- 1 oradv4 dba   235323 May 21 21:03 DV4_m001_21114.trc
-rw-r----- 1 oradv4 dba       73 May 21 21:03 DV4_w000_20869.trm
-rw-r----- 1 oradv4 dba     6849 May 21 21:03 DV4_w000_20869.trc
-rw-r----- 1 oradv4 dba      632 May 21 21:03 DV4_j000_21118.trm
-rw-r----- 1 oradv4 dba  9374857 May 21 21:03 DV4_j000_21118.trc
-rw-r----- 1 oradv4 dba      439 May 21 21:05 DV4_ora_21009.trm
-rw-r----- 1 oradv4 dba   106118 May 21 21:05 DV4_ora_21009.trc
-rw-r----- 1 oradv4 dba     1091 May 21 21:05 DV4_ora_21152.trm
-rw-r----- 1 oradv4 dba   454401 May 21 21:05 DV4_ora_21152.trc
-rw-r----- 1 oradv4 dba      842 May 21 21:05 DV4_j000_21134.trm
-rw-r----- 1 oradv4 dba 10485867 May 21 21:05 DV4_j000_21134.trc
-rw-r----- 1 oradv4 dba      433 May 21 21:05 DV4_ora_20917.trm
-rw-r----- 1 oradv4 dba   116197 May 21 21:05 DV4_ora_20917.trc
-rw-r----- 1 oradv4 dba     1517 May 21 21:05 DV4_ora_21184.trm
-rw-r----- 1 oradv4 dba  3127202 May 21 21:05 DV4_ora_21184.trc
-rw-r----- 1 oradv4 dba      928 May 21 21:06 DV4_ora_21192.trm
-rw-r----- 1 oradv4 dba   646644 May 21 21:06 DV4_ora_21192.trc
-rw-r----- 1 oradv4 dba      676 May 21 21:06 DV4_j000_21216.trm
-rw-r----- 1 oradv4 dba  9406468 May 21 21:06 DV4_j000_21216.trc
-rw-r----- 1 oradv4 dba      631 May 21 21:07 DV4_j000_21238.trm
-rw-r----- 1 oradv4 dba  9374948 May 21 21:07 DV4_j000_21238.trc
-rw-r----- 1 oradv4 dba      412 May 21 21:08 DV4_p007_21279.trm
-rw-r----- 1 oradv4 dba    29971 May 21 21:08 DV4_p007_21279.trc
-rw-r----- 1 oradv4 dba      411 May 21 21:08 DV4_p006_21277.trm
-rw-r----- 1 oradv4 dba    29985 May 21 21:08 DV4_p006_21277.trc
-rw-r----- 1 oradv4 dba      411 May 21 21:08 DV4_p005_21275.trm
-rw-r----- 1 oradv4 dba    29984 May 21 21:08 DV4_p005_21275.trc
-rw-r----- 1 oradv4 dba      411 May 21 21:08 DV4_p004_21273.trm
-rw-r----- 1 oradv4 dba    29978 May 21 21:08 DV4_p004_21273.trc
-rw-r----- 1 oradv4 dba      411 May 21 21:08 DV4_p003_21271.trm
-rw-r----- 1 oradv4 dba    29606 May 21 21:08 DV4_p003_21271.trc
-rw-r----- 1 oradv4 dba      412 May 21 21:08 DV4_p002_21269.trm
-rw-r----- 1 oradv4 dba    29596 May 21 21:08 DV4_p002_21269.trc
-rw-r----- 1 oradv4 dba      411 May 21 21:08 DV4_p001_21267.trm
-rw-r----- 1 oradv4 dba    29611 May 21 21:08 DV4_p001_21267.trc
-rw-r----- 1 oradv4 dba      412 May 21 21:08 DV4_p000_21265.trm
-rw-r----- 1 oradv4 dba    29602 May 21 21:08 DV4_p000_21265.trc

[ErmanArslansOracleBlog]

These are database traces.
Probably you enabled some trace in EBS.
Check the relevant places for the disabling trace for that users.

Read these;
How To Trace From Form, Report, Program And Others In Oracle Applications [ID 130182.1]    
FAQ: Common Tracing Techniques within the Oracle Applications 11i/R12 [ID 296559.1]    

So, you should disable the related trace..

Also open one of the trace files, and try to understand which component is creating it. Understand whether it is a forms session trace, concurrent trace or whatever, and then take the corrective action(disabling the trace for that user )

Check this thread as well -> http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/trace-files-td894.html

[Mohammed Hamed]

Thanks for the info.

Yes tracing was enabled.