RE: DB monitoring using SNMP MIBs

MIB, hey I saw that movie too. ;o)

-----Original Message-----
Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L

Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs.

On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote:
> Kevin,
>
> This is great! Can we get a list of all the OIDs that Oracle uses? Can you
> also let the group know if any additional plug-ins are required for Perl to
> work with SNMP?
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
>
> What would you see if you were allowed to look back at your life at the end
> of your journey in this earth?
>
> ** The opinions and statements above are entirely my own and not those of my
> employer or clients **
>
>
>
> -----Original Message-----
> Sent: Wednesday, October 23, 2002 3:54 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Yes. You can use PERL to do such things such as getting the database state,
> name, consistent gets, system block gets, etc from SNMP:
>
> #!/usr/local/bin/perl
>
> use BER;
>
> use SNMP_Session;
> use SNMP_util;
> use Getopt::Std;
>
> getopts("h:i:");
>
> my($host, $community, $response, $bindings, $binding, $value, @oid,
> @retvals);
> my $session;
>
> $host = $opt_h;
> $community = "public";
> $db_index = $opt_i;
>
> # Database State
> $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2';
> #Database Name
> $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index .
> '.7.100.98.95.110.97.109.101.1';
> # Consistent Block Gets
> $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index;
> # System Block Gets
> $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index;
>
> my @retvals = SNMP_util::snmpget ( $host, @oid );
>
>
>
>
> -----Original Message-----
> Sent: Wednesday, October 23, 2002 5:20 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Thanks Dennis, Gary
>
> I have tools at my disposal to monitor the db, and I have no problem with
> that. I was just reading through snmp and was intrigues by the idea that I
> could get some information without running scripts through sqlplus interface
> and if so how to accomplish that.
>
> I know it is doable because IA does that, just wondering if it would be
> feasible to do it be some scripting ...
>
> 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-----
> <mailto:DWILLIAMS_at_LIFETOUCH.COM> ]
> Sent: Wednesday, October 23, 2002 6:04 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
> <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
> <http://www.orafaq.com>
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> <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.com
> --
> Author: John Kanagaraj
> INET: john.kanagaraj_at_hds.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).

-- 
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

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.com
-- 
Author: Farnsworth, Dave
  INET: DFarnsworth_at_Ashleyfurniture.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).