Re: background process "LGWR" did not start

Maybe so. I've been in this same situation before where several business critical databases are on a single server.

Rebooting was simply not an option. Isolate which memory segments to remove, remove them, restart the database.

Jared

On Fri, 2003-12-05 at 10:09, Mladen Gogala wrote:
> No, but in this case, it's exactly what they did. Good, old <ctrl><alt><del>
> saved the day. I just thought I might suggest it. After all, they did
> have an oracle version of BSOD.
> On 12/05/2003 12:59:25 PM, Jared Still wrote:
> > Rebooting is not always an option.
> >
> > On Fri, 2003-12-05 at 09:04, Mladen Gogala wrote:
> > > I can almost guarantee that the issue will go away if you reboot the machine.
> > > I cannot fathom how would shared memory segments survive reboot.
> > >
> > > On 12/05/2003 11:49:24 AM, Jared.Still_at_radisys.com wrote:
> > > > 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).
> > > >
> > > >
> > > >
> > >
> > > Mladen Gogala
> > > Oracle DBA
> > >
> > >
> > >
> > > Note:
> > > This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
> > > Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Mladen Gogala
> > > INET: mladen_at_wangtrading.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).
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jared Still
> > INET: jkstill_at_cybcon.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).
> >
>
> Mladen Gogala
> Oracle DBA
>
>
>
> Note:
> This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mladen_at_wangtrading.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).