Re: ORA-00470: LGWR process terminated with error
- From: Johne_uk <edgarj@xxxxxxxxxxxxx>
- Date: Wed, 10 Mar 2010 06:55:28 -0800 (PST)
On 10 Mar, 14:45, ddf <orat...@xxxxxxx> wrote:
On Mar 10, 9:02 am, Johne_uk <edg...@xxxxxxxxxxxxx> wrote:
On 10 Mar, 13:48, Mladen Gogala <gogala.mla...@xxxxxxxxx> 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
Understood David I will follow up with more information
cheers
.
- References:
- ORA-00470: LGWR process terminated with error
- From: Johne_uk
- Re: ORA-00470: LGWR process terminated with error
- From: Mladen Gogala
- Re: ORA-00470: LGWR process terminated with error
- From: Johne_uk
- Re: ORA-00470: LGWR process terminated with error
- From: ddf
- ORA-00470: LGWR process terminated with error
- Prev by Date: Re: ORA-00470: LGWR process terminated with error
- Next by Date: Re: ORA-00470: LGWR process terminated with error
- Previous by thread: Re: ORA-00470: LGWR process terminated with error
- Next by thread: Re: ORA-00470: LGWR process terminated with error
- Index(es):
Relevant Pages
|
