Re: Anyone ever seen ORA-00600

ericl_at_community.net writes:

>In article <207373488wnr_at_kane.demon.co.uk>,
> Mike J Cox <mike_at_kane.demon.co.uk> wrote:
>>
>>>
>>> I am getting the following error
>>>
>>> ERROR: ORA-00600: internal error code, arguments [512],[],[],[],[],[],
>>> [],[]
>>> ORA-00600: internal error code, arguments [504],[2281737468],[64],[6],
>>> [library cache pin],[],[],[]
>>>
>>
>>Ring ORACLE support, they can usually tell you what the numbers mean,
 sometimes....
>>
 

>If you are running on a UNIX platform, from the UNIX prompt try
 

>oerr ora 600

While oerr is fine, a 600 error means that Oracle has got itself into a HORRIBLE knot. It is just about the worst error there is.  

IF YOU EVER GET AN ORA-0600 WRITE DOWN ALL THE MESSAGES, KICK EVERYONE OFF THE DATABASE, GRAB YOUR MOST RECENT BACKUP AND PROTECT IT WITH YOUR LIFE. Then bounce the database and/or the machine. If you get no joy with that, call Oracle. If the data since the last archive is important, then about the only people who can get it back are techos. If you do not have Oracle support, you may even have to rebuild the database from scratch.

And if you do not have a recent backup, give your DBA high speed cranial lead therapy.

David

--
Oracle FAQ and archives maintainer
orafaq_at_bf.rmit.edu.au                 (private mail to dtb_at_bf.rmit.edu.au)
http://www.bf.rmit.edu.au/OracleFAQ   ftp://ftp.bf.rmit.edu.au/pub/Oracle
-- NOT TO BE ARCHIVED IN ANY MANNER ON MICROSOFT NETWORK --