oracle 产生core文件,11.2.0.3 AIX RAC下$ORACLE_HOME/dbs生成大量core_* dump文件

Core Files Generated Under $ORACLE_HOME/dbs Directory [ID 1327258.1]

修改时间 02-JUN-2011     类型 PROBLEM     状态 MODERATED

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]

Information in this document applies to any platform.

Symptoms

Core files generated under the $ORACLE_HOME/dbs directory.

The following is the call stack extracted from those core files:

skgdbgcra at 0x100650b04 ($t1) 0x100650b04 (skgdbgcra+0x224) e8410028 ld r2,0x28(r1) (dbx) where skgdbgcra(??) at 0x100650b04 sksdbgcra(??, ??) at 0x10312c6e8 ksdbgcra() at 0x10312c2ac ksfcra(??) at 0x100176e0c kgepop(??, ??, ??) at 0x10008cd74 kgesinv(??, ??, ??, ??, ??) at 0x100091a10 kgesinw(0xfffffffffffc130, 0x645f34002e70616c, 0x400000004, 0x0, 0x5, 0x0, 0xacc01ade, 0x0) at 0x100091aa4 skgmattach(??, ??, ??, ??) at 0x1000e8aac ksmlsge_phaseone(??) at 0x1006b09ac opimai_init(??, ??, ??, ??) at 0x10000075c opimai_real(??, ??) at 0x1000009f4 ssthrdmain(??, ??) at 0x100141c64 main(??, ??) at 0x100000658 (dbx) quit

Cause

This problem has been reported in 2 bugs:

FREQUENT CORE DUMP GENERATED - SKGDBGCRA, KSDBGCRA, KSMLSGE_PHASEONE

MANY CORE_* DIRECTORIES CREATED UNDER THE GRID HOME'S DBS DIRECTORY

both bugs have been closed as duplicate of

MULTIPLE ISSUES IDENTIFIED WITH LISTENER METRIC TNSERRORS

where development explain that this can occur if TnsError listener metric is enabled from EM

Solution1. Bug has been fixed in GC version 12. If possible please upgrade your grid control to 12g.

OR

2. As a workaround you can disable TnsError listener metric from EM GC Console.

References - FREQUENT CORE DUMP GENERATED - SKGDBGCRA, KSDBGCRA, KSMLSGE_PHASEONE

- MANY CORE_* DIRECTORIES CREATED UNDER THE GRID HOME'S DBS DIRECTORY

- MULTIPLE ISSUES IDENTIFIED WITH LISTENER METRIC TNSERRORS