记录一下ora-00600[17182]的bug
环境:SunOS 64bit 10.2.0.4.0 RAC
alter记录
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
给出的解决方法如下:
环境: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
给出的解决方法如下: