| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Woohooo An ORA-600
I have a similar sort of problem on 8.1.6 database which is Java enabled. Every time I startup or shutdown the database trace files are created and also errors in the alert log file. Trace file message is like this - although when I checked select * from dba_objects where object_name like '%rdbms/Server'- oracle/aurora/rdbms/Server does exist.
:
Error in executing triggers on instance shutdown
*** 2001-02-21 02:00:03.958
ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1 ORA-29540: class oracle/aurora/rdbms/Server does not exist ORA-06512: at "SYSTEM.DBMS_JAVA", line 0 ORA-06512: at line 2
>From: "Mark Leith" <mark_at_cool-tools.co.uk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Woohooo An ORA-600
>Date: Tue, 06 Mar 2001 04:21:11 -0800
>
>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
>also send the HELP command for other information (like subscribing).
><< ORA00520.TRC >>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erma Fernando INET: cecfernan_at_hotmail.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 - 12:06:31 CST
 |
 |