RE: ora-600

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Tue, 05 Jun 2001 02:59:43 -0700
Message-ID: <F001.0031B9F4.20010605024103@fatcity.com>

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).

Received on Tue Jun 05 2001 - 04:59:43 CDT