Re: ORA-00470: LGWR process terminated with error
Date: Wed, 10 Mar 2010 09:02:33 -0800 (PST)
On Mar 10, 4:07 am, Johne_uk <edg..._at_tiscali.co.uk> wrote:
> 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.
Charles gave more details, but let me emphasize this: if the issue is one of OS resources, it will surely affect one more than the other, possibly the second one started.
You might want to google for dtrace, especially as it applies to Oracle. Don't have time to look just now, but IIRC Tanel Poder, James Morle and Kerry Osborne have some things about dtrace on their blogs.
Hey, oracle wants sun admins for aces: http://www.sun.com/bigadmin/home/index.jsp
> 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.
Performance of a crashed instance is always the worst degradation.
-- _at_home.com is bogus. http://stevejmitchell.blogspot.com/2009/07/computer-programming-as-stochastic-art.htmlReceived on Wed Mar 10 2010 - 11:02:33 CST