Oracle-L: RE: ORA-00600: [2662]

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Mon, 06 Jan 2003 22:28:37 -0800
Message-ID: <F001.005283C9.20030106222837@fatcity.com>

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: mantfield
INET: mantfield_at_connexus.net.au

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

--

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