Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ora-600...

Re: ora-600...

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 07 Oct 2002 22:53:45 GMT
Message-ID: <3DA2105A.4B3CB02D@exesolutions.com>


Sybrand Bakker wrote:

> "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

Thanks.

Daniel Morgan Received on Mon Oct 07 2002 - 17:53:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US