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, [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 12/05/2003 08:34 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
