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, [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). > > > > 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).
