Re: Sending an e-mail when Oracle shuts down

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Wed, 23 Aug 2006 14:36:17 GMT
Message-ID: <J4GGKH.JHx@igsrsparc2.er.usgs.gov>

Brian Peasland wrote:
> Tarby777 wrote:

>> Hi all,
>>
>> Is it possible to configure Oracle 9iR1 to send an e-mail whenever the
>> instance shuts down? I know that I could create a shell script to shut
>> the instance down and send a mail, but I can't be sure that folks will
>> always use the script. I'm wondering whether there's an Oracle file
>> somewhere that always gets read during an instance shutdown, to which I
>> could add a line that would send the mail. Maybe there's a PL/SQL
>> procedure that would handle this... what's the best way to get the
>> system to send this e-mail?
>>
>> TIA
>> Tarby
>>

>
> I agree with Sybrand's suggestion to use OEM to monitor this condition
> for you. That would be choice #1.
>
> Choice #2 (IMHO) is to create a BEFORE SHUTDOWN trigger to implement
> this functionality. The trigger will only fire on "normal" shutdowns and
> will not capture crashes. That is why OEM is preferable.
>
> HTH,
> Brian
>

Forgot the link....here is the documentation on creating said trigger:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7004.htm#i2235611

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Wed Aug 23 2006 - 09:36:17 CDT