RE: Woohooo An ORA-600

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Tue, 06 Mar 2001 06:36:54 -0800
Message-ID: <F001.002C4A69.20010306042125@fatcity.com>

Hi Joe,

Thanks for this, it seems it is this exactly, as it is being reported in the alert log on every instance of a startup. Attached is the trace file for your review - looks like a complete load of rubbish to me:)

Thanks for your help..

Regards

Mark

-----Original Message-----
Testa
Sent: Tuesday, March 06, 2001 11:27
To: Multiple recipients of list ORACLE-L

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

Received on Tue Mar 06 2001 - 08:36:54 CST