| 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: alter system v shutdown abort
orakill does have to be run on the server--it's a Windows executable that kills a process thread.
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Joel.Patterson_at_crowley.com
Sent: Wednesday, September 13, 2006 3:30 PM
To: Rich.Jesse_at_qg.com; oracle-l_at_freelists.org
Subject: RE: alter system v shutdown abort
I have never had such bad luck... but with orakill, I did come across the tidbit, (yet to be seconded), that it has to be run from the server itself to work.
Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72542
904 727-2542
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jesse, Rich
Sent: Wednesday, September 13, 2006 3:18 PM
To: oracle-l
Subject: RE: alter system v shutdown abort
[jaw drops] Yes! Don't shutdown the DB for backups! That would seem to be a big nasty red mark on your uptime reports for your "HA" solution...
Of course, with more of the story, there could still be a need for this. To date, I have never had consistent luck killing a connected process within Oracle on any version. I have always had exceptions where one or more hung in the "sniped" state.
On Unix, use a combination of a shell script that shuts down the listener, polls v$session and kills the processes. On Winders, you can use the Perl that comes with Oracle or use a [gulp] BAT file with the orakill command supplied by Oracle to kill the thread from the OS.
My $.02,
Rich
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Queen Roo Roo
Sent: Wednesday, September 13, 2006 1:57 PM
To: Smith, Ronald [Contractor]
Cc: oracle-l
Subject: Re: alter system v shutdown abort
The situation is that we have to have all users off so that the system can shut down for backup. It's an HP_UX HA solution that I am not familiar with. If all active users are not off, the process doesn't run and the stuff hits the fan. The process does a shutdown immediate as it's first action but that fails if a hung user is left on. I suggested that we use my program to see if there are any active users and kill them. The other option is the shutdown abort, startup, shutdown immediate but that might take longer than we have before system before the next step is excuted. Just killing any hung users seems to be less dangerous. Any other thoughts?
Thanks again,
Ruth
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 13 2006 - 14:35:53 CDT
 |
 |