Re: Instance down due to ORA-00476

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Wed, 4 Feb 2009 08:35:22 -0800 (PST)
Message-ID: <b34c2972-a58b-4efa-8f96-96ccc9daa584_at_v5g2000pre.googlegroups.com>



On Feb 4, 11:28 am, shweta.kapar..._at_googlemail.com wrote:
> Hi
>
> database instance went  down with the below mentioned error.
>
> Wed Feb  4 15:26:30 2009
> Errors in file /abc/<inst>_pmon_10200.trc:
> ORA-00476: RECO process terminated with error
> Wed Feb  4 15:26:30 2009
> PMON: terminating instance due to error 476
> Wed Feb  4 15:26:30 2009
> System state dump is made for local instance
> Wed Feb  4 15:26:30 2009
> Trace dumping is performing id=[cdmp_20090204152630]
> Wed Feb  4 15:26:35 2009
> Instance terminated by PMON, pid = 20209
>
> DB was restated successfully.
>
> Env Details:
> Oracle 9.2.0.6
> OS - HP Ux 11.23
>
> Any help .
> many thanks
>
> Regards
> Shweta

Hi Shweta,

I would open an SR whenever I saw something like this, as it is not normal behaviour. There is a note on metalink for the RECO error which you also may want to review (336208.1) as it may apply.

HTH, Steve Received on Wed Feb 04 2009 - 10:35:22 CST

Original text of this message