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@chi.navtech.com>
Sent by: ml-errors@fatcity.com
12/05/2003 08:34 AM
Please respond to ORACLE-L
|
To: Multiple recipients of list ORACLE-L <ORACLE-L@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@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@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@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@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:
INET: Jared.Still_at_radisys.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).
Received on Fri Dec 05 2003 - 10:49:24 CST
