ORA-600 [qctcte1]

<<Back to DB Administration Main Page

ORA-00600: Interner Errorcode Argumente: [qctcte1], [0], [], [], [], [], [], [], [], [], [], []

Errors in file /ora_log/diag/rdbms/orcl1p/orcl1p/trace/orcl1p_ora_51422.trc  (incident=37128):
ORA-00600: Interner Fehlercode, Argumente: [qctcte1], [0], [], [], [], [], [], [], [], [], [], []
Incident details in: /ora_log/diag/rdbms/orcl1pp/orcl1p/incident/incdir_37128/orcl1p_ora_51422_i37128.trc
Use ADRCI or Support Workbench to package the incident.

Oracle Support  (Doc ID 248095.1), telling more about this 

Sno	NB	Prob	Bug	Fixed	Description
1		-	29590666	20.1	ORA-600 [qctcte1] on xml query
2	E	-	29320900	20.1	select query can fails with ORA-600 [qctcte1] on 12.1
3		II	28537481	20.1	ORA-600[qctcte1] when using inner join and bind variables
4		II	27421733	19.1	ORA-600 [qctcte1] with fix 26025681 present
5		II	25713728	19.1	ORA-600 qctcte1 in select that containt a subselect compare with not it

Workaround

if you are hitting bug in Sno.1

 Disable XML Query rewrite using SQL Hint.

if you are hitting bug in Sno.4

 alter session set "_optimizer_cbqt_or_expansion"=off;

if you are hitting bug in Sno.5

 "_fix_control"='12999577:off'

There is no workarond other than upgrading the database for rest of possible bugs