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

ORA-00600: [kghstack_underflow_internal_2]

老杨 2019-03-26
1766

问题描述

数据库10.2.0.3 for Linux 32环境出现ORA-600(kghstack_underflow_internal_2)错误。
详细错误信息为:

Tue Aug 7 08:36:43 2012
Errors IN file /ora/app/oracle/admin/ORC/udump/orcl_ora_29455.trc:
ORA-00600: internal error code, arguments: [kghstack_underflow_internal_2], [0xB72101E8], [], [], [], [], [], []
ORA-01013: USER requested cancel OF CURRENT operation
ORA-01013: USER requested cancel OF CURRENT operation


专家解答

显然导致错误的原因和ORA-1013用户取消操作有直接的关系,不过查询MOS并没有看到类似的记载,而大部分和kghstack_underflow_internal_2有关的错误都与RMAN有关。
进一步检查详细TRACE文件:

*** SERVICE NAME:(SYS$USERS) 2012-08-07 08:36:43.439
*** SESSION ID:(324.19) 2012-08-07 08:36:43.439
*** 2012-08-07 08:36:43.439
ksedmp: internal OR fatal error
ORA-00600: internal error code, arguments: [kghstack_underflow_internal_2], [0xB72101E8], [], [], [], [], [], []
ORA-01013: USER requested cancel OF CURRENT operation
ORA-01013: USER requested cancel OF CURRENT operation
CURRENT SQL statement FOR this SESSION:
BEGIN  
dbms_aw_exp.import_chunk100(1492, 'QAECAAAAAACAW0ACAAAAAACAW0ACAAAAAACAW0ACAAAAAACAW0ACAAAAAACAW0AC
AAAAAACAW0ACAAAAAABAXUACAAAAAABAXUACAAAAAABAXUACAAAAAABAXUACAAAA
AABAXUABAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAA
gFtAAgAAAAAAgFtAAgAAAAAAYF1AAgAAAAAAYF1AAgAAAAAAYF1AAgAAAAAAYF1A
AgAAAAAAYF1AAQIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBbQAIA
AAAAAIBbQAIAAAAAAIBbQAIAAAAAACBdQAYRAAAAAgAAAAAAgFtAAgAAAAAAgFtA
AgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAYF1AAgAA
AAAAYF1AAgAAAAAAYF1AAgAAAAAAYF1AAgAAAAAAYF1AAQIAAAAAAEBaQAIAAAAA
AEBaQAYKAAAAAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtAAgAA
AAAAgFtAAgAAAAAAgFtAAgAAAAAAgF1AAgAAAAAAgF1AAgAAAAAAgF1AAgAAAAAA
gF1AAgAAAAAAgF1ABg0AAAACAAAAAACAW0ACAAAAAACAW0ACAAAAAACAW0ACAAAA
AACAW0ACAAAAAACAW0ACAAAAAACAW0ACAAAAAABAXUACAAAAAABAXUACAAAAAABA
XUACAAAAAABAXUACAAAAAABAXUABAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtA
AgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAA4FxAAgAAAAAA4FxAAgAA
AAAA4FxAAgAAAAAA4FxAAgAAAAAA4FxAAQIAAAAAAIBbQAIAAAAAAIBbQAIAAAAA
AIBbQAIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAEBdQAIAAAAAAEBd
QAIAAAAAAEBdQAIAAAAAAEBdQAIAAAAAAEBdQAECAAAAAACAW0ACAAAAAACAW0AC
AAAAAACAW0ACAAAAAACAW0ACAAAAAACAW0ACAAAAAACAW0ACAAAAAAAAXUACAAAA
AAAAXUABAQEBAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtAAgAA
AAAAgFtAAgAAAAAAgFtAAgAAAAAAIF5AAgAAAAAAIF5AAgAAAAAAIF5AAgAAAAAA
IF5AAgAAAAAAIF5AAQIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBb
QAIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBdQAIAAAAAAIBdQAIAAAAAAIBdQAIA
AAAAAIBdQAIAAAAAAIBdQAECAAAAAACAW0ACAAAAAACAW0ACAAAAAACAW0ACAAAA
AACAW0ACAAAAAACAW0ACAAAAAACAW0ACAAAAAADAXEACAAAAAADAXEACAAAAAADA
XEACAAAAAADAXEACAAAAAADAXEABAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtA
AgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAQF1AAgAAAAAAQF1AAgAA
AAAAQF1AAQEBAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtAAgAAAAAAgFtAAgAA
AAAAgFtAAgAAAAAAgFtAAgAAAAAAgF1AAgAAAAAAgF1AAgAAAAAAgF1AAgAAAAAA
gF1AAgAAAAAAgF1AAQIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBb
QAIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBdQAIAAAAAAIBdQAIAAAAAAIBdQAIA
AAAAAIBdQAIAAAAAAIBdQAECAAAAAAAAVkACAAAAAAAAVkACAAAAAAAAVkACAAAA
AAAAVg==');
.
.
.
dbms_aw_exp.import_chunk100(1492, 'QAIAAAAAAOBlQAIAAAAAAOBlQAIAAAAAAOBlQAIAAAAAAOBlQAIAAAAAAOBlQAEC
AAAAAADAckACAAAAAADAckACAAAAAADAckACAAAAAADAckACAAAAAADAckACAAAA
AADAckACAAAAAAAAeEACAAAAAAAAeEACAAAAAAAAeEACAAAAAAAAeEACAAAAAAAA
eEABAgAAAAAAAF5AAgAAAAAAAF5AAgAAAAAAAF5AAgAAAAAAAF5AAgAAAAAAwGJA
AgAAAAAAwGJAAgAAAAAAwGJAAgAAAAAAwGJAAgAAAAAAwGJAAgAAAAAAwGJAAgAA
AAAAwGJAAQIAAAAAAEBaQAIAAAAAAEBaQAIAAAAAAEBaQAIAAAAAAEBaQAIAAAAA
AEBaQAIAAAAAAEBaQAIAAAAAAABgQAIAAAAAAABgQAIAAAAAAABgQAIAAAAAAABg
QAEBAgAAAAAAgGZAAgAAAAAAgGZAAgAAAAAAgGZAAgAAAAAAgGZAAgAAAAAAgGZA
AgAAAAAAgGZAAgAAAAAAYGhAAgAAAAAAYGhAAgAAAAAAYGhAAgAAAAAAYGhAAgAA
AAAAQHFAAQIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBbQAIAAAAA
AIBbQAIAAAAAAIBbQAIAAAAAAMBhQAIAAAAAAMBhQAIAAAAAAMBhQAIAAAAAAMBh
QAIAAAAAAMBhQAYNAAAAAgAAAAAAAGlAAgAAAAAAAGlAAgAAAAAAAGlAAgAAAAAA
AGlAAgAAAAAAAGlAAgAAAAAAAGlAAgAAAAAAAGlAAgAAAAAAAGlAAgAAAAAAAGlA
AgAAAAAAAGlAAgAAAAAAAGlAAQIAAAAAAABXQAIAAAAAAABXQAIAAAAAAABXQAIA
AAAAAABXQAIAAAAAAABXQAIAAAAAAABXQAIAAAAAAEBaQAIAAAAAAEBaQAIAAAAA
AEBaQAIAAAAAAEBaQAEBAgAAAAAAAFlAAgAAAAAAAFlAAgAAAAAAAFlAAgAAAAAA
AFlAAgAAAAAAAFlAAgAAAAAAAFlAAgAAAAAAQFxAAgAAAAAAQFxAAgAAAAAAQFxA
AgAAAAAAQFxAAgAAAAAAQFxAAQIAAAAAAIBMQAIAAAAAAIBMQAIAAAAAAIBMQAIA
AAAAAIBMQAIAAAAAAEBUQAIAAAAAAEBUQAIAAAAAAEBUQAEBAQEBAgAAAAAAQGpA
AgAAAAAAQGpAAgAAAAAAQGpAAgAAAAAAQGpAAgAAAAAAQGpAAgAAAAAAQGpABgYA
AAACAAAAAABAZEACAAAAAABAZEAGFgAAAAIAAAAAAABZQAIAAAAAAABZQAIAAAAA
AABZQAIAAAAAAABZQAIAAAAAAABZQAIAAAAAAABZQAIAAAAAAIBcQAYRAAAAAgAA
AAAAgGZAAgAAAAAAgGZAAgAAAAAAgGZAAgAAAAAAgGZAAgAAAAAAgGZAAgAAAAAA
gGZAAgAAAAAA4GtAAgAAAAAA4GtAAgAAAAAA4GtAAgAAAAAA4GtAAgAAAAAA4GtA
AQIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBbQAIAAAAAAIBbQAIA
AAAAAIBbQAIAAAAAAIBcQAIAAAAAAIBcQAIAAAAAAIBcQAIAAAAAAIBcQAIAAAAA
AIBcQAECAAAAAACAW0ACAAAAAACAW0ACAAAAAACAW0ACAAAAAACAW0ACAAAAAACA
W0ACAAAAAACAW0ACAAAAAADAW0ACAAAAAADAW0ACAAAAAADAW0ACAAAAAADAW0AG
DgAAAAIAAAAAAEBaQAIAAAAAAEBaQAIAAAAAAEBaQAIAAAAAAEBaQAIAAAAAAEBa
QAIAAAAAAEBaQAIAAAAAAMBdQAIAAAAAAMBdQAIAAAAAAMBdQAIAAAAAAMBdQAIA
AAAAAMBdQAECAAAAAABAWkACAAAAAABAWkACAAAAAABAWkACAAAAAABAWkACAAAA
AABAWg==');
COMMIT; END;
----- PL/SQL Call Stack -----
  object      line  object
  handle    NUMBER  name
0x92ee5d08       815  package body SYS.DBMS_AW_EXP
0x92ee5d08       828  package body SYS.DBMS_AW_EXP
0x92ee5d08       192  package body SYS.DBMS_AW_EXP
0x92ee5d08       219  package body SYS.DBMS_AW_EXP
0x672eefe0       354  anonymous block
----- Call Stack Trace -----
calling              CALL     entry                argument VALUES IN hex      
location             TYPE     point                (? means dubious VALUE)     
-------------------- -------- -------------------- ----------------------------
ksedst()+27          CALL     ksedst1()            0 ? 1 ?
ksedmp()+557         CALL     ksedst()             0 ? 0 ? CD406A0 ? B5000000 ?
                                                   0 ? BFFFA070 ?
ksfdmp()+19          CALL     ksedmp()             3 ? BFFF9FE8 ? ACF7C35 ?
                                                   CD406A0 ? 3 ? CCF07B0 ?
kgerinv()+177        CALL     00000000             CD406A0 ? 3 ?
kgeasnmierr()+40     CALL     kgerinv()            CD406A0 ? B72B0020 ?
                                                   C89DFA0 ? 1 ? BFFFA020 ?
kghstack_underflow_  CALL     kgeasnmierr()        CD406A0 ? B72B0020 ?
internal()+254                                     C89DFA0 ? 1 ? 2 ? B72101E8 ?
kghstack_free()+619  CALL     kghstack_underflow_  CD406A0 ? B72101E8 ?
                              internal()           
ksmfrs()+17          CALL     kghstack_free()      CD406A0 ? B72101E8 ?
xsLobVWrite()+1394   CALL     ksmfrs()             B72101E8 ? B72380D0 ?
                                                   B72101E8 ? CD4079C ? 3F5 ?
                                                   1 ?
spefcifa()+81        CALL     00000000             BFFFAFBC ? B72B1EC8 ? 0 ?
                                                   B5C20E80 ?
spefmccallstd()+265  CALL     spefcifa()           BFFFAC98 ? 4 ? B72B1F98 ?
                                                   BFFFA544 ? BFFFA558 ? 0 ?
pextproc()+90        CALL     spefmccallstd()      BFFFAFEC ? BFFFAE40 ?
                                                   BFFFAD08 ? BFFFAC98 ? 0 ?
__PGOSF284_peftrust  CALL     pextproc()           BFFFAFEC ? BFFFAE40 ?
ed()+115                                           BFFFAD08 ? BFFFAC98 ?
                                                   CD4079C ? B ?
psdexsp()+188        CALL     00000000             BFFFAFEC ? CD406A0 ?
                                                   BFFFAAD4 ? 200 ? BFFFA670 ?
                                                   ACE2237 ?
rpiswu2()+334        CALL     00000000             BFFFAC18 ? BFFFA780 ?
                                                   ACD9867 ? CD406A0 ? 0 ?
                                                   B723A154 ?
psdextp()+454        CALL     rpiswu2()            9C5F4650 ? 3F ? 9C5F4678 ?
                                                   2 ? BFFFAC30 ? 3F ?
                                                   9C5F46F8 ? 0 ? BB65C90 ? 0 ?
                                                   BFFFAC18 ? 1 ?
pefccal()+457        CALL     00000000             BFFFB6E4 ? BFFFAE40 ?
                                                   BFFFAD08 ? 0 ? 20003 ?
                                                   BFFFAFEC ?
pefcal()+169         CALL     pefccal()            BFFFAFEC ? 9E3821CC ?
                                                   CCF07B0 ? BFFFAEC4 ?
                                                   B5F42E5A ? B6C002FC ?
pevm_FCAL()+133      CALL     pefcal()             BFFFAFEC ? BFFFAFEC ?
                                                   B71216CC ? BFFFAE40 ? 0 ? 1 ?
pfrinstr_FCAL()+56   CALL     pevm_FCAL()          B6470628 ? 91EBD108 ?
pfrrun_no_tool()+45  CALL     00000000             B6470628 ? 91EB6DD0 ?
                                                   B6470664 ?
pfrrun()+765         CALL     pfrrun_no_tool()     B6470628 ? 91EC3B7E ?
                                                   B6470664 ?
plsql_run()+736      CALL     pfrrun()             B6470628 ? 0 ? 0 ? 0 ?
                                                   B72CEAF0 ? B72CEB08 ?
peicnt()+552         CALL     plsql_run()          B6470628 ? 1 ? 0 ?
kkxexe()+389         CALL     peicnt()             BFFFB6E4 ? B6470628 ?
                                                   CD406A0 ? 0 ? BFFFB7FC ? 0 ?
opiexe()+4125        CALL     kkxexe()             B71B010C ? 672EE124 ? 224 ?
                                                   A8 ? 995ECE74 ? CCF07B0 ?
opiosq0()+2518       CALL     opiexe()             4 ? 0 ? BFFFC3F8 ?
opiosq()+19          CALL     opiosq0()            27 ? 3 ? BFFFECC0 ? 0 ?
opiodr()+985         CALL     00000000             27 ? 3 ? BFFFECC0 ?
ttcpip()+1093        CALL     00000000             27 ? 3 ? BFFFECC0 ? 3 ?
opitsk()+1031        CALL     ttcpip()             CD47EA0 ? 27 ? BFFFECC0 ? 0 ?
                                                   BFFFE99C ? BFFFEDD0 ?
opiino()+821         CALL     opitsk()             0 ? 0 ?
opiodr()+985         CALL     00000000             3C ? 4 ? BFFFF890 ?
opidrv()+466         CALL     opiodr()             3C ? 4 ? BFFFF890 ? 0 ?
sou2o()+91           CALL     opidrv()             3C ? 4 ? BFFFF890 ?
opimai_real()+117    CALL     sou2o()              BFFFF874 ? 3C ? 4 ?
                                                   BFFFF890 ?
main()+111           CALL     opimai_real()        2 ? BFFFF8C0 ?
__libc_start_main()  CALL     00000000             2 ? BFFFF984 ? BFFFF990 ?
+211                                               A8F1D6 ? BC7FF4 ? 0 ?
 
--------------------- Binary Stack Dump ---------------------

很明显,在出现错误时用户执行的操作是OLAP用户的导入操作,而之所以出现了ORA-600错误是由于imp工具调用dbms_aw_exp.import_chunk100过程时异常退出机制处理的存在问题,不应该顺利结束当前的执行,但是Oracle这里引发了一个内部的错误。
根据错误信息,这个错误对于数据库环境没有影响,可以简单的将其忽略掉。

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

评论