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
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -----Original Message-----
> From: Molina, Gerardo [mailto:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
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: [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).
