ODA Oracle Database Appliance Can Have Excessive ASM Trace File Generation KgfmReadOak Bug 19605498

Asset ID:	1-72-2314638.1
Update Date:	2018-04-17
Keywords:

Solution Type Problem Resolution Sure

Solution 2314638.1 : ODA Oracle Database Appliance Can Have Excessive ASM Trace File Generation KgfmReadOak Bug 19605498

Applies to:

Oracle Database Appliance - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance Software - Version 2.1.0.1 to 12.1.2.12 [Release 2.1 to 12.1]
Information in this document applies to any platform.

Symptoms

Using the Oracle Database Appliance (ODA)

Excessive ASM trace file generation including thousands of files being generated each hour.
This can show in forms of higher than expected CPU as well as rapid storage growth which can also result in out of space / storage if left unattended ( by removing the files)

cd /u01/app/grid/diag/asm/+asm/<SID>/trace/

e.g. for the ODA one of the two directories

/u01/app/grid/diag/asm/+asm/+ASM1/trace
/u01/app/grid/diag/asm/+asm/+ASM2/trace

Inspection of the files will reveal that they include constant references to kgfmReadOak which is reading in OAK configuration information into memory structures
These excessive foreground traces generated during OAK configuration reads can be confirmed using the following query:

egrep -l kgfmReadOak *.trc|wc -l

Cause

Bug 19605498 - NUMEROUS TRACE FILES FROM ASM

which was closed as a duplicate of

Bug 19485609 - EXCESS ASM TRACING ON ODA

Bug 24908321 - HUGE TRACE FILES IN ASM BY KGFMREADOAK
24908321.8 - Huge trace files in ASM on ODA due to kgfmReadOak

Solution

Fixed is first included in

18.1.0
12.2.0.1.170718 (Jul 2017)    Database Release Update (DB RU)
12.2.0.1.170814 (Aug 2017) Database Release Update Revision(DB RUR)
12.2.0.1.170620 (June 2017) Database Proactive Bundle Patch
12.1.0.2.170718 (Jul 2017)    Database Patch Set Update (DB PSU)
12.1.0.2.170718 (Jul 2017)    Database Proactive Bundle Patch

Otherwise apply the one off for 25948842 or upgrade the database to a version with the fix.

The following Patches are available for applying on several Linux OS versions.

27687692 - (O) - 93 - PSE FOR BASE BUG 24908321 ON TOP OF DATABASE PSU 11.2.0.4.170718 FOR LINUX X86-6
25233107 - (O) - 93 - PSE FOR BASE BUG 24908321 ON TOP OF DATABASE PSU 12.1.0.2.160119 FOR LINUX X86-6
25243650 - (O) - 93 - PSE FOR BASE BUG 24908321 ON TOP OF DATABASE PSU 12.1.0.2.160719 FOR LINUX X86-6
25886117 - (O) - 93 - PSE FOR BASE BUG 24908321 ON TOP OF DATABASE PSU 12.1.0.2.170418 FOR LINUX X86-6
25890885 - (O) - 93 - PSE FOR BASE BUG 24908321 ON TOP OF DATABASE BP 12.1.0.2.170418 FOR LINUX X86-64
26908964 - (O) - 93 - PSE FOR BASE BUG 24908321 ON TOP OF DATABASE PSU 12.1.0.2.3 FOR LINUX X86-64

Workaround:
Delete the trace files as needed until such time as the patch or upgrade takes place

References

<BUG:20299023> - DATABASE PATCH SET UPDATE 12.1.0.2.3
<BUG:25948842> - PSE FOR BASE BUG 19605498 ON TOP OF DATABASE PSU 12.1.0.2.161018 FOR LINUX X86-6
<BUG:19605498> - NUMEROUS TRACE FILES FROM ASM
<BUG:19485609> - EXCESS ASM TRACING ON ODA
<BUG:24908321> - HUGE TRACE FILES IN ASM BY KGFMREADOAK

Attachments

This solution has no attachment