AIX上Oracle RAC 11g r2不断产生core文件
Problem Summary
---------------------------------------------------
Oracle core dumps on AIX
Problem Description
---------------------------------------------------
AIX上安装的Oracle RAC 11g r2，
用# errpt -a查看，每隔一分钟就会产生一个core文件，请问如何解决？
/oracle/product/11.2.0/db_1/dbs/core_15204532/core
PROGRAM NAME
oracle
STACK EXECUTION DISABLED
0
COME FROM ADDRESS REGISTER
fflush_un 7E8
PROCESSOR ID
hw_fru_id: N/A
hw_cpu_id: N/A
ADDITIONAL INFORMATION
pthread_k B0
??
Symptom Data
REPORTABLE
1
INTERNAL ERROR
0
SYMPTOM CODE
PCSS/SPI2 FLDS/oracle SIG/6 FLDS/pthread_k VALU/b0
|
|
Hi,
为了进一步分析，请提供下面的信息： 1. alert log （两个节点） 2. 在生产core file的节点执行： cd /oracle/product/11.2.0/db_1/dbs/core_15204532/core file core dbx /oracle/product/11.2.0/db_1/bin/oracle core dbx> where |
|
|
|
您好！
两个alert log文件见附件。 root@db01:/$ cd /oracle/product/11.2.0/db_1/dbs/core_14090316/ root@db01:/oracle/product/11.2.0/db_1/dbs/core_14090316$ file core core: AIX core file fulldump 64-bit, oracle root@db01:/oracle/product/11.2.0/db_1/dbs/core_14090316$ dbx /oracle/product/11.2.0/db_1/bin/oracle core Type 'help' for help. [using memory image in core] reading symbolic information ... IOT/Abort trap in pthread_kill at 0x9000000004efa30 ($t1) 0x9000000004efa30 (pthread_kill+0xb0) e8410028 ld r2,0x28(r1) (dbx) where pthread_kill(??, ??) at 0x9000000004efa30 _p_raise(??) at 0x9000000004ef2a8 raise.raise(??) at 0x90000000002c2ac abort() at 0x90000000007d084 skgdbgcra(??) at 0x1008c45f0 sksdbgcra(??, ??) at 0x1028b0de0 ksdbgcra() at 0x1028b07b0 ssexhd(??, ??, ??) at 0x10299d028 .() at 0x0 dbgerEvaluateRules(??, ??, ??) at 0x1006d1610 dbgerEvaluateRules(??, ??, ??) at 0x1006d1610 dbgexPhaseII(??, ??, ??) at 0x1002c30b4 dbgexExplicitEndInc(??, ??) at 0x1002c429c dbgeEndDDEInvocationImpl(??, ??) at 0x10015ec20 dbgeEndDDEInvocation(??) at 0x10015e930 ssexhd(??, ??, ??) at 0x10299cf3c .() at 0x0 dbgerEvaluateRules(??, ??, ??) at 0x1006d1610 dbgerEvaluateRules(??, ??, ??) at 0x1006d1610 dbgexPhaseII(??, ??, ??) at 0x1002c30b4 dbgexExplicitEndInc(??, ??) at 0x1002c429c dbgeEndDDEInvocationImpl(??, ??) at 0x10015ec20 dbgeEndDDEInvocation(??) at 0x10015e930 ssexhd(??, ??, ??) at 0x10299cf3c ksmpclrpga() at 0x101e2d620 opidcl(??, ??) at 0x107179464 opidrv(??, ??, ??) at 0x107178d40 sou2o(??, ??, ??, ??) at 0x10716e8c8 opimai_real(??, ??) at 0x10000089c ssthrdmain(??, ??) at 0x1000ee84c main(??, ??) at 0x10000064c (dbx) |
|
|
|
您好，
请问是否在EM database 或者 grid console中设置了TNSError listener metric ？ 如果设置了，请关闭可以解决这个问题。 |
|
http://space.itpub.net/23135684/viewspace-733801
11.2.0.3 AIX RAC下$ORACLE_HOME/dbs生成大量core_* dump文件
上一篇 / 下一篇 2012-06-26 12:03:32 / 个人分类：Oracle RAC
| Core Files Generated Under $ORACLE_HOME/dbs Directory [ID 1327258.1] | |||||
| 修改时间 02-JUN-2011 类型 PROBLEM 状态 MODERATED | |||||
In this Document
Symptoms
Cause
Solution
References
| 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:
Bug 10397815 FREQUENT CORE DUMP GENERATED - SKGDBGCRA, KSDBGCRA, KSMLSGE_PHASEONE
Bug 10389708 MANY CORE_* DIRECTORIES CREATED UNDER THE GRID HOME'S DBS DIRECTORY
both bugs have been closed as duplicate of
Bug 9930490 MULTIPLE ISSUES IDENTIFIED WITH LISTENER METRIC TNSERRORS
where development explain that this can occur if TnsError listener metric is enabled from EM
Solution
1. 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
BUG:10397815 - FREQUENT CORE DUMP GENERATED - SKGDBGCRA, KSDBGCRA, KSMLSGE_PHASEONE
BUG:10389708 - MANY CORE_* DIRECTORIES CREATED UNDER THE GRID HOME'S DBS DIRECTORY
BUG:9930490 - MULTIPLE ISSUES IDENTIFIED WITH LISTENER METRIC TNSERRORS
