Hi Mogens, It's nice to see you in this list with other gurus. I would like to add a little bit info to this list about heap corruptions: Ora-600 messages releated heap corruptions are not signaled by corrupter. It's signaled by a process which encounteres corrupted blocks. So, analyzing heap corruption trace files do not make sense. If you would like to catch errors closer to corrupter, see http://www.unal-bilisim.com/qa/discus/messages/15/30.html?991049882 Danisment.... ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, June 05, 2001 2:55 PM 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]. E.g. "BAD MAGIC NUMBER" in trace file 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > > > 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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: unal-bilisim INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).