Oracle-L: RE: SLA Trigger/Procedure

From: Ron Thomas <rthomas_at_hypercom.com>
Date: Tue, 03 Dec 2002 11:10:09 -0800
Message-ID: <F001.0051119E.20021203111009@fatcity.com>

Yes, but can I get it signed...

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
Each new user of a new system uncovers a new class of bugs. -- Kernighan

                                                                                                                                                    
                      Jared.Still_at_radis                                                                                                             
                      ys.com                   To:       ORACLE-L_at_fatcity.com                                                                       
                      Sent by:                 cc:                                                                                                  
                      root_at_fatcity.com         Subject:  RE: SLA Trigger/Procedure                                                                  
                                                                                                                                                    
                                                                                                                                                    
                      12/03/2002 10:34                                                                                                              
                      AM                                                                                                                            
                      Please respond to                                                                                                             
                      ORACLE-L

Ahem...

OK, I can not resist any longer.

The tools exist: http://www.amazon.com/exec/obidos/tg/detail/-/0596002106

The 'dbup' script logs all connections attempts. Use sed, perl, or whatever
to parse the logfile, or modify to create logs more to your liking.

Jared

"Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> Sent by: root_at_fatcity.com
12/03/2002 06:32 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc:
        Subject:        RE: SLA Trigger/Procedure

Go buy a tool? Here is an idea instead ... Write a small Perl (pick your favorite language here) script that looks at
/etc/oratab followed by a check to see if each of the instances listed in
/etc/oratab is up on the side where it is checking. It then log in as a
schema (we call it) called heartbeat, insert a row into a table with sysdate. Wait 3 seconds, retrieve the row and checks the time difference. If it is more than 5 seconds, you have a potential delay somewhere and have it alert appropriate people. (If it is night, page your VP with "This is your heartbeat calling ... we have a problem" ...) Life is great with "cron" ...
HTH
Raj

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!

(See attached file: ESPN_Disclaimer.txt)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Thomas
  INET: rthomas_at_hypercom.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).



application/octet-stream attachment: ESPN_Disclaimer.txt

Received on Tue Dec 03 2002 - 13:10:09 CST