Re: DB monitoring using SNMP MIBs

This documentation is found under the 'Oracle Enterprise Manager' section of the documentation.

Jared

On Thursday 24 October 2002 08:08, Kevin Lange wrote:
> Raj;
> Here is a link to the SNMP Support Reference Guide that Ray talked about
> for 8.1.7. I am sure its probably somewhere on your Documentation CD for
> your version.
>
> http://www.cosc.canterbury.ac.nz/docs/oracle/server.817/em.817/a85249.pdf
>
> All I did was search the web for "Oracle SNMP Support Reference Guide
> Release 8.1.7" and I found a ton of links.
>
> Kevin
>
>
> Thanks Ray.
>
> -----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).

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