Re: ORA-00470: LGWR process terminated with error

From: Steve Howard <>
Date: Wed, 10 Mar 2010 18:52:30 -0800 (PST)
Message-ID: <>

On Mar 10, 7:07 am, Johne_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

You need to ask for a better analyst, and that isn't being facetious. The ability to predict the quality of the analyst you can get at Oracle support is about as reliable as their support site.

Seriously, ask for the SR to be escalated/duty managed. Received on Wed Mar 10 2010 - 20:52:30 CST

Original text of this message