| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ora-600
I worked with RDBMS support in Oracle Denmark for far too many years, and I'm not that scared of 600's anymore. To provoke a bit, I find that they are in general harmless, and then in some cases indicate serious stuff.
When looking at Oracle source code, you will (if you ever get the chance :) ) see this kind of thing:
If.... then signal ORA-942 (or rather OERR(00942))
if .... something unforeseen happens, signal 600 with specific arguments
(OERI(17112))
Else... signal ORA-1000 (OERR(01000))
Of course I'm making up these numbers, but the two functions called are OERR for normal errors and OERI for Oracle ERror Internal. So the ora-00600 [17112] is because the normal error codes couldn't handle the situation.
So the first argument for an ora-600 error is the "error code" and is indeed specific for a certain part of the Oracle code. Support/Development can easily look up where in the code this is signalled, but it can be very difficult to find out why it was signalled (I'm saying this, because I rarely could figure it out - of course all the smart types could, but I couldn't).
In the case of ORA-00600 [17112], however, I do have some notes:
Internal heap errors/corruptions:
[17066] [17112] [17114] [17148] [17182]…
So look in the trace file for "BAD MAGIC NUMBER" and you will know that a problem occurred in the heap. There can of course be a lot of reasons for this magic number to give errors when computed. Check the bug database or Support for specifics. But it's not fatal or anything.
"A. Bardeen" wrote:
> Kevin,
>
> ORA-600's and ORA-7445's are very similar in some
> respects in that they are related to the death of a
> process.
>
> ORA-600's are essentially exception handlers so there
> are literally thousands of different ORA-600's. Some
> errors are signaled in only one situation, others can
> occur in hundreds of cases.
>
> An ORA-7445 is merely the Oracle error assigned to the
> return code when the OS terminates the process (bad
> process!). BTW, ORA-7445's are not signaled on NT,
> NetWare or Linux. Instead, the following errors are
> signaled: Dr. Watson errors (NT), abends (NetWare) or
> "Errors in file..." entries in the alert.log and trace
> files containing "Exception signal..." (Linux).
>
> With ORA-600's the first argument is very specific, so
> when searching on metalink include the first argument.
> Any additional arguments are specific to the
> environment (DBA's, object ID's, memory addresses,
> etc...) so they should not be searched on since they
> are unlikely to be the same.
>
> The arguments on ORA-7445 errors are usually
> irrelevant as they are frequently generic ([SIGSEGV],
> [SIGBUS], [Address not mapped to object], [Invalid
> address alignment] etc...).
>
> If you can identify the type of operation generating
> the error, then it helps to search on that along with
> the error. In some cases this will be in the trace
> file under the heading "Current SQL statement for this
> session."
>
> These errors frequently indicate bugs, but can also
> occur due to other reasons such as hardware/OS
> problems, corruption, or incorrect environment
> settings. For example, a corrupt block can signal an
> ORA-600 error because the information in the header of
> the block is out of sync.
>
> The best way to determine the cause of these errors is
> to log a tar with support as much of the information
> in the bugs is viewable only to support. They will
> need the alert.log (preferably going back to the last
> startup, but at least the last 3-10 days) along with
> the trace files generated (upload the whole file,
> don't just cut and paste portions of it).
>
> In the case of multiple errors in the alert.log,
> supply the trace files from the first couple of errors
> as often the first error can cause cascading errors.
>
> If a trace file is not generated by an ORA-7445, then
> you should try to extract a stack trace from the core
> file (see notes 1812.1 and 1007808.6). This needs to
> be done using the executables that generated the core
> file, so don't bother sending the core file to
> support.
>
> I'm developing this into a presentation that I hope to
> present at OpenWorld ("ORA-3113's, 600's, and 7445's
> Oh My!) so please feel free to send me questions or
> topics I should cover.
>
> HTH,
>
> -- Anita
>
> --- Kevin Kostyszyn <kevin_at_dulcian.com> wrote:
> > Well, is the answer for all ORA 600's, I have
> > noticed there are different
> > ones. One of my fellow employees just called me and
> > told me that the
> > production instance at a clients site just went down
> > with ORA 600. He said
> > that it said in paren's, (with complications). Now
> > what in the good lords
> > name does that mean? I looked on Metasuck and I
> > haven't seen anything. Is
> > the only answer to call support, or just hammer away
> > until he figures it
> > out? Anyone seen this before. And yes I know, it
> > 8.1.5 on NT..
> > Kev
> >
> > -----Original Message-----
> > Kirti
> > Sent: Monday, June 04, 2001 5:16 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi,
> > It generally means Contat Oracle Support.
> >
> > You may try to have your alert log file scanned at
> >
> http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html.
> > Set
> > Search Depth to 0.
> >
> > Very nice little tool from Unal Bilisim. I used it a
> > few times with good
> > results.
> >
> > HTH
> >
> > Regards,
> >
> > - Kirti Deshpande
> > Verizon Information Services
> > http://www.superpages.com
> >
> > > -----Original Message-----
> > > From: Raghu Kota [SMTP:raghukota_at_hotmail.com]
> > > Sent: Monday, June 04, 2001 3:11 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: ora-600
> > >
> > >
> > >
> > > Hi Friends
> > >
> > > What does it mean??
> > >
> > > ORA-00600: internal error code, arguments:
> > [17112], [33054472]
> > >
> > > Thanks
> > > Raghu.
> > >
> >
> _________________________________________________________________________
> > > Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com.
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: Raghu Kota
> > > INET: raghukota_at_hotmail.com
> > >
> > > Fat City Network Services -- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California -- Public Internet
> > access / Mailing Lists
> > >
> >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from). You may
> > > also send the HELP command for other information
> > (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Deshpande, Kirti
> > INET: kirti.deshpande_at_verizon.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Kevin Kostyszyn
> > INET: kevin_at_dulcian.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35
> a year! http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: A. Bardeen
> INET: abardeen1_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Venlig hilsen Mogens Nørgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= INET: mno_at_MiracleAS.dk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Jun 05 2001 - 05:50:33 CDT
 |
 |