RE: DB monitoring using SNMP MIBs

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 23 Oct 2002 14:04:04 -0800
Message-ID: <F001.004F1C8B.20021023140404@fatcity.com>

Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools on the market today. OEM may even use SNMP. I can see two approaches for you.

1. You write your own tool that will issue SNMP alerts. Perhaps this would be a Unix daemon process that executes database queries, and then based on what it finds, issues SNMP alerts.
2. Use an existing tool to accomplish what you want.

If your desire is to create a database monitoring tool that you can give away for free, then sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>

-----Original Message-----
Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L

Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db?

I am looking into this and have no clue or available docs on how to do this
(esp on AIX). If someone can point me to the right direction, I would really
appreciate that.

TIA
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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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 Wed Oct 23 2002 - 17:04:04 CDT