Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: ORA-03113

RE: RE: ORA-03113

From: Rao, Maheswara <Maheswara.Rao_at_Sungardp3.com>
Date: Thu, 29 Nov 2001 11:00:12 -0800
Message-ID: <F001.003D0EBE.20011129105430@fatcity.com>

<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.
    >>> lisa.koivu_at_efairfield.com 11/29     10:35 AM >>> Why don't you want
    to want to take all the oracle processes down?  I thought     that's what you wanted to accomplish with     shutdown immediate?
    Go ahead and issue Mladen's command and restart     the database.  It's the only way you     can bring it down if you can't connect with svrmgrl or sqlplus.     Lisa Koivu <FONT face=Arial
    size=2>Oracle Database Monkey Fairfield     Resorts, Inc. 954-935-4117

    > -----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 >



    > 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 Thu Nov 29 2001 - 13:00:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US