Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-600

Re: ORA-600

From: Ed Stevens <nospam_at_noway.nohow>
Date: Wed, 21 Apr 2004 15:46:57 -0500
Message-ID: <bpmd801ijerdnhra16tdtu2pmm49kr0oni@4ax.com>


On Wed, 21 Apr 2004 20:23:25 +0200, "Olaf Musch" <Olaf.Musch_at_computer.org> wrote:

>"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> schrieb im Newsbeitrag
>news:iied809sbmslkuidui61v756su8b4qg2sp_at_4ax.com...
>> On Wed, 21 Apr 2004 16:26:25 +0200, "Olaf Musch"
>> <Olaf.Musch_at_computer.org> wrote:
>>
>> >Hi all,
>> >
>> >on one of our databases (9.2.0.4, W2K server, english)
>> >we've just received an
>> >
>> >ORA-00600 internal error [733] [pga heap]
>> >
>> Why do you think the database doesn't run anymore? Any sign pointing
>> to that fact in eg. the alert log?
>
>Well, on startup of the machine, the db doesn't
>come up anymore automatically.
>
>Tryin to start it up via SQL*Plus results in this
>error and the db still not running.
>
>Signs enough?
>
>> The second argument in the ora-600 points to a memory leak. Nothing
>> more, nothing less.
>>
>Well that's what we were assuming, thanks for the hint.
>
>Do you have any recommendations what to try?
>
>Regards
>
>Olaf

The basic rule on ora-0600 is 'open a TAR'. However, if you have a MetaLink account there is an ORA-600 Argument Lookup page that will allow you to key in the first numeric argument of the ora-0600 and also paste in the call stack from the trace file, and it will return some more info that might alleviate the need to open a TAR.

In the MetaLink not-so-quick search, do a search on "all of the words" "ora-0600 lookup". When I just now did that, it was the first hit on the list. I have it bookmarked at

http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=153788.1&blackframe=0 Received on Wed Apr 21 2004 - 15:46:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US