Re: DB monitoring using SNMP MIBs

2002-10-27 Thread Jared Still
You can read all about it at: http::/www.oreilly.com/catalog/oracleperl and http://www.amazon.com/exec/obidos/tg/detail/-/0596002106 :) Jared On Saturday 26 October 2002 20:59, Leonard, George wrote: Hi Jared Someone mentioned that you have a perl+dba tool set, would you mind telling us

Re: DB monitoring using SNMP MIBs

2002-10-26 Thread Jared Still
I seem to be missing part of this thread, and have been gone most the week. Re SNMP: I haven't played with it myself, but there are ~100 Perl modules dealing with SNMP. It would take some research to determine which are the most useful, and go from there. Definitely doable. Maybe Perl for

Re: DB monitoring using SNMP MIBs

2002-10-26 Thread Jared Still
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

RE: DB monitoring using SNMP MIBs

2002-10-26 Thread Leonard, George
Hi Jared Someone mentioned that you have a perl+dba tool set, would you mind telling us more about it, etc etc. Sorry guys but it is 02:56 and I am monitoring a db build, (100GB) need things to amuse me. Thx Ps: thx for all the people that send me scripts on how to monitor rollback segment

Re: DB monitoring using SNMP MIBs

2002-10-24 Thread Ray Stell
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

RE: DB monitoring using SNMP MIBs

2002-10-24 Thread Farnsworth, Dave
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

RE: DB monitoring using SNMP MIBs

2002-10-24 Thread Kevin Lange
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

RE: DB monitoring using SNMP MIBs

2002-10-24 Thread Kevin Lange
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

DB monitoring using SNMP MIBs

2002-10-23 Thread Jamadagni, Rajendra
Title: DB monitoring using SNMP MIBs 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

RE: DB monitoring using SNMP MIBs

2002-10-23 Thread DENNIS WILLIAMS
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

RE: DB monitoring using SNMP MIBs

2002-10-23 Thread Gary Weber
Title: DB monitoring using SNMP MIBs Unless you'd like to do it yourself, Argent has done it: http://www.argent.com/products/guardian/My limited understanding is that it does exactly what you describe - read o/s snmp mib libraries. I don't use it for Oracle, but our systems folks seem

Re: DB monitoring using SNMP MIBs

2002-10-23 Thread Rajesh . Rao
: @espn.com Subject: DB monitoring using SNMP MIBs Sent by: [EMAIL PROTECTED

RE: DB monitoring using SNMP MIBs

2002-10-23 Thread Jamadagni, Rajendra
Title: RE: DB monitoring using SNMP MIBs 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

RE: DB monitoring using SNMP MIBs

2002-10-23 Thread Jamadagni, Rajendra
Title: RE: DB monitoring using SNMP MIBs Rajesh, yes exactly my point ... but I am just wondering if it would be possible to do it from Unix level (simple scripting ...). Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni

Re: DB monitoring using SNMP MIBs

2002-10-23 Thread Ray Stell
On Wed, Oct 23, 2002 at 02:19:39PM -0800, Jamadagni, Rajendra wrote: 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

RE: DB monitoring using SNMP MIBs

2002-10-23 Thread Kevin Lange
Title: RE: DB monitoring using SNMP MIBs 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:");

RE: DB monitoring using SNMP MIBs

2002-10-23 Thread John Kanagaraj
Raj, I looked at the TCL scripts that comes along with OEM, and did see that SNMP is being used therein. If TCL can do it, I am sure Perl can do it. Jared - Any inputs? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at

RE: DB monitoring using SNMP MIBs

2002-10-23 Thread John Kanagaraj
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