ORA-00600: internal error code, arguments: [17182]

最新推荐文章于 2023-08-31 14:29:22 发布

原创最新推荐文章于 2023-08-31 14:29:22 发布 · 2.7k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#exception #object #hex #c #file

ORA-xxx 同时被 2 个专栏收录

24 篇文章

订阅专栏

Oracle Production DB

22 篇文章

订阅专栏

本文记录了一次ORA-00600内部错误的详细情况，该错误代码为17182。文章提供了完整的错误日志及堆栈跟踪，分析了内存块头部被覆盖导致的问题，并引用了官方解释和相关解决方案。

记录一下ora-00600[17182]的bug
环境:SunOS 64bit 10.2.0.4.0 RAC
alter记录

Fri Aug 24 17:55:21 2012
Errors in file /export/home/oracle/admin/SAMP/udump/samp3_ora_28722.trc:
ORA-00600: internal error code, arguments: [17182], [0x1069F1560], [], [], [], [], [], []

Fri Aug 24 17:55:24 2012
Errors in file /export/home/oracle/admin/SAMP/udump/samp3_ora_28722.trc:
ORA-07445: exception encountered: core dump [kopopgt()+76] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7AF24F68] [] []
ORA-00600: internal error code, arguments: [17182], [0x1069F1560], [], [], [], [], [], []

trace记录

*** 2012-08-24 17:55:21.940
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17182], [0x1069F1560], [], [], [], [], [], []
Current SQL information unavailable - no session.
----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
ksedmp()+744         CALL     ksedst()             000000840 ?
                                                   FFFFFFFF7FFFD29C ?
                                                   000000000 ?
                                                   FFFFFFFF7FFF9D90 ?
                                                   FFFFFFFF7FFF8AF8 ?
                                                   FFFFFFFF7FFF94F8 ?
kgeriv()+220         PTR_CALL 0000000000000000     000106400 ? 1066A3E24 ?
                                                   1066A3000 ? 0001066A3 ?
                                                   000106400 ? 1066A3E24 ?
kgesiv()+112         CALL     kgeriv()             10669E778 ? 000000000 ?
                                                   00000431E ? 000000001 ?
                                                   FFFFFFFF7FFFD808 ?
                                                   000001430 ?
kgesic1()+32         CALL     kgesiv()             10669E778 ? 1067FE840 ?
                                                   00000431E ? 000000001 ?
                                                   FFFFFFFF7FFFD808 ?
                                                   000001420 ?
kghfrf()+192         CALL     kgherror()           10669E778 ? 1067FE840 ?
                                                   00000431E ? 000000002 ?
                                                   1069F1560 ? 000001400 ?
ksxpunmap()+1804     CALL     kghfrf()             10669E778 ? 1069F1558 ?
                                                   1069F1560 ? 0069F1558 ?
                                                   1069F1560 ? 000000000 ?
kclnfy()+3028        CALL     kclumap()            1069F1310 ? 1069F1560 ?
                                                   1069F1560 ? 1069F1558 ?
                                                   000000000 ? 000000002 ?
kscnfy()+552         PTR_CALL 0000000000000000     00000000F ? 53F4C2F50 ?
                                                   1025F8000 ? 000380013 ?
                                                   380013918 ? 1066A1B30 ?
ksucrp()+2384        CALL     kscnfy()             000008000 ? 0008C9034 ?
                                                   100E5B6A0 ? 105B66D18 ?
                                                   00000000F ? 000000001 ?
opiino()+1348        CALL     ksucrp()             53752E700 ? 000106400 ?
                                                   380007BB8 ? 000380007 ?
                                                   000380000 ? 000380007 ?
opiodr()+1496        PTR_CALL 0000000000000000     10581D000 ?
                                                   FFFFFFFF7FFFED58 ?
                                                   00010581D ? 000106400 ?
                                                   1060EA000 ? 000000001 ?
opidrv()+828         CALL     opiodr()             000106400 ? 1066A1000 ?
                                                   000106400 ? 000106400 ?
                                                   10124BD40 ? 1066AA000 ?
sou2o()+80           CALL     opidrv()             1066AE258 ? 000000001 ?
                                                   000000020 ? 000000000 ?
                                                   000000020 ? 000106400 ?
opimai_real()+352    CALL     sou2o()              FFFFFFFF7FFFF318 ?
                                                   000000020 ? 000000003 ?
                                                   FFFFFFFF7FFFF340 ?
                                                   1061A6000 ? 0001061A6 ?
main()+152           CALL     opimai_real()        000000C2B ?
                                                   FFFFFFFF7FFFF418 ?
                                                   10030497C ? 106647740 ?
                                                   0027578F4 ? 00000D800 ?
_start()+380         CALL     main()               000000002 ? 000000008 ?
                                                   000000000 ?
                                                   FFFFFFFF7FFFF428 ?
                                                   FFFFFFFF7FFFF538 ?
                                                   FFFFFFFF7B200180 ?


*** 2012-08-24 17:55:24.843
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kopopgt()+76] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7AF24F68] [] []
ORA-00600: internal error code, arguments: [17182], [0x1069F1560], [], [], [], [], [], []
Current SQL information unavailable - no session.
----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
ksedmp()+744         CALL     ksedst()             000000840 ? 106B6417C ?
                                                   000000000 ? 106B60C70 ?
                                                   106B5F9D8 ? 106B603D8 ?
ssexhd()+1232        CALL     ksedmp()             000106400 ? 1066A3E24 ?
                                                   1066A3000 ? 0001066A3 ?
                                                   000106400 ? 1066A3E24 ?
__sighndlr()+12      PTR_CALL 0000000000000000     1066A1000 ? 106B67EF0 ?
                                                   10669DD8C ? 0001066A1 ?
                                                   00000000B ? 000000067 ?
call_user_handler()  CALL     __sighndlr()         00000000B ? 106B67EF0 ?
+992                                               106B67C10 ? 101F1D480 ?
                                                   000000000 ? 00000000A ?
kopopgt()+72         CALL     kopodst()            FFFFFFFF7C000200 ?
                                                   FFFFFFFF7C000200 ?
                                                   106B67C10 ? 000000009 ?
                                                   000000000 ? 000000000 ?
kokgnfy()+72         CALL     kopopgt()            000050190 ? 000050000 ?
                                                   002431274 ? 102C8CE08 ?
                                                   106647740 ? 10669E778 ?
kscnfy()+552         PTR_CALL 0000000000000000     000000017 ? 000000000 ?
                                                   10669E438 ? 10669E000 ?
                                                   00010669E ? 000106400 ?
ksmdpg()+100         CALL     kscnfy()             000800000 ? 0008080B0 ?
                                                   1025F52C0 ? 105B67348 ?
                                                   000000017 ? 000000001 ?
opidcl()+660         CALL     ksmdpg()             000106400 ? 000106400 ?
                                                   10669D000 ? 00010669E ?
                                                   000106400 ? 000000000 ?
opidrv()+980         CALL     opidcl()             10669E000 ? 10669E438 ?
                                                   000000000 ? 1066A1B30 ?
                                                   1066A1000 ? 10581D000 ?
sou2o()+80           CALL     opidrv()             1066AE258 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000020 ? 000106400 ?
opimai_real()+352    CALL     sou2o()              FFFFFFFF7FFFF318 ?
                                                   000000020 ? 000000003 ?
                                                   FFFFFFFF7FFFF340 ?
                                                   1061A6000 ? 0001061A6 ?
main()+152           CALL     opimai_real()        000000C2B ?
                                                   FFFFFFFF7FFFF418 ?
                                                   10030497C ? 106647740 ?
                                                   0027578F4 ? 00000D800 ?
_start()+380         CALL     main()               000000002 ? 000000008 ?
                                                   000000000 ?
                                                   FFFFFFFF7FFFF428 ?
                                                   FFFFFFFF7FFFF538 ?
                                                   FFFFFFFF7B200180 ?

在OTN上查询发现官方给出的原因:
Oracle has detected that the magic number in a memory chunk header has been overwritten.
This is a heap (in memory) corruption and there is no underlying data corruption. The error may occur in the one of the process specific heaps (the Call heap, PGA heap, or session heap) or in the shared heap (SGA).
参考http://www.muzijiang.cn/index.php/2010/03/diag_ora_60017182/认为是Bug 2698127,打上P2281320.

另外https://forums.oracle.com/forums/thread.jspa?threadID=2383536&tstart=2
Bug 7330434- Memory corruption / OERI:17147 from DBMS_MVIEW.REFRESH
给出的解决方法如下: