ORA-07445: exception encountered: core dump [kgghtNumElements

最新推荐文章于 2022-03-25 20:13:16 发布

转载最新推荐文章于 2022-03-25 20:13:16 发布 · 198 阅读

针对Oracle 11.2.0.1.0在Linux AS5.3 64位环境下出现的ORA-07445异常及核心转储问题进行详细记录与分析。该问题涉及到RAC集群、ASM和两个节点配置。

Oracle 11.2.0.1.0  ， Linux AS 5.3  64 bit . RAC , ASM  , 2 节点

昨天开始，一直报错，  在metalink 貌似还查询不到。

ORA-07445: exception encountered: core dump [kgghtNumElements()+4] [SIGSEGV] [ADDR:0x2AD70DCE8A20] [PC:0x6AE22B2] [Address not mapped to object] []
Fri Jun 10 13:47:41 2011
Sweep [inc][256613]: completed
Fri Jun 10 13:52:23 2011
Restarting dead background process RSMN
Fri Jun 10 13:52:23 2011
RSMN started with pid=63, OS id=12552
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2AD70DCE8A20] [PC:0x6AE22B2, kgghtNumElements()+4] [flags: 0x0, count: 1]
Errors in file /u01/product/oracle/diag/rdbms/ccptdb/ccptdb1/trace/ccptdb1_rsmn_12552.trc  (incident=264204):
ORA-07445: exception encountered: core dump [kgghtNumElements()+4] [SIGSEGV] [ADDR:0x2AD70DCE8A20] [PC:0x6AE22B2] [Address not mapped to object] []

trace file 內容如下：

Trace file /u01/product/oracle/diag/rdbms/ccptdb/ccptdb1/trace/ccptdb1_rsmn_12552.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing option
ORACLE_HOME = /u01/product/oracle/11.2.0/db_1
System name: Linux
Node name:    xxrac01
Release:       2.6.18-128.el5
Version:       #1 SMP Wed Dec 17 11:41:38 EST 2008
Machine:       x86_64
Instance name: ccptdb1
Redo thread mounted by this instance: 1
Oracle process number: 63
Unix process pid: 12552, image: [email=oracle@xxrac01]oracle@xxrac01[/email] (RSMN)

*** 2011-06-10 13:52:23.482
*** SESSION ID

1513.12457) 2011-06-10 13:52:23.482
*** CLIENT ID

) 2011-06-10 13:52:23.482
*** SERVICE NAME

SYS$BACKGROUND) 2011-06-10 13:52:23.482
*** MODULE NAME

) 2011-06-10 13:52:23.482
*** ACTION NAME

) 2011-06-10 13:52:23.482
KSXPCINI: kjxgnpub KSXP 9.1.0RSMN 10, 0
*** 2011-06-10 13:52:26.585
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2AD70DCE8A20] [PC:0x6AE22B2, kgghtNumElements()+4] [flags: 0x0, count: 1]
DDE: Problem Key 'ORA 7445 [kgghtNumElements()+4]' was flood controlled (0x4) (incident: 264204)
ORA-07445: exception encountered: core dump [kgghtNumElements()+4] [SIGSEGV] [ADDR:0x2AD70DCE8A20] [PC:0x6AE22B2] [Address not mapped to object] []
ssexhd: crashing the process...
Background_Core_Dump = PARTIAL

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-697624/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-697624/