Re: Woohooo An ORA-600

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Tue, 06 Mar 2001 04:09:45 -0800
Message-ID: <F001.002C4A11.20010306032705@fatcity.com>

As i sat around and read the kernel source code(hahaha just kidding, although some days it would be easier to do that than work with metalink), here is what metalblank came up with:

       Note:109595.1
       ALERT: ORA-04045 and ORA-600 [4882]on
       startup after applying 8.1.6.1.x patch
Type: 
       ALERT
Status: 
       PUBLISHED

                                             Content Type: 
                                                             TEXT/PLAIN
                                             Creation Date: 
                                                             22-MAY-2000
                                             Last Revision Date: 
                                                             31-OCT-2000
                                             Language: 
                                                             USAENG

ORA-04045 and ORA-600 [4882] on startup after applying 8.1.6.1.x patch to 8.1.6.x
or upgrading from 8.1.5.X to 8.1.6.0.0

Versions affected

Oracle 8i 8.1.6.0.0, patch 8.1.6.1.x

Platforms Affected

ALL Description

After upgrading to 8.1.6.0 or applying 8.1.6.1.x patch, ORA-600 errors may appear in the alert.log file.

Likelihood of Occurrence

This will occur everytime a database, with Java enabled, is upgraded from 8.1.5.X to 8.1.6.0.0 or patch 8.1.6.1.x is applied.

Symptoms

After the upgrade, every startup or shutdown of the database may report the following
to the alert.log:

ORA-04045: errors during recompilation/revalidation of SYS.AURORA$SERVER$STARTUP
ORA-00600: internal error code, arguments: [4882], [52571764],
[67355404], [52438196], [],
[], [], []

(the arguments of the ora-600 after the 4882 may vary on your system)

Workaround

No current workaround known.
Please note this is a non-blocking ORA-600 error that does not affect the
database internals, nor does it affect data integrity.

Patches

No patch available at the moment.
Solution scheduled for 8.1.6.2 patchset

NOT SURE IF THIS IS YOUR PROBLEM FOR SURE, if you want, send me the trace file.

Joe
Mark Leith wrote:

> 
> Hi Guys & gals,
> 
> Today - I got my very first ORA-600 error - Woooohooooo, I tell ya guys I'm
> so excited.. lol..
> 
> Now Because this is a test instance I don't really give a stuff whether I
> lose it or not, it seems to be up and running just fine, without any real
> problems. The only annoyance with having to rebuild it is having to set it
> all up again, as I don't back the damn thing up :>
> 
> Now I'm not even going to even try and log on to "Megablank" to look this
> up, and lowly little me couldn't get access anyway: so I thought I would
> field this one to the list to see if any of you guys have seen this version
> of the fabled error before, so here it is:
> 
> Errors in file C:\Oracle\admin\SALES\udump\ORA00520.TRC:
> ORA-00600: internal error code, arguments: [4882], [48415556], [97653212],
> [48293020], [], [], [], []
> 
> Tue Mar 06 09:02:09 2001
> Errors in file C:\Oracle\admin\SALES\udump\ORA00520.TRC:
> ORA-04045: errors during recompilation/revalidation of
> SYS.AURORA$SERVER$STARTUP
> ORA-00600: internal error code, arguments: [4882], [48415556], [97653212],
> [48293020], [], [], [], []
> 
> Pretty isn't it? Any "easy" way of fixing this before I send my database to
> that big recycle bin in the sky? Actually it may be a good thing, then I
> could try and get OEM 2.1 up and running again - But that's another thread
> :)
> 
> All insight appreciated..
> 
> Regards
> 
> Mark
>

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  INET: teci_at_oracle-dba.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 Mar 06 2001 - 06:09:45 CST