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@;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. > > [EMAIL PROTECTED] < mailto:dwilliams@;lifetouch.com > > <mailto:dwilliams@;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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).