Oracle-L: RE: Oracle Alert to cell phone

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Fri, 25 Apr 2003 08:51:58 -0800
Message-ID: <F001.00589771.20030425085158@fatcity.com>

There is also an easy way to do it using Oracle Enterprise Manager (another shameless plug). You can set events or jobs to check database health, and it comes with plenty of canned events.To send a message to your cell phone, simply set up an administrator account and set the email to your cell phone, like 7122122222_at_messaging.nextel.com. It's that simple. Check the documentation for more specific details.

RWB

Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA

                                                                                                                               
                    mark_at_cool-tool                                                                                             
                    s.co.uk              To:     ORACLE-L_at_fatcity.com                                                          
                    Sent by:             cc:                                                                                   
                    root_at_fatcity.c       Subject:     RE: Oracle Alert to cell phone                                           
                    om                                                                                                         
                                                                                                                               
                                                                                                                               
                    04/25/2003                                                                                                 
                    04:23 AM                                                                                                   
                    Please respond                                                                                             
                    to ORACLE-L

Arvind,

I'm not sure if there any tools that have this functionality built directly in to the tool, I know ours doesn't.. Tools can usually achieve this in two ways though (and this doesn't just go for tools, but scripts as well).

Get an SMS program that has a command line interface, then invoke that command line interface, including the error string as the message, from with the alert functions of the tool (if it has an command line interface to alerts).
Sign up to an Email -> SMS service on the web, at places like http://www.orange.net, http://www.uboot.com, http://www.textforce.net. Some of these services are free, and some of them are chargeable. Test your local suppliers for actual response time of messages to find one that is acceptable. Test this on a fairly regular basis as well, as I've seen SMS providers that responded great at first, slip due to over subscriptions later on.. This way you can use most tools native email alert generation.

We have a tool that can do both of these. It's called Norad Surveillance
(http://www.cool-tools.co.uk/products/surveillance.html).

</shameless plug>

Regards

Mark

 Mark Leith             | T: +44 (0)1905 330 281
 Sales & Marketing      | F: +44 (0)870 127 5283
 Cool Tools UK Ltd      | E: mark_at_cool-tools.co.uk
===================================================
           http://www.cool-tools.co.uk
       Maximising throughput & performance

-----Original Message-----
Kumar
Sent: 25 April 2003 09:17
To: Multiple recipients of list ORACLE-L

hi all,

is there any tool which checks the oracle db health time to time and if
finds any problem ,reports it to DBA's cell phone.

Thanks
Arvind kumar

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arvind Kumar
  INET: arvindk_at_sqlstarintl.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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Reginald.W.Bailey_at_jpmorgan.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).

Received on Fri Apr 25 2003 - 11:51:58 CDT