| 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: Killing pmon service - does Oracle backout?
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C07FD8.A04D2E10
Content-Type: text/plain;
charset="iso-8859-1"
Tony, could you not do a shutdown abort?
Killing pmon or smon is pretty much the equivalent of a shutdown abort (instance crash). 99.99% of the time the database will clean itself up when you bring it back up after a shutdown abort. Only once has a shutdown abort put one of my (production) databases into recovery mode.
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
-----Original Message-----
From: Barker, Tony [mailto:tbarker_at_doit.state.in.us]
Sent: Tuesday, January 16, 2001 9:37 AM
To: Multiple recipients of list ORACLE-L
Subject: Killing pmon service - does Oracle backout?
Hi!!,
I recently hosed our test system and could not get into any utility applications (SQLPLUS, SVRMGRL, ..) and I needed to bring down some hung instances. (The system is Sun Solaris release 2.6 using Oracle 8.1.6) I ended up canceling the PMON task of the various instances to get them to come down. They all terminated and I was sure that I was going to have to do a recovery to get them to come back up. To my surprise all the instances came up fine after getting everything functionable.
Does anyone know what happens when you cancel PMON that allowed this to happen? Did SMON clean things up before the instances terminated? I hope I don't have a false sense of comfort!?
Thanks in advance for your input!!!
Tony Barker
DBA - State of Indiana
tbarker_at_doit.state.in.us (317)232-0719
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barker, Tony INET: tbarker_at_doit.state.in.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). ------_=_NextPart_001_01C07FD8.A04D2E10 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Tue Jan 16 2001 - 10:23:14 CST
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Killing pmon service - does Oracle backout?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Tony, could you not do a shutdown abort? =
</FONT>
</P>
<P><FONT SIZE=3D2>Killing pmon or smon is pretty much the equivalent of =
a shutdown abort (instance crash). 99.99% of the time the = database will clean itself up when you bring it back up after a = shutdown abort. Only once has a shutdown abort put one of my = (production) databases into recovery mode. </FONT></P>
<BR>
<P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT>
<BR><FONT SIZE=3D2>Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D2>Qode.com</FONT>
<BR><FONT SIZE=3D2>4850 North State Road 7</FONT>
<BR><FONT SIZE=3D2>Suite G104</FONT>
<BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT>
</P>
<P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D2>F: 954.484.2933 </FONT>
<BR><FONT SIZE=3D2>C: 954.658.5849</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" =
TARGET=3D"_blank">http://www.qode.com</A></FONT>
</P>
<P><FONT SIZE=3D2>"The information contained herein does not =
express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."</FONT></P>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Barker, Tony [<A =
HREF=3D"mailto:tbarker_at_doit.state.in.us">mailto:tbarker_at_doit.state.in.us=
</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, January 16, 2001 9:37 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Killing pmon service - does Oracle =
backout?</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>Hi!!,</FONT>
</P>
<P> <FONT SIZE=3D2>I recently =
hosed our test system and could not get into any utility</FONT>
<BR><FONT SIZE=3D2>applications (SQLPLUS, SVRMGRL, ..) and I needed to =
bring down some hung</FONT>
<BR><FONT SIZE=3D2>instances. (The system is Sun Solaris release 2.6 =
using Oracle 8.1.6) I</FONT>
<BR><FONT SIZE=3D2>ended up canceling the PMON task of the various =
instances to get them to</FONT>
<BR><FONT SIZE=3D2>come down. They all terminated and I was sure =
that I was going to have to</FONT>
<BR><FONT SIZE=3D2>do a recovery to get them to come back up. To =
my surprise all the instances</FONT>
<BR><FONT SIZE=3D2>came up fine after getting everything =
functionable.</FONT>
</P>
<P> <FONT SIZE=3D2>Does =
anyone know what happens when you cancel PMON that allowed this</FONT>
<BR><FONT SIZE=3D2>to happen? Did SMON clean things up before the =
instances terminated? I</FONT>
<BR><FONT SIZE=3D2>hope I don't have a false sense of comfort!?</FONT>
<BR> =20
<BR> <FONT SIZE=3D2>Thanks in =
advance for your input!!!</FONT>
</P>
<P><FONT SIZE=3D2>Tony Barker</FONT>
<BR><FONT SIZE=3D2>DBA - State of Indiana</FONT>
<BR><FONT SIZE=3D2>tbarker_at_doit.state.in.us (317)232-0719</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Barker, Tony</FONT>
<BR><FONT SIZE=3D2> INET: tbarker_at_doit.state.in.us</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
 |
 |