[Nagios-users] Monitoring Oracle
Hi I'm trying to monitoring oracle database and i need to know when the tablespaces is near of the limite determined in the database. I use oraDbTablespaceSizeAllocated and oraDbTablespaceSizeUsed to check this. Anyone knows how to use the value in oraDbTablespaceSizeAllocated to set the critical limit in the check_snmp plugin.- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
[Nagios-users] Monitoring Oracle database
Dear All, I m trying to monitor Oracle database using check_oracle plug-in. I need to know what all parameters (related to database) can be monitored through Nagios and please advice for configuring the same. Please help. Thanks & Regards, Chethan M N, Sr Engineer - EMS <>-- Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT is a gathering of tech-side developers & brand creativity professionals. Meet the minds behind Google Creative Lab, Visual Complexity, Processing, & iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian Group, R/GA, & Big Spaceship. http://www.creativitycat.com ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
[Nagios-users] Monitoring Oracle database
Dear All, I m trying to monitor Oracle database using check_oracle plug-in. I need to know what all parameters (related to database) can be monitored through Nagios and please advice for configuring the same. Please help. Thanks & Regards, Chethan M N, Sr Engineer - EMS <>-- Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT is a gathering of tech-side developers & brand creativity professionals. Meet the minds behind Google Creative Lab, Visual Complexity, Processing, & iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian Group, R/GA, & Big Spaceship. http://www.creativitycat.com ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Monitoring Oracle
HI,
> I'm trying to monitoring oracle database and i need to know when the
> tablespaces is near of the limite determined in the database. I use
> oraDbTablespaceSizeAllocated and oraDbTablespaceSizeUsed to check this.
> Anyone knows how to use the value in oraDbTablespaceSizeAllocated to set the
> critical limit in the check_snmp plugin.
I use many scripts to report information out of a oracle database and
found the most flexible way to do this was to generate perl scripts to
interrogate the database and then have these scripts report nagios
codes back. I've used a custom command to achieve this (or if the
monitoring system is not able to execute oracle queries, then you
could use nrpe to remotely execute a script on a server that does have
oracle access) that is called via a service check.
For example :-
define command {
command_namelogic_invoice_collection
command_line/home/nagios/bl/invoice/collection/query.pl "$ARG1$"
}
define service {
use bus-logic-service
host_name bb_logic
service_description INVCOLLECT
check_command logic_invoice_collection!30
}
Where query.pl looks something like this (the actual BB_BL subroutines
are not included as they are not relevant in the context of this
example) :-
#!/usr/bin/perl
use vars qw($PROGNAME);
use lib "/usr/local/nagios/libexec" ;
use utils qw (%ERRORS &print_revision &support);
my($inte) = $ARGV[0];
my $cur_count;
my $com_count;
$cur_count = BB_BL::doDatabaseRequest('INVCOLLECTCTRY',$inte);
$com_count = BB_BL::doDatabaseRequest('INVCOLLECTCTRY',$inte-3600);
my(%thresh) = BB_BL::grabThresholds();
my($status) = BB_BL::determineStatus($cur_count,$com_count,\%thresh);
my $description= "CURRENT : $cur_count / COMPARED : $com_count";
my($title) = "INVCOLLECT";
print $title . " " . $status . " - " . $description . "\n";
exit $ERRORS{$status};
The BB_BL::determineStatus subroutine returns
'OK','WARNING','CRITICAL' or 'UNKNOWN' and decides which value to
return based upon the different between two variables and their
relationship to some threshold values.
maybe this is of some help to you.
--
bright blessings,
Mark
-
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting
any issue.
::: Messages without supporting info will risk being sent to /dev/null
[Nagios-users] monitoring oracle grid
hello list, We've been monitoring our Oracle Database using a plugin called 'check_oracle'. It's proven quite handy in getting the sizes of tablespaces and alerting based on percentages of space used. However the DBAs point out that the database is very dynamic and that tablespaces are always being added and removed. It seems like they don't want to notify us each time this happens. Keeping on top of them to do this is a pain. They've just installed Oracle Grid and suggested we use nagios to monitor that instead. I've never seen or used Oracle Grid so I was hoping someone out there with a little more knowledge than me on the topic might have some suggestions on how to accomplish this. Are there any plugins already out there that are written to take information from the oracle grid and parse that for use in nagios? Thanks Tim -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Monitoring Oracle database
http://www.consol.de/opensource/nagios/check-oracle-health/ Hope this helps. 2009/5/21 : > Dear All, > > > > I m trying to monitor Oracle database using check_oracle plug-in. > > > > I need to know what all parameters (related to database) can be monitored > through Nagios and please advice for configuring the same. > > > > > > Please help. > > > > Thanks & Regards, > > > > Chethan M N, > Sr Engineer - EMS > > > > -- > Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > is a gathering of tech-side developers & brand creativity professionals. > Meet > the minds behind Google Creative Lab, Visual Complexity, Processing, & > iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian > Group, R/GA, & Big Spaceship. http://www.creativitycat.com > ___ > Nagios-users mailing list > Nagios-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/nagios-users > ::: Please include Nagios version, plugin version (-v) and OS when reporting > any issue. > ::: Messages without supporting info will risk being sent to /dev/null > -- Thanks, Chenlei & 石头++ MSN Messenger: c...@163.com -- Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT is a gathering of tech-side developers & brand creativity professionals. Meet the minds behind Google Creative Lab, Visual Complexity, Processing, & iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian Group, R/GA, & Big Spaceship. http://www.creativitycat.com ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] monitoring oracle grid
Don't know about Oracle Grid, but I have another suggestion. If I understood correctly, your issue is to monitor the tablespaces which where added by the DBA's? If so, you should try the plugin check_oracle_health which has an option to monitor ALL tablespaces (not just the utilization of one given tablespace): --mode tablespace-usage If wanted you can also monitor a single tablespace by using: --mode tablespace-usage --tablespace MYTABLE http://labs.consol.de/lang/en/nagios/check_oracle_health/ On Fri, Apr 13, 2012 at 4:11 AM, Tim Dunphy wrote: > hello list, > > We've been monitoring our Oracle Database using a plugin called > 'check_oracle'. It's proven quite handy in getting the sizes of tablespaces > and alerting based on percentages of space used. > > However the DBAs point out that the database is very dynamic and that > tablespaces are always being added and removed. It seems like they don't > want to notify us each time this happens. Keeping on top of them to do this > is a pain. > > They've just installed Oracle Grid and suggested we use nagios to monitor > that instead. I've never seen or used Oracle Grid so I was hoping someone > out there with a little more knowledge than me on the topic might have some > suggestions on how to accomplish this. > > Are there any plugins already out there that are written to take > information from the oracle grid and parse that for use in nagios? > > Thanks > Tim > > > -- > For Developers, A Lot Can Happen In A Second. > Boundary is the first to Know...and Tell You. > Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! > http://p.sf.net/sfu/Boundary-d2dvs2 > ___ > Nagios-users mailing list > Nagios-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/nagios-users > ::: Please include Nagios version, plugin version (-v) and OS when > reporting any issue. > ::: Messages without supporting info will risk being sent to /dev/null > -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
[Nagios-users] Monitoring Oracle DB running on Windows
Hello List, Is there a way to monitor an Oracle Database running on a Windows Server using Nagios? Thanks, Pavel --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37&alloc_id865&op=click ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Monitoring Oracle DB running on Windows
contribs/check_oracle.sh should do what you need. Ben On 12/19/05, Pavel Santos <[EMAIL PROTECTED]> wrote: > Hello List, > > Is there a way to monitor an Oracle Database running on a Windows Server > using Nagios? > > Thanks, > > Pavel > > > --- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://ads.osdn.com/?ad_idv37&alloc_id865&opclick > ___ > Nagios-users mailing list > Nagios-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/nagios-users > ::: Please include Nagios version, plugin version (-v) and OS when reporting > any issue. > ::: Messages without supporting info will risk being sent to /dev/null > -- "A Scientist will earn a living by taking a really difficult problem and spends many years solving it, an engineer earns a living by finding really difficult problems and side stepping them" --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37&alloc_id865&op=click ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
[Nagios-users] Monitoring Oracle tablespace created with autoextension option
Hello all. I would like to ask for help to people in this mailinglist. We are trying to monitor Oracle Database which is installed on the Windows Server. * Sorry that we cannot reveal the details of the versions at this moment. Nagios (v 3.0.6) is installed in the Linux box (RHEL 5.2). I am considerding to monitor the Oracle Table space but hesitating which plugin to use. The table is created with the autoextension option. We found "check_oracle_health" but is this the most recommended plugin to monitor Oracle installed on the Windows Server? Also , if there are any better plugin , it would be helpful if you can share us the information. Thanks, Yu Watanabe -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122412 ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Monitoring Oracle tablespace created with autoextension option
Am 21.01.2013 um 07:36 schrieb Yu Watanabe : > Hello all. > > I would like to ask for help to people in this mailinglist. > > We are trying to monitor Oracle Database which is installed on the Windows > Server. > * Sorry that we cannot reveal the details of the versions at this moment. > > Nagios (v 3.0.6) is installed in the Linux box (RHEL 5.2). > > I am considerding to monitor the Oracle Table space but hesitating which > plugin to use. The table is created with the autoextension option. > > We found "check_oracle_health" but is this the most recommended plugin > to monitor Oracle installed on the Windows Server? yes it is (IMHO) Joerg -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122412 ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Monitoring Oracle tablespace created with autoextension option
you can also go with op5 check_oracle which can do a lot of things .Please find the below feature list The plugin can monitor: - database availability (tnsping) - login or dummy login - cache hit ratio - tablespace usage - datafile usage - total number of datafiles - available extents per table or tablespace - log archiving enabled or not - backupmode - user defined query, match for string or numeric value - locks - broken transactions - failed transactions - transactions in the deferred error queue - invalid transactions http://git.op5.org/git/?p=nagios/op5plugins.git;a=blob_plain;f=check_oracle.pl;hb=HEAD On Mon, Jan 21, 2013 at 3:13 PM, Joerg Linge wrote: > > Am 21.01.2013 um 07:36 schrieb Yu Watanabe : > > > Hello all. > > > > I would like to ask for help to people in this mailinglist. > > > > We are trying to monitor Oracle Database which is installed on the > Windows Server. > > * Sorry that we cannot reveal the details of the versions at this moment. > > > > Nagios (v 3.0.6) is installed in the Linux box (RHEL 5.2). > > > > I am considerding to monitor the Oracle Table space but hesitating which > > plugin to use. The table is created with the autoextension option. > > > > We found "check_oracle_health" but is this the most recommended plugin > > to monitor Oracle installed on the Windows Server? > > yes it is (IMHO) > > Joerg > > -- > Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, > MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current > with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft > MVPs and experts. SALE $99.99 this month only -- learn more at: > http://p.sf.net/sfu/learnmore_122412 > ___ > Nagios-users mailing list > Nagios-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/nagios-users > ::: Please include Nagios version, plugin version (-v) and OS when > reporting any issue. > ::: Messages without supporting info will risk being sent to /dev/null > -- Regards Sunil Sankar -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122412___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
