The list could be hard for me to get ..... unless someone else knows where
they are. I will see what I can get.
-----Original Message-----
Sent: Wednesday, October 23, 2002 6:19 PM
To: Multiple recipients of list ORACLE-L
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-----
]
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.
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.
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
>
-----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.comSan 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: Kevin Lange
INET: kgel_at_ppoone.com
Fat City Network Services -- 858-538-5051
http://www.fatcity.comSan 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).
