暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

ORA-7445 ksfd_odmwat()

老杨 2019-03-25
731

问题描述

Oracle 9206 RAC环境访问LOGMINER视图时报错。
错误信息:

Wed Aug 10 17:06:37 2011
Errors IN file /opt/app/oracle/admin/orcl/udump/orcl2_ora_20704.trc:
ORA-07445: exception encountered: core dump [000000010069AB88] [SIGSEGV] [Address NOT mapped TO object] [0x000000008] [] []
Wed Aug 10 17:07:22 2011
Trace dumping IS performing id=[cdmp_20110810170722]


专家解答

对应的TRACE信息为:

*** 2011-08-10 17:06:37.463
*** SESSION ID:(49.28760) 2011-08-10 17:06:37.461
Exception signal: 11 (SIGSEGV), code: 1 (Address NOT mapped TO object), addr: 0x8, PC: [0x10069ab88, 000000010069AB88]
*** 2011-08-10 17:06:37.463
ksedmp: internal OR fatal error
ORA-07445: exception encountered: core dump [000000010069AB88] [SIGSEGV] [Address NOT mapped TO object] [0x000000008] [] []
CURRENT SQL statement FOR this SESSION:
SELECT COUNT(*) FROM v$logmnr_contents
----- Call Stack Trace -----
calling              CALL     entry                argument VALUES IN hex      
location             TYPE     point                (? means dubious VALUE)     
-------------------- -------- -------------------- ----------------------------
ksedmp()+328         CALL     ksedst()             00000000B ? 000000000 ?
                                                   000000000 ? 00000004A ?
                                                   FFFFFFFF7FFF0658 ?
                                                   1032E18E8 ?
ssexhd()+676         CALL     ksedmp()             000103705 ? 103705000 ?
                                                   103705468 ? 10370A000 ?
                                                   000102C00 ? 000000000 ?
sigacthandler()+44   PTR_CALL 0000000000000000     00010370D ?
                                                   FFFFFFFF7FFF76F0 ?
                                                   10370D000 ? 10370A620 ?
                                                   000000000 ? 10370D578 ?
ksfd_odmwat()+968    PTR_CALL 0000000000000000     00000000B ?
                                                   FFFFFFFF7FFF76F0 ?
                                                   FFFFFFFF7FFF7410 ?
                                                   000004400 ? 000103400 ?
                                                   00000000E ?
ksfdwtio()+812       CALL     ksfd_odmwat()        FFFFFFFF7B7E63A8 ?
                                                   000000000 ? 1037077D4 ?
                                                   000000000 ? 000000000 ?
                                                   0FFFFFFFB ?
ksfdwat1()+64        CALL     ksfdwtio()           38000A800 ? 1037077D4 ?
                                                   380011054 ? 000000000 ?
                                                   0FFFFFFFB ? 01CBA91A7 ?
ksfdrwat0()+212      CALL     ksfdwat1()           0FFFFFFFB ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   10370A000 ? 00000FC00 ?
kcrfais()+752        CALL     ksfdwat()            38000A000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   00000001B ? 10370AA10 ?
kcrfdr()+292         CALL     kcrfais()            FFFFFFFF7B7E1478 ?
                                                   FFFFFFFF7B7E1400 ?
                                                   FFFFFFFF7B7E1210 ?
                                                   000000800 ? 000002002 ?
                                                   FFFFFFFF7FFF9D7C ?
kcrfrgv()+452        CALL     kcrfdr()             FFFFFFFF7B7E10F0 ?
                                                   FFFFFFFF7B7E1168 ?
                                                   000000040 ? 000103400 ?
                                                   00010370B ? 000000002 ?
krvxrgr_GetRedo()+1  CALL     kcrfrgv()            FFFFFFFF7B7E10F0 ?
04                                                 0000002D0 ? 0000002D0 ?
                                                   000000080 ? 000000000 ?
                                                   00000FC00 ?
krvxror_ReadOneReco  CALL     krvxrgr_GetRedo()    FFFFFFFF7B7E6818 ?
rd()+1284                                          FFFFFFFF7B7E10F0 ?
                                                   FFFFFFFF7FFFB018 ?
                                                   FFFFFFFF7B7E10E0 ?
                                                   1033E7E98 ? 1033E7E88 ?
krvxread()+432       CALL     krvxror_ReadOneReco  FFFFFFFF7B7E10E0 ?
                              rd()                 FFFFFFFF7B7E3118 ?
                                                   FFFFFFFF7B7E2F90 ?
                                                   000000007 ?
                                                   FFFFFFFF7FFFB910 ?
                                                   000000000 ?
krvxgtsp_GetTxnSing  CALL     krvxread()           FFFFFFFF7B7E6818 ?
leProcess()+28                                     000000000 ? 000000000 ?
                                                   0990FD824 ? 000000000 ?
                                                   FFFFFFFF7B7E2F90 ?
krvxgt()+604         CALL     krvxgtsp_GetTxnSing  FFFFFFFF7B7E6818 ?
                              leProcess()          000000000 ? 103708000 ?
                                                   FFFFFFFFFFFFFFFF ?
                                                   000000000 ? 000000000 ?
krvfcact()+1940      CALL     krvxgt()             FFFFFFFF7B7E6818 ?
                                                   000000001 ?
                                                   FFFFFFFF7FFFB2D4 ?
                                                   FFFFFFFF7FFFB2B8 ?
                                                   FFFFFFFF7FFFB2C0 ?
                                                   0000000CA ?
qerfxFetch()+1056    PTR_CALL 0000000000000000     FFFFFFFF7B7E6818 ?
                                                   000001000 ?
                                                   FFFFFFFF7B7E7768 ?
                                                   FFFFFFFF7B7E0068 ?
                                                   47CABB0D8 ?
                                                   FFFFFFFF7B7E2F90 ?
qergsFetch()+2268    PTR_CALL 0000000000000000     4C9EB4768 ? 102E54FC8 ?
                                                   000000000 ? 102DDC520 ?
                                                   102E53830 ? 000007FFF ?
opifch2()+1724       PTR_CALL 0000000000000000     000101800 ?
                                                   FFFFFFFF7B7E74E0 ?
                                                   000000000 ? 000000001 ?
                                                   100FD5400 ? 4C9EB46D0 ?
opiall0()+3860       CALL     opifch2()            101001000 ? 102E55AD8 ?
                                                   100FD5400 ? 0000000C9 ?
                                                   FFFFFFFF7FFFB910 ?
                                                   FFFFFFFF7FFFBF3C ?
kpoal8()+1040        CALL     opiall0()            000000000 ? 00000005E ?
                                                   FFFFFFFF7FFFC1C8 ?
                                                   103705808 ?
                                                   FFFFFFFF7B7E7B48 ?
                                                   FFFFFFFF7FFFC558 ?
opiodr()+1688        PTR_CALL 0000000000000000     000000000 ? 000000001 ?
                                                   FFFFFFFF7FFFEA10 ?
                                                   000000024 ? 000000000 ?
                                                   0000022B0 ?
ttcpip()+1556        PTR_CALL 0000000000000000     000103400 ? 100FBBFC0 ?
                                                   10370D808 ? 103705808 ?
                                                   103707D40 ?
                                                   FFFFFFFF7FFFCBB0 ?
opitsk()+984         CALL     ttcpip()             10370D800 ? 000000014 ?
                                                   FFFFFFFF7FFFEA10 ?
                                                   000000000 ? 000000000 ?
                                                   FFFFFFFF7FFFDCFC ?
opiino()+1572        CALL     opitsk()             000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   103707D28 ?
                                                   FFFFFFFF7FFFEB64 ?
opiodr()+1688        PTR_CALL 0000000000000000     000380007 ? 10370C658 ?
                                                   1037F9458 ?
                                                   FFFFFFFF7FFFF8A0 ?
                                                   000000000 ? 47DED9E20 ?
opidrv()+736         CALL     opiodr()             000103400 ? 10100C380 ?
                                                   10370D808 ? 103705808 ?
                                                   103707D40 ?
                                                   FFFFFFFF7FFFF3C0 ?
sou2o()+16           CALL     opidrv()             000000000 ? 000000004 ?
                                                   1037051EC ? 00000003C ?
                                                   1037056C8 ? 000103400 ?
main()+184           CALL     sou2o()              FFFFFFFF7FFFF8C0 ?
                                                   00000003C ? 000000004 ?
                                                   FFFFFFFF7FFFF8A0 ?
                                                   000039E70 ? 000000000 ?
_start()+380         CALL     main()               000000002 ?
                                                   FFFFFFFF7FFFFA08 ?
                                                   FFFFFFFF7FFFFA20 ?
                                                   000000000 ? 000000000 ?
                                                   100000000 ?
--------------------- Binary Stack Dump ---------------------

当前的数据库采用ODM:VERITAS 4.1.20.00 ODM Library, Version 1.1,而在发生错误时等待的是ODM的IO操作。这个错误在MOS甚至是GOOGLE上都找不到,不过可以很容易的判断出,问题发生在Oracle与Veritas之间的配合有关。
发生错误的语句是SELECT COUNT(*) FROM V$LOGMNR_CONTENTS,但是观察会话的历史执行需要,之前已经做过对V$LOGMNR_CONTENTS的全表访问,并未引发异常:

Cursor Dump:
----------------------------------------
Cursor 1 (ffffffff7ca60490): CURROW  curiob: ffffffff7ca69068
 curflg: 4e curpar: 0 curusr: 0 curses 47e8b7800
 cursor name: SELECT * FROM v$logmnr_contents
 child pin: 48f2da230, child LOCK: 490123c90, parent LOCK: 490123da0
 xscflg: 80100074, parent handle: 4a8d79a90, xscfl2: 4200409
  nxt: 15.0x00000008  nxt: 14.0x00000158  nxt: 13.0x00000fa8  nxt: 12.0x00000fa8
  nxt: 11.0x00000158  nxt: 10.0x00000fa8  nxt: 9.0x00000180  nxt: 8.0x00000fa8
  nxt: 7.0x00000fa8  nxt: 6.0x00000158  nxt: 5.0x00000fa8  nxt: 4.0x00000420
  nxt: 3.0x000007c8  nxt: 2.0x000007c8  nxt: 1.0x000007c8
Cursor frame allocation dump:
frm: -------- Comment --------  Size  Seg Off 
 bhp SIZE: 160/600
 whp SIZE: 11066784/11067768
Dump OF CURRENT WORK HEAP:
******************************************************
.
.
.
******************************************************
----------------------------------------
Cursor 2 (ffffffff7ca604e0): CURBOUND  curiob: ffffffff7b7e8130
 curflg: 4e curpar: 0 curusr: 0 curses 47e8b7800
 cursor name: SELECT DISTINCT operation FROM v$logmnr_contents
 child pin: 0, child LOCK: 48f491d08, parent LOCK: 48f492368
 xscflg: 100024, parent handle: 4aa79cb50, xscfl2: 4200409
 bhp SIZE: 160/600
----------------------------------------
Cursor 3 (ffffffff7ca60530): CURFETCH  curiob: ffffffff7b7e7b48
 curflg: 4e curpar: 0 curusr: 0 curses 47e8b7800
 cursor name: SELECT COUNT(*) FROM v$logmnr_contents
 child pin: 48f2db030, child LOCK: 490125618, parent LOCK: 490125c78
 xscflg: 80100074, parent handle: 4c9ec3038, xscfl2: 4200409
  nxt: 4.0x00000008  nxt: 3.0x00000060  nxt: 2.0x000004c0  nxt: 1.0x000007c8
Cursor frame allocation dump:
frm: -------- Comment --------  Size  Seg Off 
 bhp SIZE: 160/600
 whp SIZE: 11046016/11046720
Dump OF CURRENT WORK HEAP:
******************************************************

显然这个错误的发生是偶然的,目前并没有导致或解决这个问题的明确方式,不过考虑只是偶尔影响v$logmnr_contents的访问,可以忽略掉这个错误。

最后修改时间:2019-04-14 10:54:52
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论