RE: Shutdown Immediate

Or, if you don't want all your pagers going off because OEM thinks that all the instances on that server are down when it loses contact with the IA, on Unixishes you can:

        ps -ef|grep oracle$ORACLE_SID|grep -v grep

...from another session after starting the SHUTDOWN IMMEDIATE. You should see only three processes, each connected locally. If you have more than three processes, the rest should be shutting down. One of these three processes is your connection and will be the only one with a parent process ID > 1. The other two are the dbsnmp processes. "kill" these other two processes from the Unix shell prompt. If they don't die within 30 seconds after "kill", use "kill -9" on each.

It still may take a few seconds (up to a minute or two on our 6-way K570 with the 4 DBWRs each taking a CPU), but it will complete.

This is really much simpler than I've shown. It just takes a little Unix-sense.

HTH! :)

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Molina, Gerardo [mailto:Gerardo.Molina_at_schwab.com]
> Sent: Saturday, October 05, 2002 8:03 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Shutdown Immediate

[SNIP]  
> 2. Check if intelligent agent is running. You should
> shutdown intelligent
> agent before trying to do a shutdown immediate.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).