Re: ORA-00470: LGWR process terminated with error
From: Alberto Frosi <alberto.frosi_at_gmail.com>
Date: Thu, 11 Mar 2010 03:28:14 -0800 (PST)
Message-ID: <4493bec9-e855-41b6-8e84-a24c932cf04f_at_j27g2000yqn.googlegroups.com>
On 10 Mar, 13:07, Johne_uk <edg..._at_tiscali.co.uk> wrote:
> Hi,
>
> I am currently running two Oracle 10G instances from a single Solaris
> M4000 server. Every few days one of the instances crashes with the
> following error and has to be restarted.
>
> ORA-00470: LGWR process terminated with error
> PMON: terminating instance due to error 470
>
> I have spend weeks running various trace files etc with Oracle support
> and they are basically clueless as to what is the cause. They are
> saying it is a Solaris OS issue but surely this would affect both
> instances and not just one.
>
> Essentially something is killing the LGWR process and the instance is
> shutting itself down. I think the way ahead is to try and find out
> what is killing this process but I'm not sure how to go about this and
> worried that any logging may degrade server performance.
>
> Can anybody offer any suggestions ?
>
> Thanks in advance
> John
Date: Thu, 11 Mar 2010 03:28:14 -0800 (PST)
Message-ID: <4493bec9-e855-41b6-8e84-a24c932cf04f_at_j27g2000yqn.googlegroups.com>
On 10 Mar, 13:07, Johne_uk <edg..._at_tiscali.co.uk> wrote:
> Hi,
>
> I am currently running two Oracle 10G instances from a single Solaris
> M4000 server. Every few days one of the instances crashes with the
> following error and has to be restarted.
>
> ORA-00470: LGWR process terminated with error
> PMON: terminating instance due to error 470
>
> I have spend weeks running various trace files etc with Oracle support
> and they are basically clueless as to what is the cause. They are
> saying it is a Solaris OS issue but surely this would affect both
> instances and not just one.
>
> Essentially something is killing the LGWR process and the instance is
> shutting itself down. I think the way ahead is to try and find out
> what is killing this process but I'm not sure how to go about this and
> worried that any logging may degrade server performance.
>
> Can anybody offer any suggestions ?
>
> Thanks in advance
> John
For example for the better analysis i ask, the LGWR process it's always the same for the same instance or is it ramdom? because otherwise could be a hundred of variables for OS for DB. Received on Thu Mar 11 2010 - 05:28:14 CST