Re: HELP: ORA-00600: internal error code

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Mon, 2 Sep 2002 19:53:41 +0100
Message-ID: <3d73b3b8$0$8507$cc9e4d1f@news.dial.pipex.com>

"Anton Buijs" <aammbuijs_at_xs4all.nl> wrote in message news:aktidr$qcq$1_at_news1.xs4all.nl...
> Error means that the DBWR process can't get an exclusive lock on one of
the
> files.

Where do you get this from? According to the 0600 lookup utility on metalink argument 2806 is 'not yet published'. Moreover I'm pretty sure that when Oracle can't lock one of the files *ahem* someone set backup exec to backup open oracle files *ahem*, the alert log gives a message remarkably similar to 'cannot lock file# file in use by another process?.'

What 0600 means is 'something bad happened but I don't know what so I'll just dump the stack to disk so you can send it off to those nice guys at support'. And that of course is what should be done.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

Received on Mon Sep 02 2002 - 13:53:41 CDT