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
>
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
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
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
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
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 u
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 0
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 grou
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
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 yo
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:");
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
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
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
Not sure, Though it does run queries against the database, does the OEM
Agent not use MIB?
One attachment (0k)
"Jamadagni,
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
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
17 matches
Mail list logo