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
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]   

-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
-- 
Author: DENNIS WILLIAMS
  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).

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 to like the product and 
offered a number of time to monitor databases for me. No thanks, but 
hey...
 
Gary WeberSenior DBACharles Jones, LLC||Superior 
Information Services, LLC609-538-1000, ext 5529 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Jamadagni, RajendraSent: 
Wednesday, October 23, 2002 5:39 PMTo: Multiple recipients of list 
ORACLE-LSubject: 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 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!

Re: DB monitoring using SNMP MIBs

2002-10-23 Thread Rajesh . Rao 

Not sure, Though it does run queries against the database, does the OEM
Agent not use MIB?




  One attachment (0k)
   
   
"Jamadagni,
   
Rajendra"  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
 Subject: DB monitoring using SNMP 
MIBs 
Sent by:   
   
[EMAIL PROTECTED]   
   
   
   
   
   
October 23, 2002   
   
05:38 PM   
   
Please respond to  
   
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




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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).

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 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-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 23, 2002 6:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DB monitoring using SNMP MIBs



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:[EMAIL PROTECTED]>  


-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
-- 
Author: DENNIS WILLIAMS
  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).



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

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 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-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 23, 2002 6:09 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: DB monitoring using SNMP MIBs




Not sure, Though it does run queries against the database, does the OEM
Agent not use MIB?



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

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 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 ... 
-- 

tcl has a great add on module that makes this real easy called
scotty.  http://wwwhome.cs.utwente.nl/~schoenw/scotty/
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^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).

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:");
 
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-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 23, 
  2002 5:20 PMTo: Multiple recipients of list 
  ORACLE-LSubject: 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 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- From: 
  DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: DB monitoring using SNMP MIBs 
  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:[EMAIL PROTECTED]>  
  
  -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 -- 
  Author: DENNIS WILLIAMS   
  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).

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 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: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. 
   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
 >  

-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
  
-- 
Author: DENNIS WILLIAMS 
  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: 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).

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 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. 
   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
 >  

-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
  
-- 
Author: DENNIS WILLIAMS 
  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: 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

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 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. 
>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
>  >  
> 
> -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
>   
> -- 
> Author: DENNIS WILLIAMS 
>   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 othe

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 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- 
>  ] 
> 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
>  >  
> 
> -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
>   
> -- 
> Author: DENNIS WILLIAMS 
>   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, inc

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 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. 
   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
 >  

-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
  
-- 
Author: DENNIS WILLIAMS 
  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: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing li

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 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- 
>  ] 
> 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
>  >  
> 
> -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
>   
> -- 
> Author: DENNIS WILLIAMS 
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- 858-538-5051 http://www.fatc

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 DBA's" 2nd edition.  :)

Jared

On Wednesday 23 October 2002 16:16, John Kanagaraj wrote:
> 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 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: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.
>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
>  >
>
> -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
-- 
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).

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 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-
> >  ]
> > 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
> >  >
> >
> > -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.
> >

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 usage by a session. Below is a modification of what was send to me
by Kevin Lange [[EMAIL PROTECTED]]. 

Thx Kevin,

One of the developers here are writing a little Delphi app as a front end
for it to show using some nice graphics the output that is then further
drill down-able to the actual query and more information about the relevant
session.


set lines 300
column name format a7
column sid format 
column serial# format 9
column username format a10
column machine format a25
column status format a10
column cr_get format 99,999,999
column phy_io format 9,999,999
column used_ublk format 99,999,999
column "DB User" format a10
column "Sql Hash" format 99
column command format a30
column "MB" format 99,999
column "MB Used" format 99,999.99
column "Start Time" format a18
column "%" format 99.99
SELECT
  r.NAME, -- rbs name
  s.sid,
  s.username,
  t.status,
  t.cr_get, -- consistent gets
  t.phy_io, -- physical IO
  t.used_ublk, -- Undo blocks used
  round(sg.blocks * ts.blocksize / 1048576, 2) "MB",
(t.used_ublk*8192)/1024/1024 "MB Used",
((t.used_ublk*8192)/1024/1024)/(round(sg.blocks * ts.blocksize /
1048576, 2))*100 "%",
  s.sql_address "Address",
  s.sql_hash_value "Sql Hash",
t.start_time "Start Time",
s.machine,
  SUBSTR (s.program, 1, 78) "COMMAND"
FROM sys.v_$session s, sys.v_$transaction t, sys.v_$rollname r,
 v$rollstat ss,
 sys.undo$ ud,
 sys.seg$ sg,
 sys.ts$ ts
where ud.us# = ss.usn (+)
  and ud.file# = sg.file#
  and ud.block# = sg.block#
  and sg.ts# = ts.ts#
and ss.usn = r.usn
  and t.addr = s.taddr
AND t.xidusn = r.usn
ORDER BY t.start_time;


George

George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:[EMAIL PROTECTED]
Web:   http://www.didata.co.za
 
You Have The Obligation to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
or Injure Themselves as They See Fit!

-Original Message-
Sent: 27 October 2002 03:18 AM
To: Multiple recipients of list ORACLE-L


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 DBA's" 2nd edition.  :)

Jared

On Wednesday 23 October 2002 16:16, John Kanagaraj wrote:
> 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 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: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.
>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 tha

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 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 usage by a session. Below is a modification of what was send to me
> by Kevin Lange [[EMAIL PROTECTED]].
>
> Thx Kevin,
>
> One of the developers here are writing a little Delphi app as a front end
> for it to show using some nice graphics the output that is then further
> drill down-able to the actual query and more information about the relevant
> session.
>
>
> set lines 300
> column name format a7
> column sid format 
> column serial# format 9
> column username format a10
> column machine format a25
> column status format a10
> column cr_get format 99,999,999
> column phy_io format 9,999,999
> column used_ublk format 99,999,999
> column "DB User" format a10
> column "Sql Hash" format 99
> column command format a30
> column "MB" format 99,999
> column "MB Used" format 99,999.99
> column "Start Time" format a18
> column "%" format 99.99
> SELECT
>   r.NAME, -- rbs name
>   s.sid,
>   s.username,
>   t.status,
>   t.cr_get, -- consistent gets
>   t.phy_io, -- physical IO
>   t.used_ublk, -- Undo blocks used
>   round(sg.blocks * ts.blocksize / 1048576, 2) "MB",
>   (t.used_ublk*8192)/1024/1024 "MB Used",
>   ((t.used_ublk*8192)/1024/1024)/(round(sg.blocks * ts.blocksize /
> 1048576, 2))*100 "%",
>   s.sql_address "Address",
>   s.sql_hash_value "Sql Hash",
>   t.start_time "Start Time",
>   s.machine,
>   SUBSTR (s.program, 1, 78) "COMMAND"
> FROM sys.v_$session s, sys.v_$transaction t, sys.v_$rollname r,
>v$rollstat ss,
>  sys.undo$ ud,
>  sys.seg$ sg,
>  sys.ts$ ts
> where ud.us# = ss.usn (+)
>   and ud.file# = sg.file#
>   and ud.block# = sg.block#
>   and sg.ts# = ts.ts#
>   and ss.usn = r.usn
>   and t.addr = s.taddr
>   AND t.xidusn = r.usn
> ORDER BY t.start_time;
>
>
> George
> 
> George Leonard
> Oracle Database Administrator
> Dimension Data (Pty) Ltd
> (Reg. No. 1987/006597/07)
> Tel: (+27 11) 575 0573
> Fax: (+27 11) 576 0573
> E-mail:[EMAIL PROTECTED]
> Web:   http://www.didata.co.za
>
> You Have The Obligation to Inform One Honestly of the risk, And As a Person
> You Are Committed to Educate Yourself to the Total Risk In Any Activity!
> Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
> or Injure Themselves as They See Fit!
>
> -Original Message-
> Sent: 27 October 2002 03:18 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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 DBA's" 2nd edition.  :)
>
> Jared
>
> On Wednesday 23 October 2002 16:16, John Kanagaraj wrote:
> > 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 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: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