Where? Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 4:44 PM
Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it...... hmmmmm.... let's see.... then Tim Gorman wrote it. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -----Original Message----- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L 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@;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). -- =============================================================== Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Farnsworth, Dave 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: Freeman, Robert 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: Yechiel Adar 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).