Re: Email/Page Notification using Oracle8i

patrick_hamou_at_hotmail.com (Patrick Hamou) wrote in <fRKQ3.24415$up3.33545_at_news21.bellglobal.com>:

>I have once done this kind of system ,
>If Oracle has a problem, to get E-Mailed of paged etc..
>
>Let me tell you How I did it..
>
>I first had to find a program that can E-Mail from the DOS prompt :
>- Postie (you can find it at Download.com)
>
>After, I did a Forms program that monitors the critical information,
 example
>: Tablespace utilisation
>with a Timer (every hour for instance) and if a Tablespace is used at 85%
>(or more),
>I sent myself an E-Mail with the Forms HOST command ..
>
>That's it !
>
>I don't think that Oracle 8i has an integrated system that can do
 something
>similar...
>
>
>Patrick Hamou
>Oracle DBA
>patrickhamou_at_hotmail.com
>
>Michael Chan <MikeChan_at_pacbell.net> wrote in message
>news:hgKQ3.150$4R2.18858_at_typhoon-sf.snfc21.pbi.net...
>> I'm an Oracle8i admin newbie and I am evaulating whether Oracle8i has
 any
>> built ins for doing notification.
>>
>> I want to have a monitor that can page or email me in case of any
 database
>> failures.
>>
>> Also, I'd like to be able to program in PL/SQL some sort of alert
 system.
>> The system would allow users to
>> register for a certain event to occur for example, if Madonna was
 playing
 a
>> concert. If I insert data indicating
>> that Madonna was playing, the system would look up all users that have
>> registered an interest in the artist and send out
>> a mass email.
>>
>> Does Oracle8i have any sort of built in notification like this that can
>> interface with email and paging? I have heard of Oracle Intelligent
 Agent.
>> Would this component do what I want?
>>
>>
>
>
>

Oracle 8i has the ability to invoke an OS procedure. On NT it is via a DDL that you construct to do what you need done. On Solaris it is via a "shared object" library. Under Solaris I created a real simple & brain dead OS call to "system", therefore it can & does execute ANY command that is passed to it.

-- 
WARNING - My point & click device is a 9mm w/laser sight