ORA-600 (15599) Error

ORA-600 (15599) Error

The error message is as follows:

Errors in file/data/oracle/ora92/admin/data01/udump/data01_ora_28264.trc:
ORA-00600: internal error code, arguments: [15599], [], [], [], [], [], [], []

The information in the corresponding trace file is as follows:

Ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [15599], [], [], [], [], [], [], []
Current SQL statement for this session:
Select count (*) from (select t. permit_number, t. product_name, t. english_name, t. manufacture_dept, t. doseage,
T. spec, t. trade_name, t. old_permit_number, t. url, t. create_month from sfda_product_china t where t. create_mo
Nth = 15 and t. product_name like: 1 and t. manufacture_dept like: 2)
----- Call Stack Trace -----
Calling call entry argument values in hex
Location type point (? Means dubious value)
----------------------------------------------------------------------------
Ksedmp () + 328 CALL ksedst () + 0 FFFFFFFF7FFFA670?
000000000? 000000000?
00000003E?
FFFFFFFF7FFFAF08?
1031C8238?
Kgeriv () + 208 PTR_CALL 0000000000000000 000000000? 000103400?
0001035CC? 000102C00?
1035CC000? 1035CC128?
Kgeasi () + 180 CALL kgeriv () + 0 1035CC388? 1036ED828?
000000258? 0000013C8?
FFFFFFFF7FFFB7A8?
1035CD758?
QerhjIterateOverBuf CALL kgeasi () + 0 1035CC388? 1036ED828?
Fers () + 240 000003CEF? 000000002?
000000000? When then f?
Ksxb1inc () + 132 PTR_CALL 0000000000000000 000000000? 000000370?
FFFFFFFF7CF746C0?
FFFFFFFF7CF746B0?
00000006E? 10159F8C0?
KxhrPhash () + 304 CALL ksxb1inc () + 0 FFFFFFFF7FFFBA88?
000001FE8?
Fffffffffffd?
FFFFFFFF78F291CB?
FFFFFFFF78F291CB?
000000001?
QerhjBuildHashTable CALL kxhrPhash () + 0 FFFFFFFF78F291CB?
() + 892 FFFFFFFF7FFFBA88?
FFFFFFFF78F291CF?
000000C2D? 000000C34?
Ffffff78f291ca?
QerhjFetch () + 1000 CALL qerhjBuildHashTable 000008F1E? 1038129A0?
() + 0 000100000?
FFFFFFFF7CF70D38?
000000001?
FFFFFFFF7AC20CE0?
QervwFetch () + 148 PTR_CALL 0000000000000000 00209E846?
FFFFFFFF7CF70850?
FFFFFFFF7CF70D40?
101590720?
FFFFFFFF7FFFBD28?
000007FFF?
QergsFetch () + 2256 PTR_CALL 0000000000000000 441859F50? 10178BA40?
FFFFFFFF7CF70CF0?
000007FFF? 000101400?
000101590?
Opifch2 () + 1724 PTR_CALL 0000000000000000 000101400?
FFFFFFFF7CF70AE0?
000000000? Too many?
100F85240? 441859EC0?
Opifch () + 60 CALL opifch2 () + 0 000100C00? 000000043?
100F85240? 0000000C9?
FFFFFFFF7FFFC640?
000102C00?

SQL itself is very simple, it is a single table scan.

A query of the 15599 error in the ORA-600 found that the only known bug description was related to hash join, and the current SQL apparently did not include the HASH JOIN execution plan.

After carefully querying metalink, we found that the problem was very similar to Bug No. 3479075: first, it was a 15599 error for the ORA-600, and the affected Oralce versions were all 9204. Most importantly, the error messages in the Oracle error function stack Are consistent: qerhjIterateOverBuffers, ksxb1inc, kxhrPhash, qerhjBuildHashTable, qerhjFetch, qerjoFetch, and qergsFetch.

This bug is regarded as Bug No. the description is repeated in 2805580, but the Bug is No. 2805580 has not been the first time, the ORA-7445 and ORA-600 errors have been encountered many times have pointed to this error, in the following three articles are described: