Re: ora-600...

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3DA1BE7D.55D83C77_at_exesolutions.com...
> "Vladimir M. Zakharychev" wrote:
>
> > [17182] says there was memory corruption detected, so you should
> > investigate OS event/messages log for any hardware (specifically, RAM)
> > issues. Having a pattern like yours I would suspect there is a bad
> > memory module in your system...
> >
> > --
> > Vladimir Zakharychev (bob_at_dpsp-yes.com)
http://www.dpsp-yes.com
> > Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
applications.
> > All opinions are mine and do not necessarily go in line with those of my
employer.
> >
> > "Bricklen" <bricklen_at_shaw.ca> wrote in message
news:3DA0C839.E3E1DFCF_at_shaw.ca...
> > > Anyone else seen this? Was just trying some string results from dual
and
> > > got the following (8.1.7):
> > >
> > > SQL>select '''''' from dual;
> > > select '''''' from dual
> > > *
> > > ERROR at line 1:
> > > ORA-00600: internal error code, arguments: [17182], [159051124], [],
[],
> > > [], [], [], []
> > >
> > > SQL>select '''a''' from dual;
> > > ''A''
> > > --------------------------------
> > > 'a'
> > >
> > > 1 row selected.
> > >
> > > SQL>select '''ab''' from dual;
> > > ''AB''
> > > --------------------------------
> > > 'ab'
> > >
> > > 1 row selected.
> > >
> > > SQL>select '''abc''' from dual;
> > > ''ABC''
> > > --------------------------------
> > > 'abc'
> > >
> > > 1 row selected.
> > >
> > > SQL>select '''abcd''' from dual;
> > > select '''abcd''' from dual
> > > *
> > > ERROR at line 1:
> > > ORA-00600: internal error code, arguments: [17182], [159051124], [],
[],
> > > [], [], [], []
> > >
> > > SQL>select '''abcde''' from dual;
> > > ''ABCDE''
> > > --------------------------------
> > > 'abcde'
> > >
> > > 1 row selected.
> > >
> > > SQL>select '''abcdef''' from dual;
> > > ''ABCDEF''
> > > --------------------------------
> > > 'abcdef'
> > >
> > > 1 row selected.
> > >
> > > Not asking for advice or the obligatory admonition to contact support,
> > > just thought it curious that 0, 3, or 4 would cause ORA-600's.
> > >
> > > Cheers,
> > >
> > > Bricklen
>
> Quick question ... what is the source of the information you are quoting
such as [17182]
> says there was memory corruption detected. I would like to make it
available for my
> students.
>
> Thanks,
>
> Daniel Morgan
>

There is an ora-600 lookup facility on Metalink.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address