Oracle-L: RE: SLA Trigger/Procedure

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Tue, 03 Dec 2002 08:33:49 -0800
Message-ID: <F001.00510E0E.20021203083349@fatcity.com>

RE: SLA Trigger/ProcedureDang, I just new that would cause a stir!

Mark <Running away now> Leith
  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Jamadagni, Rajendra
  Sent: 03 December 2002 14:32
  To: Multiple recipients of list ORACLE-L   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!

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

Received on Tue Dec 03 2002 - 10:33:49 CST