| 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: RE: ORA-03113
<SPAN
class=347005418-29112001>Lisa,
<SPAN
class=347005418-29112001>
ps -fu
oracleSID ----- command would not work. The reason is when you -u option
with ps, it looks for the user by name mentioned. In this case, there would not
be any user by name oracleSID (most likely). All the oracle processes
would be owned by the user oracle.
<SPAN
class=347005418-29112001>
<SPAN
class=347005418-29112001>Now, the following modification for the command
might work. I did not test this completely.
<SPAN
class=347005418-29112001>
ps -fu
oracle | grep -v SID | grep -v PPID | awk '{ print $2; }' | xargs kill
-9
<SPAN
class=347005418-29112001>
<SPAN
class=347005418-29112001>Rao
<FONT face=Tahoma
size=2>-----Original Message-----From: Koivu, Lisa
[mailto:lisa.koivu_at_efairfield.com]Sent: Thursday, November 29, 2001
1:27 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: RE: ORA-03113
Yes, you are right. If you have
multiple instances change the command to something like this, assuming your
sid name is SID
> ps -fu oracleSID|grep -v PPID|awk '{ print $2;
}'|xargs kill -9
Try it without the xargs kill -9 to verify
it's choosing what you need. Otherwise just kill smon, pmon and the
database will come down. I have done this many times and only once did I
end up in a recovery.
Lisa Koivu Oracle Database
Administrator Fairfield Resorts, Inc.
954-935-4117
-----Original Message----- <FONT
face=Arial size=1>From: Greg
Faktor [SMTP:FAKTORG_at_labs.wyeth.com] <FONT face=Arial
size=1>Sent: Thursday,
November 29, 2001 12:21 PM <FONT face=Arial
size=1>To: <FONT face=Arial
size=1>Multiple recipients of list ORACLE-L <FONT face=Arial
size=1>Subject: <FONT
face=Arial size=1>Re: RE: ORA-03113
If I'll apply this command it's will take all
oracle processes down for every instance in this box?
Thanks.
> -----Original Message----- <FONT
face=Arial size=2>> From: Greg Faktor [SMTP:FAKTORG_at_labs.wyeth.com]
> Sent: Thursday, November 29, 2001
10:05 AM > To: Multiple
recipients of list ORACLE-L >
Subject: ORA-03113 <FONT face=Arial
size=2>> > Hi All! <FONT
face=Arial size=2>> I tried shutdown immediate and get ORA-03113.
> Now I can't connect to database. How I can
take instance down? On this HP > box
10 different databases. > This command
was posted some time back by Mladen: >
> ps -fu oracle|grep -v PPID|awk '{
print $2; }'|xargs kill -9 > It's will
take all oracle processes and listeners down <FONT face=Arial
size=2>> which I don't want to do. I'm on Oracle 8.1.6.
> Thanks. <FONT face=Arial
size=2>> Greg. > <FONT
face=Arial size=2>> -- > Please see
the official ORACLE-L FAQ: <A href="http://www.orafaq.com"
target=_blank>http://www.orafaq.com <FONT face=Arial
size=2>> -- > Author: Greg
Faktor > INET:
FAKTORG_at_labs.wyeth.com >
> Fat City Network
Services -- (858) 538-5051 FAX: (858)
538-5051 > San Diego,
California -- Public Internet
access / Mailing Lists >
 |
 |