now now, play nice!
- "Freeman, Robert" <Robert_Freeman_at_csx.com> wrote:
> 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_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
>
=== message truncated ===
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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 Thu Oct 24 2002 - 10:28:34 CDT