Re: ora-600...

Thanks for the tip, Vladimir, I'll take it up with our sysadmin. I have an idea of what may be the root of the problem.

Thanks again,

Bricklen

;-)

"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@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
Received on Mon Oct 07 2002 - 10:01:55 CDT