Upgrade From 9i To 10g Caused Ora-0600 [Qctcte1], [0]

(Doc ID 417645.1)

Last updated on JUNE 13, 2013

Applies to:

Oracle Server - Standard Edition - Version: 10.2.0.2 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

Query with "CONNECT BY" and "OUTER JOIN" failed with 

ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], []

For example : 


SELECT TRA.MGR_ID AS "Sheet", .........
FROM ( SELECT T.PROJ_ID, T.TASK_ID, RSC.RSRC_ID, ...
CONNECT BY PRIOR RCV.PARENT_RSRC_CATG_ID = RCV.RSRC_CATG_ID ) ) START WITH

R.RSRC_ID = :"SYS_B_06" CONNECT BY PRIOR R.RSRC_ID ....

PROJ_ID(+) AND TRA.TASK_ID = ACT.TASK_ID(+) AND TRA.RSRC_ID = ACT.RSRC_ID(+) ...
_SPLIT, TRA.PROJECT_ID, TRA.WBS_TREE, TRA.TASK_CODE

----- Call Stack Trace -----
sedst ksedmp ksfdmp kgerinv kgeasnmierr qctcte qctoreo qctcopn qctclog qctcpqb
qctcpqbl qctcpqb qctcpqbl qctcpqb qctcpqbl qctcpqb qctcpqbl xtydrv kkqcttcalo
kkqcbydrv ...

Upgraded to 10.2.0.3.0 still error out and tried setting: _OPTIMIZER_COST_BASED_TRANSFORMATION=OFF still same error.

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