| 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
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).
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). Received on Fri Dec 05 2003 - 10:34:24 CST
 |
 |