Re: Instance down due to ORA-00476

From: <shweta.kaparwan_at_googlemail.com>
Date: Wed, 4 Feb 2009 09:31:45 -0800 (PST)
Message-ID: <6b1caa03-fb0b-4337-8868-c97b3809d3b5_at_m4g2000vbp.googlegroups.com>



On Feb 4, 4:35 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

Thanks Steve

We have raised the SR with oracle.

Looks it is related with 2 phase commit.

I count(*) of dba_2pc_pending is zero now. Received on Wed Feb 04 2009 - 11:31:45 CST

Original text of this message