ORA-600(17182)错误

在数据库的警告文件中发现这个错误。

错误信息如下：

Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:ITPUB个人空间F-XK6ZD^hyT
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []
6@'GN2U$\V4i~c0Wed May 28 15:12:09 2008ITPUB个人空间hS)q3A1QYmQ
Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:ITPUB个人空间 E S3v4e k1Z.xY
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间(rx%G1rWu
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []ITPUB个人空间,SrI;]ae;BB]K5R,r1K
Wed May 28 15:12:10 2008
1S$Ow$k^_/e(x8\ sb4^0Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:ITPUB个人空间xrN5PKZ+mU!R1[z
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间Z8Q&PZ b7s8o
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
A;YW;eZ7M0sTt:l0ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []ITPUB个人空间 q)fba;v vp1R4]
Wed May 28 15:12:12 2008ITPUB个人空间Et\!oluhv
Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:ITPUB个人空间sqF}5I
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
Y.b*O0o(LGw4X0ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间i!q/P_Z3c1O-w
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
9|,`N]-hn J0ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []
5[.t6Ob3C X(x9t/? D0Wed May 28 15:12:15 2008
3La#x0V9C'c T Y0Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:
z{1T{7f0ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间KQ@s$g yIj{ j
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间Yb1X.aM];}
v
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
"r+f$`tM KL g
d0ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间$]4R`^){@S
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []ITPUB个人空间4}\,g4rJ|`i6w
Wed May 28 15:12:18 2008ITPUB个人空间'j6`] Yw1b!s
Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:
9d(k} Yy%T4Af0ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
,q5dNr1dl Vb(DE0ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间
]TFM&z'F/sW
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间*sz'G
K X;].C
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间![:lj? Y8`
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间8q.vpJs*o_
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []ITPUB个人空间 K2wj/i!I o/P&D)jt
Wed May 28 15:12:21 2008
"Lg{!A+_#znV0Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:
5c&Z_l#j)Y4]8}0ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
5H2k8y1S)? n\B#U0ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
7E6`7{kH9H0ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间Q:P3u F V#B
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
s5u1Y8e)d9m0ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间 U\%Z[#J.b_9dC
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间x XZPD L%el
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []
+g.UD:^yKL b0Wed May 28 15:12:24 2008
ez.r NB[^0Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:
e s!?*T b"[0ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
z}N5H/_}]0ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间)B(N|7r\6toX
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间1Q+?0c| k8V1}!^:l%P
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
x ^hz td0ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间8R)y^^.D }{#nfe
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []ITPUB个人空间]y1dB;g
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
w8P"m5u.^0ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []

而对应的trace文件中的部分信息如下：

*** 2008-05-28 15:12:07.707ITPUB个人空间kXqz4Q~7|L;r
*** SESSION ID:(67.16693) 2008-05-28 15:12:07.689ITPUB个人空间+u6[xF O
********** Internal heap ERROR 17182 addr=ffffffff7cc71de8 *********
n s%d1?2uy9|(y-[)x0***** Dump of memory around addr ffffffff7cc71de8:
a2DqY)d5i!Y M1y;Z0FFFFFFFF7CC71BE0                   00000000 00000000          [........]ITPUB个人空间`P.hwK[
X
FFFFFFFF7CC71BF0 00000000 00000000 00000000 00000000  [................]
&b^*S/| S)x0        Repeat 62 times
)tg9lG8war0FFFFFFFF7CC71FE0 00000000 00000000                    [........]       ITPUB个人空间 [*jwE"{*V2}E
******************************************************
`;J5v+dq0HEAP DUMP heap name="hash-join subh"  desc=ffffffff7cfe7d38
z0G*\y,S
Z&d-i!P6s0 extent sz=0xfefc alt=32767 het=32767 rec=0 flg=2 pc=2
C/t8Y!DYC+B0 parent=ffffffff7d07ad78 wner=0 nex=0 xsz=0x3e228
u{L7V4sg0EXTENT 0 addr=ffffffff7cc71dd8
7[,YW8Dv\0ERROR extent at ffffffff7cc71dd8 contains wrong ds 0ITPUB个人空间(a\3\q;CW
***** Dump of memory around addr ffffffff7cc71dd8:
v \*G#j{l],a0FFFFFFFF7CC71BD0                   00000000 00000000          [........]ITPUB个人空间bD N sV!Ee
FFFFFFFF7CC71BE0 00000000 00000000 00000000 00000000  [................]
S6k4bqU0        Repeat 62 times
jz qQ7C&`;Z_h0FFFFFFFF7CC71FD0 00000000 00000000                    [........]       ITPUB个人空间,EAuWba
  Chunk ffffffff7cc71de8 sz=        0  ERROR, BAD MAGIC NUMBER (0)ITPUB个人空间a&E i a1FC
Total heap size    =        0ITPUB个人空间"c,~%ssJ
FREE LISTS:
c,nD H;_6y9b0 Bucket 0 size=0
2_.U:U?mK0  Chunk ffffffff7cb90110 sz=    11832    free      "               "
H}y ?-_0  Chunk ffffffff7cb80110 sz=    16040    free      "               "ITPUB个人空间#l8g7S lO1Qk
  Chunk ffffffff7cb72070 sz=     8008    free      "               "
uOONqN3SX;Mq0Total free space   =    35880ITPUB个人空间)_-v$P:OwFTA)g
UNPINNED RECREATABLE CHUNKS (lru first):ITPUB个人空间I
O ]1HA
PERMANENT CHUNKS:ITPUB个人空间*]4p!z&J'L8T]
  Chunk ffffffff7cb70128 sz=     8008    perm      "perm           "  alo=8008ITPUB个人空间8^-q|.Q d(p
Permanent space    =     8008ITPUB个人空间 BE o2~y(\0P(l
******************************************************ITPUB个人空间.IV(] nM3ifi!c
 Hla: 0
SP@F_!~1] H0*** 2008-05-28 15:12:07.720
[\7^ Y+ld x@4S0ksedmp: internal or fatal errorITPUB个人空间.~/|&?)IMY[7V/J
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []ITPUB个人空间;wi6~/D2At
Current SQL statement for this session:
U%u,X^z0select count(*) from (select  /*+ full(i) */  a.member_type,a.ASSOCIATE_FLAG, a.wrap_code,a.wrap_desc,b.ready_flag,a.id, a.id as pro
{1\3A2d!r
bsQo0duct_id,a.PLAT_ID,a.trade_name,b.spec,a.check_flag,  b.name_chn as drug_name,c.name as factory_name,c.abbr as factory_easy, d.code aITPUB个人空间m$o9b
T3K'uH
s doseCode, d.name_chn as doseName,a.middle_stand_rate,a.big_middle_rate,b.stand_rate,a.national_retail_price, e.name_chn as METRIC_ITPUB个人空间 _tP
UO;W}
NAME,f.QUALITY_NAME,g.PLAT_NAME,g.plat_father,i.name ,a.url  , decode(sign(a.EXPIRY_DATE-sysdate),1,1,-1,-1,0,0) expiry_flag , decod
%O;d&P,`vwAAM0e(sign(a.IMPORT_LICENCE_EXPIRY_DATE-sysdate),1,1,-1,-1,0,0) import_flag  ,a.patent_flag,a.PATENT_BEGIN_DATE  ,decode(sign(a.PATENT_E
,O|7\.b"XrKy0ND_DATE-sysdate),1,'1',-1,'-1',0,'0') PATENT_END_DATE  from cat_product a,cat_drug b,cat_org c, cat_doseage_form. d,cat_metric e,cat_
wmMS8j0quality_define f,plt_plat g,gpo_usr_user i ,cat_drug b18 , cat_product_center j , cat_drug b16  ,cat_zone_product_ready r        whe
@,l9v?Zt mmgG0re a.medical_id = b.id  and a.check_user = i.id(+) and a.ENABLE_FLAG = '1'  and a.id=j.id   and b.code18_id = b18.id  and b.code16_i
Zd"o{E } Ga[P0d = b16.id      and b.ready_flag = r.ready_type(+)         and (r.plat_id ='DATA10000000000012050665'  and r.enable_flag='1' or b.reITPUB个人空间FpDk6Ei+sx*VW6S
ady_flag is null)  and  ( a.trade_name like '%炎琥宁%' or b.name_chn like :1 ) and c.name||c.abbr like :2  and a.manufacture_id = c.ITPUB个人空间{'C5N&G6Y&A_k
id  and d.code = b.doseage_form_code and a.metric_id = e.id and a.QUALITY_CODE = f.quality_code and a.PLAT_ID = g.id )
7qf9CE.M*T&[/A0----- Call Stack Trace -----ITPUB个人空间 h9s^zenr@
calling              call     entry                argument values in hex     
r$?(j;rzD
uaC0location             type     point                (? means dubious value)    
u!\#W b&ZV/H0-------------------- -------- -------------------- ----------------------------
2d l8IH3^~r J0ksedmp()+328         CALL     ksedst()+0           FFFFFFFF7FFFA2F0 ?
lzj5| `7{vHB0                                                   000000000 ? 000000000 ?
t;HmV+nF:Hek'`0                                                   00000003E ?
5D@/~B q0                                                   FFFFFFFF7FFFAB88 ?ITPUB个人空间`r8|(?[fM"r9Z
                                                   1031D6908 ?ITPUB个人空间P1p$h v+e9Jkf
kgeriv()+208         PTR_CALL 0000000000000000     000000000 ? 000103400 ?ITPUB个人空间;T#Bm'@-vL
                                                   0001035DA ?000102C00 ?ITPUB个人空间;o/^1s{ k
                                                   1035DA000 ? 1035DAE28 ?ITPUB个人空间
e+W g$\&MaaC
kgesiv()+108         CALL     kgeriv()+0           1035DB088 ? 1036FCAE8 ?
(K-r x2_+b4G`A0                                                   000000258 ?0000013C8 ?
k*@M9CK`QT0                                                   FFFFFFFF7FFFB4C8 ?ITPUB个人空间th+r(O p1A
                                                   1035DC458 ?ITPUB个人空间Di)lS%`6a
kgesic1()+32         CALL     kgesiv()+0           1035DB088 ? 1036FCAE8 ?
!WN E'Z$d{uT!~\0                                                   00000431E ? 000000001 ?ITPUB个人空间 gs2\M}&Go
                                                   FFFFFFFF7FFFB4C8 ?ITPUB个人空间9d5s3T"^_e;{_
                                                   102BE7C20 ?
Y_q[Dv*c$Q0kghfrf()+908         CALL     kgherror()+0         1035DB088 ? 1036FCAE8 ?ITPUB个人空间{"HN/E~${+@(|
                                                   00000431E ? 000000002 ?ITPUB个人空间x+o^~%u S XN
                                                   FFFFFFFF7CC71DE8 ?
|b2DLR.Fe0                                                  10059A300 ?ITPUB个人空间*N?ih)r7`*qWCv
kllcqf()+232         PTR_CALL 0000000000000000     1035DB088 ?

SQL本身没有什么大问题，看来应该是Oracle本身的bug造成的。查询了一下metalink，在Doc ID: Note:34779.1文档中，Oracle描述了这个bug的产生原因：由于Oracle检查到内存中的chunk头被覆盖，因此引发了这个错误。

检查已知的bug列表，没有发现和当前错误相似的bug。根据ORA-600 17182和kghasp1为关键字查询，结果发现问题和Bug No. 3492310的描述比较类似。

首先版本比较接近，而且数据库的平台一致，错误的调用函数列表相似度也很高。不过这个bug并没有给出错误的原因和描述，只是提到了当数据库版本升级到9205后问题没有再现。

这个错误并非第一次出现，而且每次出现时SQL基本上比较类似，但是又不是100%可重现的，估计是特定环境下导致了内存处理出现了问题。

基本上这个错误对系统的影响不大，出现的频率也很低，不过倒是可以记录一下，看看以后升级到9205以上的版本是否这个错误不会再出现。