ORA-00600 [17182] Raised For A Complex Query (Doc ID 1569000.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When executing a complex query using PL/SQL functions and Oracle Text functionality
the query crashes with:
ORA-00600: internal error code, arguments: [17182], [0x9FFFFFFFFB57D018], [], [], [], [], [], [], [], [], [], []

Call Stack Trace:
$cold_kghfrf  kcikghfrf  drumcmf  dredpdst  dredSkiplistHeaderFirst dredParseHeader  dredilpg  dredifpg  dredmseek  dredseek
drebytc  drywnfc  dryoftc  drexqiftc  drexqpftc  drexqxs drexrcontains  qxopqxex  qeroifcsu  qxopqdex  qxopqeuo  evaopn2
evareo  expepr  expeal  qertbFetchByRowID  qergiFetch  qerjotFetch  qerjoFetch  qerflFetch  qerflFetch  $cold_qertqoFetch
$cold_qerpxFetch   qerflFetchOutside  qercoFetch  rwsfcd qeruaFetch  qersoProcessULS  qersoFetch  qervwFetch  qerjotFetch
qerjotFetch  rwsfcd  qerhjFetch  qerghFetch  qersoProcessULS qersoFetch  qervwFetch  qercoFetch  opifch2  opifch  opipls
opiodr  rpidrus  skgmstack  rpidru  rpiswu2  rpidrv  psddr0 psdnal  pevm_EXIM  pfrinstr_EXIM  pfrrun_no_tool  pfrrun  plsql_run
 peicnt  kkxexe  opiexe  kpoal8  opiodr  ttcpip  opitsk opiino  opiodr  opidrv  sou2o  opimai_real  ssthrdmain  main main_opd_entry

Other sessions also crash with:
ORA-00600: internal error code, arguments: [17183], [0x9FFFFFFFFBE96F98], [], [], [], [], [], [], [], [], [], []
ORA-20000: Oracle Text error:
DRG-50850: ORA-00600: internal error code, arguments: [17182], [0x9FFFFFFFFBEA3CF8], [], [], [], [], [], [], [],

The problem seems to be caused by the complexity of the query. Removing tables from the join conditions or simplifying the query in other ways
allows the query to complete.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms