Select Query fails with ORA-00600 [kxspoac : EXL 1] Errors (Doc ID 2165865.1)

Last updated on AUGUST 09, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The alert log and the incident trace file report the following error:

Errors in file /u01/app/oracle/diag/rdbms/traxpd/TRAXPD4/trace/TRAXPD4_ora_92687.trc (incident=220865):
ORA-00600: internal error code, arguments: [kxspoac : EXL 1], [2000], [132], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/traxpd/TRAXPD4/incident/incdir_220865/TRAXPD4_ora_92687_i220865.trc

There may or may not be a failing SQL in the incident trace file

SELECT nvl ( sum ( TCI."MAN_HOURS" *TCI."MAN_REQUIRE" ) , 0 ) + nvl ( sum ( TCI."INSPECTOR_MAN_HOURS" *TCI."INSPECTOR_MAN_REQUIRE" ) , 0 ) + nvl ( sum ( TCI."DUAL_INSPECTOR_MAN_HOURS" *TCI.DUAL_INSPECTOR_MAN_REQUIRE ) , 0 ) FROM "TASK_CARD_ITEM" TCI WHERE TCI."TASK_CARD" in ( SELECT ETC."TASK_CARD" FROM "ENGINEERING_TASK_CARD_CONTROL" ETC WHERE ETC."EO" in ( select :1 from dual UNION ALL SELECT ESC."EO" FROM "ENGINEERING_SCHEDULE_CONTROL" ESC WHERE ESC."SCHEDULE_CONTROL" in ( 'CALLEDON' , 'CALLEDONAT' , 'CALLEDON1' , 'CALLEDONRP' ) and pkg_engineering_function.gf_ec_called_on_check ( ESC."SCHEDULE_EO" , ESC."EO" , :2 , :3 , :4 , ESC.schedule_control , 'Y' ) =0 START WITH ESC."SCHEDULE_EO" =:5 CONNECT BY ESC."EO" =PRIOR ESC."SCHEDULE_EO" ) )

The failing functions and the call stack in the trace file shows functions like:

.... kxspoac opibnd0 opibnd kpoalbdf kpoal8 opiodr kpoodr upirtrc kpurcsc kpuexec OCIStmtExecute kxfxsStmtExecute kxfxsExecute kxfxsp kxfxmai kxfprdp opirip opidrv sou2o opimai_real ssthrdmain main libc_start_main start .... 

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