| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: background process "LGWR" did not start
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C3BB52.F2207D56"
------_=_NextPart_001_01C3BB52.F2207D56
Content-Type: text/plain;
charset="iso-8859-1"
also 'sysresv' will show which shared memory segments and semaphore sets belong to an instance.
-----Original Message-----
Sent: Friday, December 05, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L
In regards to Bambi's comments about having a single instance on the server,
this situation gets more complex if you have several instances on a server.
There's also the possibility that the instance(s) shared memory is in more than one segment.
You can use ipcs and oradebug to decipher which memory segments belong to which instance. Google for ipcs and oradebug, several helpful references
showed up when I tried it.
HTH Jared
"Bellow, Bambi" <bbellow_at_chi.navtech.com> Sent by: ml-errors_at_fatcity.com
12/05/2003 08:34 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
cc:
Subject: RE: background process "LGWR" did not start
Hi John!
When I've run into this problem it was because there was a memory segment being forced open. If you have the same issue, I can hep. First, assuming that you're on Unix (if you're not, please ignore the rest of this email and just have a lovely day), and that your database is down (otherwise, if you wanted to do a shutdown abort, that wouldn't be such a bad thing), you can do an
ipcs -mA
If that was the only instance on your box, the rest is pretty easy, cuz the offending segment is the only one owned by oracle in the list. If it wasn't, and there are other oracle segments on the box, you have to find out which one is your guy. The memory segments associated with a particular instance should have very similar (but not exactly the same) CTIMEs. If there is one way out of whack, that's your guy. Now, this is where my memory gets a little fuzzy (age, doncha know?)... if the instances started up at nearly exactly the same time for some reason, you are looking for a "0" in the <insert hem and haw> segsz(?) column (anybody remember fersher on this one?). By now, you should know which memory segment to kill.
To kill the offending memory segment, do an
ipcrm -m <segment>
on it. You, of course, want to be exceedingly careful here, and just assume that all the usual disclaimers apply. If you kill the wrong segment, your other database is not going to be very happy about it.
But assuming you killed the right segment, your database with the LGWR problem should be well and truly down. Bring 'er on up and the LGWR process should come up just fine.
Bambi.
-----Original Message-----
Sent: Thursday, December 04, 2003 8:34 AM
To: Multiple recipients of list ORACLE-L
Anyone know what might be causing this error? Oracle 8.1.7 on Solaris.
background process "LGWR" did not start
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: john.dunn_at_sefas.co.uk Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: bbellow_at_chi.navtech.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C3BB52.F2207D56 Content-Type: text/html; charset="iso-8859-1"Received on Fri Dec 05 2003 - 11:14:31 CST
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3105.105" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=43161117-05122003>also
'sysresv' will show which shared memory segments </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=43161117-05122003>and
semaphore sets belong to an instance.</SPAN></FONT></DIV>
<DIV> </DIV>
<P><FONT size=2>----<BR>Matt Adams - GE Appliances -
matt.adams_at_appl.ge.com<BR>Their fundamental design flaws are completely<BR>hidden by their superficial design flaws.<BR> - Douglas Adams</FONT> </P>
<DIV> </DIV>
<DIV class=OutlookMessageHeader><FONT face="Times New Roman"
size=2>-----Original Message-----<BR><B>From:</B> Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]<BR><B>Sent:</B> Friday, December 05, 2003 11:49 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: background process "LGWR" did not start<BR><BR></FONT></DIV><BR><FONT face=sans-serif size=2>In regards to Bambi's comments about having a single instance on the server,</FONT> <BR><FONT face=sans-serif size=2>this situation gets more complex if you have several instances on a server.</FONT>
<BR><BR><FONT face=sans-serif size=2>There's also the possibility that the
instance(s) shared memory is in more</FONT> <BR><FONT face=sans-serif size=2>than one segment.</FONT> <BR><BR><FONT face=sans-serif size=2>You can use ipcs and oradebug to decipher which memory segments belong</FONT> <BR><FONT face=sans-serif size=2>to which instance. Google for ipcs and oradebug, several helpful references</FONT> <BR><FONT face=sans-serif size=2>showed up when I tried it.</FONT> <BR><BR><FONT face=sans-serif size=2>HTH</FONT>
<BR><BR><FONT face=sans-serif size=2>Jared</FONT> <BR><FONT face=sans-serif
size=2><BR></FONT><BR><BR><BR>
<TABLE width="100%">
<TBODY> <TR vAlign=top> <TD> <TD><FONT face=sans-serif size=1><B>"Bellow, Bambi" <bbellow_at_chi.navtech.com></B></FONT> <BR><FONT face=sans-serif size=1>Sent by: ml-errors_at_fatcity.com</FONT> <P><FONT face=sans-serif size=1> 12/05/2003 08:34 AM</FONT> <BR><FONT face=sans-serif size=2> </FONT><FONT face=sans-serif size=1>Please respond to ORACLE-L</FONT> <BR></P> <TD><FONT face=Arial size=1> </FONT><BR><FONT face=sans-serif size=1> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com></FONT> <BR><FONT face=sans-serif size=1> cc: </FONT> <BR><FONT face=sans-serif size=1> Subject: RE: background process "LGWR" did not start</FONT></TR></TBODY></TABLE><BR><BR><BR><FONT face="Courier New" size=2>Hi John!<BR><BR>When I've run into this problem it was because there was a memory segment<BR>being forced open. If you have the same issue, I can hep. First, assuming<BR>that you're on Unix (if you're not, please ignore the rest of this email and<BR>just have a lovely day), and that your database is down (otherwise, if you<BR>wanted to do a shutdown abort, that wouldn't be such a bad thing), you can<BR>do an <BR><BR>ipcs -mA<BR><BR>If that was the only instance on your box, the rest is pretty easy, cuz the<BR>offending segment is the only one owned by oracle in the list. If it<BR>wasn't, and there are other oracle segments on the box, you have to find out<BR>which one is your guy. The memory segments associated with a particular<BR>instance should have very similar (but not exactly the same) CTIMEs. If<BR>there is one way out of whack, that's your guy. Now, this is where my<BR>memory gets a little fuzzy (age, doncha know?)... if the instances started<BR>up at nearly exactly the same time for some reason, you are looking for a<BR>"0" in the <insert hem and haw> segsz(?) column (anybody remember fersher on<BR>this one?). By now, you should know which memory segment to kill. <BR><BR>To kill the offending memory segment, do an <BR><BR>ipcrm -m <segment><BR><BR>on it. You, of course, want to be exceedingly careful here, and just assume<BR>that all the usual disclaimers apply. If you kill the wrong segment, your<BR>other database is not going to be very happy about it.<BR><BR>But assuming you killed the right segment, your database with the LGWR<BR>problem should be well and truly down. Bring 'er on up and the LGWR process<BR>should come up just fine.<BR><BR>Bambi.<BR><BR>-----Original Message-----<BR>Sent: Thursday, December 04, 2003 8:34 AM<BR>To: Multiple recipients of list ORACLE-L<BR><BR><BR>Anyone know what might be causing this error? Oracle 8.1.7 on Solaris.<BR><BR>background process "LGWR" did not start<BR><BR><BR>-- <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.net<BR>-- <BR>Author: John Dunn<BR> INET: john.dunn_at_sefas.co.uk<BR><BR>Fat City Network Services -- 858-538-5051 http://www.fatcity.com<BR>San Diego, California -- Mailing list and web hosting services<BR>---------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).<BR>-- <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.net<BR>-- <BR>Author: Bellow, Bambi<BR> INET: bbellow_at_chi.navtech.com<BR><BR>Fat City Network Services -- 858-538-5051 http://www.fatcity.com<BR>San Diego, California -- Mailing list and web hosting services<BR>---------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT face="Courier New" size=2>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).<BR></FONT><BR><BR></BODY></HTML> ------_=_NextPart_001_01C3BB52.F2207D56-- ------=_NextPartTM-000-1204f3b8-fef5-429b-8b9c-01c57c46defd-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adams, Matthew (GECP, MABG, 088130) INET: MATT.ADAMS_at_APPL.GE.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |