数据库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这里引发了一个内部的错误。
根据错误信息，这个错误对于数据库环境没有影响，可以简单的将其忽略掉。