ORA-600(ttcgcshnd-1)错误

一个很老的bug，现在估计很难碰到，简单记录一下。

使用9i以前的JDBC驱动连接9i的数据库，可能会遇到这个问题。

在alert文件中，错误信息如下：

Errors in file /u1/oracle/admin/repdb01/udump/repdb01_ora_21237.trc:ITPUB个人空间|$b0U^ h1B#RF*m
ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], []

而对应的trace文件中的详细信息为：

ksedmp: internal or fatal errorITPUB个人空间4A-Q^$TMBE(m
ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], []ITPUB个人空间$o B{-q4?HL
Current SQL statement for this session:ITPUB个人空间{6V!N9iCO8@ }e
SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'
Au?lSR5oR?Uh0----- Call Stack Trace -----ITPUB个人空间"I5}wa`;{.V
calling              call     entry                argument values in hex     
.OZ7im)r0]V0location             type     point                (? means dubious value)    
t$xj2@|4]0-------------------- -------- -------------------- ----------------------------
D
s9C
L1g+LL.}0ksedmp()+328         CALL     ksedst()+0           FFFFFFFF7FFF9660 ?
3L
^ `(nF2d0                                                   000000000 ? 000000000 ?
'f6`3qE[
`0                                                   00000003E ?ITPUB个人空间,h K3Y%X2bm|/_.Q?
                                                   FFFFFFFF7FFF9EF8 ?ITPUB个人空间$JeH]D:}&e1Qg3Zp
                                                  1031C9458 ?
.y,OJ8?2n#|0kgerinv()+184        PTR_CALL 0000000000000000     000000000 ? 000103400 ?
?zh}#mV \ W"a0                                                   0001035CD ?000102C00 ?
Xpd6Wlx5\(l0                                                   1035CD000 ? 1035CD328 ?ITPUB个人空间An.U8I(k\
kgeasnmierr()+28     CALL     kgerinv()+0          1035CD588 ? 1036EDE38 ?
p [2W'n}sb3U^\K0                                                  0000013C8 ? 000000001 ?
(Mf8U;LXP1K'|\0                                                   1035CF694 ? 1035CE958 ?
&MM7vOhp#p,U0ttcgcshnd()+248      CALL     kgeasnmierr()+0      1035CD588 ? 1036EDE38 ?ITPUB个人空间IoX@;`d0j
                                                  1033A2758 ? 000000001 ?ITPUB个人空间NUXh-`
                                                   000000000 ? 000000000 ?
O]4fTW5]m-]0ttcc2u()+784         CALL     ttcgcshnd()+0        1035CD588 ? 102DA4880 ?ITPUB个人空间5V yE}+J q;\K
                                                   FFFFFFFF7FFFE1E0 ?ITPUB个人空间*Yp/?"^4R(eN7`
                                                   FFFFFFFF7FFFE1E8 ?
A.Q4jy&~0                                                   FFFFFFFF7FFFE1F0 ?ITPUB个人空间8paWVk8](p M
                                                   FFFFFFFF7FFFE1F2 ?

Oracle的文档Doc ID: Note:1725012.8描述了这个bug，解决方法最简单的莫过于升级客户端的JDBC驱动了，这时一劳永逸的方法。

除此之外，Oracle还提供了单独的补丁。而且通过设置EVENTS 10841也可以解决这个问题。