Re: ORA-00470: LGWR process terminated with error
Date: Wed, 10 Mar 2010 06:45:43 -0800 (PST)
On Mar 10, 9:02 am, Johne_uk <edg..._at_tiscali.co.uk> wrote:
> On 10 Mar, 13:48, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> > On Wed, 10 Mar 2010 04:07:48 -0800, Johne_uk wrote:
> > > 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 ?
> > Let me see whether I understood you correctly: Oracle support is trying
> > to fix your issue for weeks, they presumably have all the trace files,
> > core files and RDA output but are unable to determine the exact cause of
> > the problem despite having all this information and you are asking us to
> > guess what the problem is without even knowing the version of the RDBMS
> > and Solaris? No problem, I can do that. The answer to your problem is the
> > number 42.
> Actually I was looking for some assistance on determining what is
> killing the LGWR process. Oracle do not provide OS support ! I thought
> the question was clear enough but obviously not. Thanks for the
> comment though as its must have wasted five minutes.- Hide quoted text -
> - Show quoted text -
I understand you are looking for assistance however you failed to provide sufficient information in your vague problem description to allow anyone to help. Yes, the LGWR process is dying; is it accompanied by an ORA-07445 error? Is there any indication in the resulting trace files that Solaris is at fault? Which release of Oracle are you running? Yes, I know, you blurted out the wonderful marketing speak of 10g but that umbrella covers two major releases plus 8 patch levels with major changes between the two so please do us a favor and take the time and effort to post that information to 4 or 5 numbers (10.1.0.4, 10.2.0.3, etc.). Also post the version of Solaris this database is running on, including the curent patch level (a uname -a can provide that information). As noted in a previous post you've supplied far more information to Oracle and they, apparently, can't solve the problem; why would you even think that giving us such sketchy details would allow us to magically provide an answer that Oracle (who has far more data than we do) cannot?
This is a help forum, not a carnival sideshow; we cannot pull answers out of nothing more than thin air and thin air, really, is all you've provided us. You have no right to complain regarding the response first given you since you ambiguously described your problem and expected detailed assistance to be forthcoming.
Supply much more information and you may find better help with your issue.
David Fitzjarrell Received on Wed Mar 10 2010 - 08:45:43 CST