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.freelists.org/webpage/oracle-l