RE: Unlisted reproducible ORA-600 on 10gR2

Thanks everyone for replying. This appears to be bug 5089217, despite some minor differences (which is probably why the ORA-600 lookup tool on MetaLink couldn't find it). That BUG says it's not fixed until v11.1, but MetaLink doc 391116.1 says it'll be in 10.2.0.3.0, which may be delayed until November or later. So until then I'll use the init.ora workaround.

Thanks again!
Rich

From: Ghassan Salem [mailto:salem.ghassan_at_gmail.com] Sent: Thursday, October 19, 2006 4:22 PM To: Jesse, Rich
Cc: oracle-l
Subject: Re: Unlisted reproducible ORA-600 on 10gR2

put this in your init
(or alter session set)
"_optimizer_connect_by_cost_based" = false;

rgds

On 10/19/06, Jesse, Rich < Rich.Jesse_at_qg.com <mailto:Rich.Jesse_at_qg.com>
> wrote:

        Hey all,         

        Implementing a new ERP system on 10.2.0.2.0 w/July 2006 CPU (waiting to

        see if October's implemented in .3) and this popped up from a query run

        by the app:         

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

        [], [], [], [], []         

        I can reproduce this at will from SQL*Plus.         

        Does the first parameter look familiar to anyone? I've never seen

        anything like that, and apparently MetaLink hasn't either. I've opened

        a priority 2 call, but thought I'd axe here, too.         

	TIA,
	Rich

--
http://www.freelists.org/webpage/oracle-l