Large trace file generated in 12.2 version of Oracle

Large trace file generated in 12.2 version of Oracle

After upgrade the Oracle database to 12.2 i am getting large trace file in my backgroud dump destination.

Trace file of around 4 GB. On checking i did not have any trace enabled on the database.

select * from dba_enabled_traces;

no row selected

On checking trace file Error related to Rman.exe

*** 2018-12-07T20:45:48.371967-06:00
*** SESSION ID:(1164.57386) 2018-12-07T20:45:48.371967-06:00
*** CLIENT ID:() 2018-12-07T20:45:48.387595-06:00
*** SERVICE NAME:(ORCL) 2018-12-07T20:45:48.387595-06:00
*** MODULE NAME:(rman.exe) 2018-12-07T20:45:48.387595-06:00 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>RMAN
*** ACTION NAME:() 2018-12-07T20:45:48.387595-06:00
*** CLIENT DRIVER:() 2018-12-07T20:45:48.387595-06:00

2018-12-07 20:45:48.382*:KRB:krbi.c@8862:krbitrc(): Got krbitrc
2018-12-07 20:45:48.387*:KRB:krbi.c@8892:krbiwtrc(): (bkrsmain - Action is NULL)
2018-12-07 20:45:48.387*:KRB:krbi.c@8862:krbitrc(): Got krbitrc
2018-12-07 20:45:48.387*:KRB:krbi.c@9965:krbiovac(): Got krbiovac
*** ACTION NAME:(0000001 STARTED1) 2018-12-07T20:45:48.387595-06:00

2018-12-07 20:45:48.387*:KRB:krbi.c@8892:krbiwtrc(): (icdstart - Action set to 0000001 STARTED1)
2018-12-07 20:45:48.387*:KRB:krbi.c@1658:krbidvac(): Got krbidvac
2018-12-07 20:45:48.387*:KRB:krbd.c@386:krbdgalcbuf(): allocated device type: "DISK", name: ""
*** ACTION NAME:(0000001 FINISHED1) 2018-12-07T20:45:48.387595-06:00

Solution
According to Oracle, trace file is generated from RMAN.exe. To disable it use the following event.
For more information refer to Doc ID 28390273.8

ALTER SYSTEM SET EVENT='trace[krb.*] disk disable, memory disable' scope=spfile;

Note: Doc ID 28390273.8 mentions that the fix is included in 18.4.0.0.181016 (Oct 2018) Database Release Update.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.