you still have to *buy* the tool right?
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!
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: SLA Trigger/Procedure
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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/03/2002 06:32 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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!
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
