RE: Unlisted reproducible ORA-600 on 10gR2

  • From: "Jesse, Rich" <Rich.Jesse@xxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 23 Oct 2006 10:44:13 -0500

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@xxxxxxxxx] 
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@xxxxxx <mailto:Rich.Jesse@xxxxxx>
> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: