Re: ORA-00600: [2662]

Mogens I do agree that this ora-600 [2662] is in the code that handle SCN numbers, since SCN handling is used
many places in the code the stack trace that show which path throw the code you took is necessary if there
is no hits on metalink fits the problem ;-)

Mogens Nørgaard wrote:

> This response from Oracle is not a good one. Kirti is on the right
> track regarding the SCN stuff as far as I remember. Other than that, I
> know that Peter Gram and Bjorn Engsig (among a lot of other guys)
> might be able to suggest something, so I've CC'ed them.
>
> I have my own law on ora-600s: If you supply all the required
> information (tracefiles, alertlogs, repro-case, etc.) chances are
> Support is not gonna need them. If you miss out just one of those
> things, chances are Support will tell you they cannot proceed without
> that vital piece of information. In other words: There's no hope :-)))
>
> Could also be related to db-links between v7 and v8...
>
> But back to the good questions from Kirti: Have you set the funny
> _-parameters he mentions?
>
>
> Mogens
>
> PS: I do beleive there are ways around this with an alter system or
> alter session command where you bump the SCN some <level>, but
> Peter/Bjorn/someone can confirm this.
>
> Sinardy Xing wrote:
>
>> Hi guys,
>>
>>
>> This is what I get from Oracle
>>
>> ==============================================================
>>
>> Hi Sinardy,
>>
>> I've check several bug looking for the cause of this problem.
>> However, what I've found is that Development could not diagnosis the
>> problem other than the possibily hat there was some memory corruption
>> that gave a bad SCN. Although, they could "sometimes" determine the
>> root cause prior to the problem occurring by using certain parameters
>> were set in the database.
>> Those parameters are:
>>
>> a)_db_block_cache_protect.
>> b)_db_block_checking
>> c)DB_BLOCK_CHECKSUM
>> They also recommended running dbverify on all datafiles tomake sure
>> all files are clean on disk.
>>
>> IMPORTANT
>> ==========
>> These parameter may help later determine what cause the ORA-600
>> [2662] (and it's not for certain that a cause can be found). They
>> parameters does have some performance overhead, but unfortunately
>> this is the only way that can help in catching and we have to wait
>> until the problem happens again.
>>
>> So, the bottomline is there is no list of reason for why this error
>> occuring other than the error occurs when a data block SCN is ahead
>> of the current SCN.
>>
>> Sorry Sinardy, we don't have more information.
>>
>> Thanks!
>> Wonda
>>
>> =================================================================
>>
>> What can I do, help me please...
>>
>>
>> Sinardy
>>
>>
>>
>> -----Original Message-----
>> Sent: 07 January 2003 13:09
>> To: Multiple recipients of list ORACLE-L
>>
>>
>> Sinardy
>>
>> ORA-0600 is really an encoded message from Oracle that reads :
>>
>> 'Thank you for helping find yet another bug in our software. You can
>> now release your sphincter (some herbal tea might help), especially
>> if this has cropped up in production. We suggest you do not try to
>> solve this one by yourself, which is why the arguments are supplied.
>> Kindly call OWWS with your CSI number, tell them exactly which
>> version and platform you ran this on, and if we have encountered this
>> previously, there is a small chance that we could have a patch. If
>> not, please do not hold your breath waiting, while we assign this to
>> an experienced software engineer, or perhaps a recent college grad,
>> in which case, you're toast !' However, we will ask you to ftp up to
>> our ftp site loads of dumps and traces which might prove useful.
>>
>> Seriously though, ORA-0600 are mysteries. Your best chance is to get
>> Tim Gorman to look at it, he has an amazing knowledge of these. And
>> of course, Tim should not work for free either. (Tim, it was 10%
>> commission we agreed on, right ? ) :-)
>>
>> Ferenc Mantfeld
>>
>> -----Original Message-----
>> From: Sinardy Xing [SMTP:SinardyXing_at_bkgcomsvc.com]
>> Sent: Tuesday, January 07, 2003 2:34 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: ORA-00600: [2662]
>>
>> Hi all,
>>
>> I hit by this error
>>
>> ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0],
>> [54173017], [16781180], [], []
>>
>>
>> Can you help me where to find info about this error
>>
>>
>>
>>
>> Sinardy
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: Sinardy Xing
>> INET: SinardyXing_at_bkgcomsvc.com
>>
>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> San Diego, California -- Mailing list and web hosting services
>> ---------------------------------------------------------------------
>> 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).
>>
>>
>>
>
>
>

-- 
Peter Gram, Miracle A/S
Phone : +45 2527 7107, Fax : +45 4466 8856
mailto:peter.gram@MiracleAS.dk - http://MiracleAS.dk





Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii"
Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.

--------------ms020207040900090708010008--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).



application/x-pkcs7-signature attachment: smime.p7s