ORA-07445: exception encountered: core dump [kglpnp()+119] [SIGSEGV]

最新推荐文章于 2025-02-20 08:00:00 发布

转载最新推荐文章于 2025-02-20 08:00:00 发布 · 122 阅读

本文记录了一次 Oracle 数据库运行中出现的 ORA-07445 错误详情，包括错误发生的时间点、具体位置及调用堆栈等关键信息，并提供了可能的解决方案及 Metalink 文档链接。

Sun Feb 7 14:01:31 2010
ARC0: Becoming the heartbeat ARCH
Sun Feb 7 14:01:31 2010
SMON: enabling cache recovery
Sun Feb 7 14:01:31 2010
Instance recovery: looking for dead threads
Instance recovery: lock domain invalid but no dead threads
Sun Feb 7 14:01:32 2010
Successfully onlined Undo Tablespace 5.
Sun Feb 7 14:01:32 2010
SMON: enabling tx recovery
Sun Feb 7 14:01:32 2010
Database Characterset is AL32UTF8
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 24
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=30, OS id=7571
Sun Feb 7 14:01:37 2010
Completed: ALTER DATABASE OPEN

Sun Feb 7 14:46:40 2010
Thread 3 advanced to log sequence 7075 (LGWR switch)
Current log# 19 seq# 7075 mem# 0: /ocfs_ctrl_redo/mxdell/redo19.log
Current log# 19 seq# 7075 mem# 1: /ocfs_data/mxdell/redo19.log
Sun Feb 7 16:01:54 2010
Thread 3 advanced to log sequence 7076 (LGWR switch)
Current log# 20 seq# 7076 mem# 0: /ocfs_ctrl_redo/mxdell/redo20.log
Current log# 20 seq# 7076 mem# 1: /ocfs_data/mxdell/redo20.log
Sun Feb 7 17:03:48 2010
Thread 3 advanced to log sequence 7077 (LGWR switch)
Current log# 21 seq# 7077 mem# 0: /ocfs_ctrl_redo/mxdell/redo21.log
Current log# 21 seq# 7077 mem# 1: /ocfs_data/mxdell/redo21.log
Sun Feb 7 17:04:39 2010
Errors in file /u01/product/admin/mxdell/udump/mxdell3_ora_18044.trc:
ORA-07445: exception encountered: core dump [kglpnp()+119] [SIGSEGV] [Address not mapped to object] [0x000280075] [] []
Sun Feb 7 17:04:39 2010
Errors in file /u01/product/admin/mxdell/udump/mxdell3_ora_18044.trc:
ORA-07445: exception encountered: core dump [pfrtra()+134] [SIGSEGV] [Address not mapped to object] [0x00000000A] [] []
ORA-07445: exception encountered: core dump [kglpnp()+119] [SIGSEGV] [Address not mapped to object] [0x000280075] [] []
Sun Feb 7 17:05:52 2010
Errors in file /u01/product/admin/mxdell/udump/mxdell3_ora_26523.trc:
ORA-07445: exception encountered: core dump [kglpnp()+119] [SIGSEGV] [Address not mapped to object] [0x000280075] [] []
Sun Feb 7 17:05:52 2010
Errors in file /u01/product/admin/mxdell/udump/mxdell3_ora_26523.trc:
ORA-07445: exception encountered: core dump [pfrtra()+134] [SIGSEGV] [Address not mapped to object] [0x00000000A] [] []
ORA-07445: exception encountered: core dump [kglpnp()+119] [SIGSEGV] [Address not mapped to object] [0x000280075] [] []
Sun Feb 7 17:12:50 2010
Errors in file /u01/product/admin/mxdell/udump/mxdell3_ora_4669.trc:
ORA-07445: exception encountered: core dump [pfrinstr_MOVNU()+39] [SIGSEGV] [Address not mapped to object] [0x2AE6000A0000]

[] []
Sun Feb 7 17:12:51 2010
Trace dumping is performing id=[cdmp_20100207171251]
Sun Feb 7 18:03:53 2010
Thread 3 advanced to log sequence 7078 (LGWR switch)
Current log# 22 seq# 7078 mem# 0: /ocfs_ctrl_redo/mxdell/redo22.log
Current log# 22 seq# 7078 mem# 1: /ocfs_data/mxdell/redo22.log
Sun Feb 7 19:09:55 2010
Thread 3 advanced to log sequence 7079 (LGWR switch)
Current log# 23 seq# 7079 mem# 0: /ocfs_ctrl_redo/mxdell/redo23.log
Current log# 23 seq# 7079 mem# 1: /ocfs_data/mxdell/redo23.log
Sun Feb 7 20:13:54 2010
Thread 3 advanced to log sequence 7080 (LGWR switch)
Current log# 24 seq# 7080 mem# 0: /ocfs_ctrl_redo/mxdell/redo24.log
Current log# 24 seq# 7080 mem# 1: /ocfs_data/mxdell/redo24.log
Sun Feb 7 21:17:54 2010

/u01/product/admin/mxdell/udump/mxdell3_ora_26523.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /u01/product/oracle
System name:    Linux
Node name:      mxrac03
Release:        2.6.18-128.el5
Version:        #1 SMP Wed Dec 17 11:41:38 EST 2008
Machine:        x86_64
Instance name: mxdell3
Redo thread mounted by this instance: 3
Oracle process number: 77
Unix process pid: 26523, image: oracle@mxrac03

*** 2010-02-07 17:05:52.687
*** ACTION NAME:() 2010-02-07 17:05:52.687
*** MODULE NAME:(MesL10.exe) 2010-02-07 17:05:52.687
*** SERVICE NAME:(mxdell) 2010-02-07 17:05:52.687
*** SESSION ID:(2120.242) 2010-02-07 17:05:52.687
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x280075, PC: [0x3e6ef17, kglpnp()+119]
*** 2010-02-07 17:05:52.694
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kglpnp()+119] [SIGSEGV] [Address not mapped to object] [0x000280075] [] []
Current SQL statement for this session:
begin

SP_ASSY_ASSEMBLY(:V00001,:V00002,:V00003,:V00004,:V00005,:V00006,:V00007,:V00008,:V00009,:V00010,:V00011,:V00012,:V00013,:V00

014); end;
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0xa, PC: [0x463ad5c, pfrtra()+134]
*** 2010-02-07 17:05:52.698
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [pfrtra()+134] [SIGSEGV] [Address not mapped to object] [0x00000000A] [] []
ORA-07445: exception encountered: core dump [kglpnp()+119] [SIGSEGV] [Address not mapped to object] [0x000280075] [] []
ksedmp: obtaining current SQL failed earlier. not retrying
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   2B567A2F0FE0 ? 2B567A2F1040 ?
                                                   2B567A2F0F80 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   2B567A2F0FE0 ? 2B567A2F1040 ?
                                                   2B567A2F0F80 ? 000000000 ?
ssexhd()+559         call     ksedmp()             000000002 ? 000000001 ?
                                                   2B567A2F0FE0 ? 2B567A2F1040 ?
                                                   2B567A2F0F80 ? 000000000 ?
__restore_rt()+0     call     ssexhd()             00000000B ? 2B567A2F2000 ?
                                                   2B567A2F1ED0 ? 2B567A2F1040 ?
                                                   2B567A2F0F80 ? 000000000 ?
pfrtra()+134         signal   __restore_rt()       7FFF324B04F0 ? 52B8BC3C0 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 2B567A2F23B0 ?
pfrtcs()+141         call     pfrtra()             2B567A3B16C8 ? 52B8BF152 ?
                                                   000000000 ? 2B567A2F23F0 ?
                                                   000000400 ? 2B567A2F23B0 ?
peitcs()+23          call     pfrtcs()             2B567A3B16C8 ? 2B567A2F23F0 ?
                                                   000000400 ? 2B567A2F23B0 ?
                                                   000000400 ? 2B567A2F23B0 ?
kkxtcs()+260         call     peitcs()             2B567A3B16C8 ? 2B567A3B16C8 ?
                                                   2B567A2F23F0 ? 000000400 ?
                                                   2B567A2F23B0 ? 2B567A2F23B0 ?
ksdfsql()+350        call     kkxtcs()             2B567A2F23F0 ? 7FFF324B06C8 ?

------------------------------------------------------------------------------------------------------------------------

Metalink :

ORA-7445 (kglpnp) [ID 310198.1]

--------------------------------------------------------------------------------

修改时间 10-AUG-2005 类型 REFERENCE 状态 PUBLISHED

Note: For additional ORA-7445 related information please read Note:211909.1

PURPOSE:

This article provides information on one or more bugs that are
known to result in the given ORA-7445 error.

SUGGESTIONS:

If the Known Issues section below does not help in terms of identifying
a solution, please submit the trace files and alert.log to Oracle
Support Services for further analysis.

Known Issues:

Bug# 3545539   See Note:3545539.8
      Dump under kgmexec->kglpnp using trusted callouts / domain indexes / Oracle Text
      Fixed: 9.2.0.6, 10.1.0.3, 10.2.0.1