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: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 10 Oct 2002 09:41:27 +0100
Message-ID: <3da53d38$0$1288$ed9e5944@reading.news.pipex.net>


Note that not all arguments are available yet and that you can also post the dump that is created with the 0600.

Its a good facility though.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3DA2105A.4B3CB02D_at_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 Thu Oct 10 2002 - 03:41:27 CDT

Original text of this message

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