Thanks Rao for correcting me. Like I confessed earlier, I am unix savvy, not an expert :)
-----Original Message-----
From: Rao, Maheswara [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: ORA-03113
Lisa,
�
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.
�
Now,� the following modification for the command might work. I did not test this completely.
�
ps -fu oracle | grep -v SID | grep -v PPID | awk '{ print $2; }' | xargs kill -9
�
Rao
-----Original Message-----
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L
Subject: 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-----
From:�� Greg Faktor [SMTP:[EMAIL PROTECTED]]
Sent:�� Thursday, November 29, 2001 12:21 PM
To:���� Multiple recipients of list ORACLE-L
Subject:������� 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.
>>> [EMAIL PROTECTED] 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
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
> -----Original Message-----
> From: Greg Faktor [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 29, 2001 10:05 AM
> To:�� Multiple recipients of list ORACLE-L
> Subject:����� ORA-03113
>
> Hi All!
> 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
> which I don't want to do. I'm on� Oracle 8.1.6.
> Thanks.
> Greg.
>
> --
> Please see the official ORACLE-L FAQ: <http://www.orafaq.com>
> --
> Author: Greg Faktor
>�� INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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.com>
--
Author: Greg Faktor
� INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
