Re: ORA-00600 Error

Hi,

Analyzing ORA-600 trace files for the heap corruptions doesn't make sense. Because, this corruption errors are thrown if someone tries to work on this corrupted memory region. So, the information in trace files doesn't come from the corrupter. You should catch the corrupter. There are some undodumented parameter/events for that. But this may cause other problems in your system. Don't waste your time with the trace files.

regards...

Jack van Zanen wrote:

> HI
>
> *********************************
>
> >From Metalink
>
> Doc ID: Note:47411.1
> Type: REFERENCE
> Status: PUBLISHED
> Content Type: TEXT/PLAIN
> Creation Date: 26-SEP-1997
> Last Revision Date: 20-MAR-2002
>
> Note: For additional ORA-600 related information please read
> [NOTE:146580.1]
>
> PURPOSE:
> This article discusses the internal error "ORA-600 [17112]", what
> it means and possible actions. The information here is only applicable
> to the versions listed and is provided only for guidance.
>
> ERROR:
> ORA-600 [17112][a][b][c][d][e]
>
> VERSIONS:
> versions 7.3.X to 8.1.X
>
> DESCRIPTION:
>
> Oracle has detected that the magic number in a memory chunk header has
> been overwritten.
>
> This is a heap (in memory) corruption and there is no underlying data
> corruption.
>
> The error may occur in the one of the process specific heaps
> (the Call heap, PGA heap, or session heap) or in the shared heap (SGA).
>
> ARGUMENTS:
> Arg [a] Pointer to chunk header
>
> FUNCTIONALITY:
> HEAP MANAGEMENT
>
> IMPACT:
> PROCESS FAILURE
> MEMORY CORRUPTION, POSSIBLE INSTANCE FAILURE.
> NON DATA CORRUPTIVE - No underlying data corruption.
>
> SUGGESTIONS:
> This is likely to be an effect rather than the cause
> of the problem. May be due to an Operating System (OS)
> memory overwrite. Run diagnostics to check the physical
> memory on the machine and check the OS system logs.
> For repeatable occurrances, please submit the trace
> files and alert.log to Oracle Support Services for further analysis.
>
> *************************8
>
>
> GL2Z/ INF DBA
> BENLATRECHE To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> <kbenlatreche_at_lth.so cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
> natrach.dz> Subject: ORA-00600 Error
> Sent by:
> root_at_fatcity.com
>
>
> 10-04-2002 12:28
> Please respond to
> ORACLE-L
>
>
>
> HI All,
>
> We are running Oracle8.1.5 on a Netware 5 . The problem we are facing is
> that the server is going down very frequently (3 times a day).
> The error code on the Alert file shows : ORA-00600: with arguments :
> [17112], [3461574976], [], [], [], [], [], [].
>
> Oracle support did not give us any Help.
>
> We have another Database with the same configuration as above and there is
> no problem with it.
> The diffence between the two configurations is that in the first one there
> is an Forms 5 application with some tables including LON type columns and
> in
> the second there is a Forms 4.5 application without LONG columns tables.
>
> Please could someone give us any help.
>
> Best Regards
> Kamel Benlatreche
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: GL2Z/ INF DBA BENLATRECHE
> INET: kbenlatreche_at_lth.sonatrach.dz
>
> 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).
>
> ==================================================================
> De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
> uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
> vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
> derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
> Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
> volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
> voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
> verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
> worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
>
> Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
> vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
> en het origineel en eventuele kopieën te verwijderen en te vernietigen.
>
> Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
> voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
> algemene voorwaarden worden u op verzoek kosteloos toegezonden.
> =====================================================================
> The information contained in this communication is confidential and is
> intended solely for the use of the individual or entity to whom it is
> addressed. You should not copy, disclose or distribute this communication
> without the authority of Ernst & Young. Ernst & Young is neither liable for
> the proper and complete transmission of the information contained in this
> communication nor for any delay in its receipt. Ernst & Young does not
> guarantee that the integrity of this communication has been maintained nor
> that the communication is free of viruses, interceptions or interference.
>
> If you are not the intended recipient of this communication please return
> the communication to the sender and delete and destroy all copies.
>
> In carrying out its engagements, Ernst & Young applies general terms and
> conditions, which contain a clause that limits its liability. A copy of
> these terms and conditions is available on request free of charge.
> ===================================================================
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jack van Zanen
> INET: nlzanen1_at_EY.NL
>
> 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).

--
Danisment Gazi Unal
http://www.unal-bilisim.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal
  INET: dunal_at_unal-bilisim.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).