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: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Wed, 21 Apr 2004 20:16:58 +0200
Message-ID: <iied809sbmslkuidui61v756su8b4qg2sp@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]
>
>error.
>
>Besides of calling Oracle support (which we'll
>do in a few minutes I think) and checking
>hardware (which is currently running),
>has anyone any further suggestions on possible
>reasons and methods to get it up running again?
>
>Our current ideas:
>- As the machine boots up fine, we'll back up all
> datafiles, archive logs, trace files, control files
> and scripts.
> Maybe during copy, one of these files shows up to
> be corrupt
>
>- Depending on what the support says, we'll try to
> save at least the main tablespace of the db
> Any suggestions on how to achieve this?
>
>Best regards
>
>Olaf

Why do you think the database doesn't run anymore? Any sign pointing to that fact in eg. the alert log?
The second argument in the ora-600 points to a memory leak. Nothing more, nothing less.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Apr 21 2004 - 13:16:58 CDT

Original text of this message

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