Re: [Nagios-users] Oracle plugin check_oracle
Ton Voon wrote: On 18 Jul 2006, at 02:33, Yang Xiao wrote: On 7/11/06, Ton Voon [EMAIL PROTECTED] wrote: On 11 Jul 2006, at 11:21, Hari Sekhon wrote: It's happened again, I changed a non-related service name and then restarted nagios and now again it doesn't find $ORACLE_HOME for the sids of the databases apparently. This is ridiculous since I can su - nagios echo $ORACLE_HOME /usr/lib/oracle/10.2.0.2/client which gives me the path to the oracle client installation and I can also sqlplus "user/[EMAIL PROTECTED] " successfully and get a login. /usr/nagios/libexec/check_oracle --login dbname OK - dummy login connected Does anybody understand why this check has stopped working again when I haven't done anything to it, I have to get this working in a stable fashion, I can't have it doing this every time I restart nagios... How do you restart Nagios? Or do you mean reload? If the former, check that the startup scripts correctly source the environment variables. If the latter, it could be a bug in Nagios, though I'm not sure why. Alternatively, check_oracle will parse /var/opt/oracle/oratab (and other locations) for the ORACLE_HOME variable. Some installations of Oracle use this to know what SIDs are installed on a server. You could amend that instead. Ton Just figured out the same problem by looking at another thread on this, the answer is permission, make sure the oracle install tree has the world execute bit on! chmod 755 /app/oracle -R btw, I'm doing this via nrpe...so it has nothing to do with ORACLE_HOME, oracle client, ...none of that. Thanks Yang. I've forwarded this to nagios-users and to Hari. Ton http://www.altinity.com T: +44 (0)870 787 9243 F: +44 (0)845 280 1725 Skype: tonvoon My problem with this wasn't the x bit, since I could su - nagios and run the plug-in fine, and I had the $ORACLE_HOME var set. So I figured it must be the var problem that the script is falling down on and after adding the $ORACLE_HOME variable to the beginning of the script, I have had no further problems... -h - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV___ 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] Oracle plugin check_oracle
On 18 Jul 2006, at 02:33, Yang Xiao wrote:On 7/11/06, Ton Voon [EMAIL PROTECTED] wrote: On 11 Jul 2006, at 11:21, Hari Sekhon wrote:It's happened again, I changed a non-related service name and then restarted nagios and now again it doesn't find $ORACLE_HOME for the sids of the databases apparently. This is ridiculous since I can su - nagiosecho $ORACLE_HOME/usr/lib/oracle/10.2.0.2/client which gives me the path to the oracle client installation and I can alsosqlplus "user/[EMAIL PROTECTED] " successfully and get a login./usr/nagios/libexec/check_oracle --login dbnameOK - dummy login connected Does anybody understand why this check has stopped working again when I haven't done anything to it, I have to get this working in a stable fashion, I can't have it doing this every time I restart nagios... How do you restart Nagios? Or do you mean reload?If the former, check that the startup scripts correctly source the environment variables. If the latter, it could be a bug in Nagios, though I'm not sure why. Alternatively, check_oracle will parse /var/opt/oracle/oratab (and other locations) for the ORACLE_HOME variable. Some installations of Oracle use this to know what SIDs are installed on a server. You could amend that instead. TonJust figured out the same problem by looking at another thread on this, the answer is permission, make sure the oracle install tree has the world execute bit on! chmod 755 /app/oracle -Rbtw, I'm doing this via nrpe...so it has nothing to do with ORACLE_HOME, oracle client, ...none of that.Thanks Yang. I've forwarded this to nagios-users and to Hari.Tonhttp://www.altinity.comT: +44 (0)870 787 9243F: +44 (0)845 280 1725Skype: tonvoon - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV___ 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] Oracle plugin check_oracle
Hari Sekhon wrote: On 10/07/06, Jason Martin [EMAIL PROTECTED] wrote: On Mon, Jul 10, 2006 at 05:57:08PM +0100, Hari Sekhon wrote: Cannot determine ORACLE_HOME for sid dbname with status UNKNOWN This happened to me before but since it was working earlier I don't see how this could have broken... Soemthing must have changed... For one, why do I need ORACLE_HOME, sql/plus requires this since it uses it to find the tnsnames.ora file as well as the location of the error messages translation file. nagios user environment when I su - nagios, and three sqlplus is in the nagios user's path and I can do sqlplus user/[EMAIL PROTECTED] and successfully get a login prompt on the database server. How does it get in the nagios users's path? Could Nagios have been restarted in such a way that the profile or whatever didn't get sourced? -Jason Martin -- This message is PGP/MIME signed. I would expect that to be it as well but it's strange to see this. I rebooted nagios and it started working properly again. It started happening just after making a completely unrelated change to a mysql check and rebooting nagios. This sounds suspicious but at that same time as soon as it started giving me warning UNKNOWN for the status of the oracle machines, I immediately tried sqlplus username/[EMAIL PROTECTED] from the nagios user and it worked normally and logged me in... and echo $ORACLE_HOME gave me the path to the oracle client installation... so why did the check stop working? It's happened again, I changed a non-related service name and then restarted nagios and now again it doesn't find $ORACLE_HOME for the sids of the databases apparently. This is ridiculous since I can su - nagios echo $ORACLE_HOME /usr/lib/oracle/10.2.0.2/client which gives me the path to the oracle client installation and I can also sqlplus user/[EMAIL PROTECTED] successfully and get a login. /usr/nagios/libexec/check_oracle --login dbname OK - dummy login connected Does anybody understand why this check has stopped working again when I haven't done anything to it, I have to get this working in a stable fashion, I can't have it doing this every time I restart nagios... -h - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ 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] Oracle plugin check_oracle
On 11 Jul 2006, at 11:21, Hari Sekhon wrote:It's happened again, I changed a non-related service name and then restarted nagios and now again it doesn't find $ORACLE_HOME for the sids of the databases apparently. This is ridiculous since I cansu - nagiosecho $ORACLE_HOME/usr/lib/oracle/10.2.0.2/clientwhich gives me the path to the oracle client installation and I can alsosqlplus "user/[EMAIL PROTECTED]" successfully and get a login./usr/nagios/libexec/check_oracle --login dbnameOK - dummy login connectedDoes anybody understand why this check has stopped working again when I haven'tdone anything to it, I have to get this working in a stable fashion, I can't have it doing this every time I restart nagios...How do you restart Nagios? Or do you mean reload?If the former, check that the startup scripts correctly source the environment variables. If the latter, it could be a bug in Nagios, though I'm not sure why.Alternatively, check_oracle will parse /var/opt/oracle/oratab (and other locations) for the ORACLE_HOME variable. Some installations of Oracle use this to know what SIDs are installed on a server. You could amend that instead.Ton http://www.altinity.comT: +44 (0)870 787 9243F: +44 (0)845 280 1725Skype: tonvoon - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ 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] Oracle plugin check_oracle
On 04/07/06, Hari Sekhon [EMAIL PROTECTED] wrote: Ton Voon wrote: On 4 Jul 2006, at 18:41, Morris, Patrick wrote: Don't know about a binary plugin doing this. The Oracle Instantclient (sqlplus) is available here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/ linuxsoft.html [snip] The check_oracle client won't work with just the Instant Client, because it doesn't include tnsping. When I've used check_oracle, I use the --login option instead of --tnsping. This simulates a login, and returns OK if it gets a invalid login, incorrect username/password. This is a better check because it goes down the entire stack and grabs whatever errors are returned by Oracle (for instance, shutdown in progress). I assume the Instantclient will still work with check_oracle (as it just needs sqlplus). Ton http://www.altinity.com T: +44 (0)870 787 9243 F: +44 (0)845 280 1725 Skype: tonvoon Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ 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 yes this is probably what i'll do as well -h I took Ton Voon's advice and ran check_oracle --login which worked after installing sqlplus. I got this to start checking earlier today which was easier than I expected. I just ran ./check_oracle --login dbname and it gave me a successfull dummy login ok feedback. This has been working all afternoon, but now all of a sudden it's saying: Cannot determine ORACLE_HOME for sid dbname with status UNKNOWN This happened to me before but since it was working earlier I don't see how this could have broken... For one, why do I need ORACLE_HOME, two ORACLE_HOME is set in the nagios user environment when I su - nagios, and three sqlplus is in the nagios user's path and I can do sqlplus user/[EMAIL PROTECTED] and successfully get a login prompt on the database server. What is going on? -h - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ 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] Oracle plugin check_oracle
On Mon, Jul 10, 2006 at 05:57:08PM +0100, Hari Sekhon wrote: Cannot determine ORACLE_HOME for sid dbname with status UNKNOWN This happened to me before but since it was working earlier I don't see how this could have broken... Soemthing must have changed... For one, why do I need ORACLE_HOME, sql/plus requires this since it uses it to find the tnsnames.ora file as well as the location of the error messages translation file. nagios user environment when I su - nagios, and three sqlplus is in the nagios user's path and I can do sqlplus user/[EMAIL PROTECTED] and successfully get a login prompt on the database server. How does it get in the nagios users's path? Could Nagios have been restarted in such a way that the profile or whatever didn't get sourced? -Jason Martin -- This message is PGP/MIME signed. pgplPqrqM8MzK.pgp Description: PGP signature - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ 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] Oracle plugin check_oracle
On 10/07/06, Jason Martin [EMAIL PROTECTED] wrote: On Mon, Jul 10, 2006 at 05:57:08PM +0100, Hari Sekhon wrote: Cannot determine ORACLE_HOME for sid dbname with status UNKNOWN This happened to me before but since it was working earlier I don't see how this could have broken... Soemthing must have changed... For one, why do I need ORACLE_HOME, sql/plus requires this since it uses it to find the tnsnames.ora file as well as the location of the error messages translation file. nagios user environment when I su - nagios, and three sqlplus is in the nagios user's path and I can do sqlplus user/[EMAIL PROTECTED] and successfully get a login prompt on the database server. How does it get in the nagios users's path? Could Nagios have been restarted in such a way that the profile or whatever didn't get sourced? -Jason Martin -- This message is PGP/MIME signed. I would expect that to be it as well but it's strange to see this. I rebooted nagios and it started working properly again. It started happening just after making a completely unrelated change to a mysql check and rebooting nagios. This sounds suspicious but at that same time as soon as it started giving me warning UNKNOWN for the status of the oracle machines, I immediately tried sqlplus username/[EMAIL PROTECTED] from the nagios user and it worked normally and logged me in... and echo $ORACLE_HOME gave me the path to the oracle client installation... so why did the check stop working? - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ 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] Oracle plugin check_oracle
Hi, has anybody got the check_oracle plug-in working? I usually try to do this stuff from the command line first to see how it works before creating the check_command definition but it's not working for this plug-in. The error I get is: ./check_oracle --tns 192.168.1.99 Cannot determine ORACLE_HOME for sid 192.168.1.99 Which according to --help is supposed to check a remote oracle server, so why on earth is it asking for ORACLE_HOME, when this machine has no oracle on it and won't have a home? The same happens when using the tns name (which also resolves via dns). Anybody got any ideas? Hari Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ 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] Oracle plugin check_oracle
First, you must install oracle client and put oracle directory in the path.Bernardo.2006/7/4, Hari Sekhon [EMAIL PROTECTED]: Hi,has anybody got the check_oracle plug-in working? I usually try to dothis stuff from the command line first to see how it works before creating the check_command definition but it's not working for thisplug-in. The error I get is:./check_oracle --tns 192.168.1.99Cannot determine ORACLE_HOME for sid 192.168.1.99Which according to --help is supposed to check a remote oracle server,so why on earth is it asking for ORACLE_HOME, when this machine has nooracle on it and won't have a home? The same happens when using the tns name (which also resolves via dns).Anybody got any ideas?HariUsing Tomcat but need to do more? Need to support web services, security?Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimohttp://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___Nagios-users mailing listNagios-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 Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642___ 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] Oracle plugin check_oracle
On Tue, Jul 04, 2006 at 04:49:42PM +0100, Hari Sekhon wrote: has anybody got the check_oracle plug-in working? I usually try to do this stuff from the command line first to see how it works before creating the check_command definition but it's not working for this plug-in. The error I get is: ./check_oracle --tns 192.168.1.99 Cannot determine ORACLE_HOME for sid 192.168.1.99 Which according to --help is supposed to check a remote oracle server, so why on earth is it asking for ORACLE_HOME, when this machine has no oracle on it and won't have a home? The same happens when using the tns name (which also resolves via dns). check_oracle is a shell script that calls tnsping or sqlplus to do its work. It requires that the oracle client utilities be installed for it to work. You need to either run this via ssh/NRPE or install Oracle on the host initiating the check. -Jason Martin -- Captain, why not just give the Borg Windows? - Worf This message is PGP/MIME signed. pgpGR0PszAA8b.pgp Description: PGP signature Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642___ 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] Oracle plugin check_oracle
Jason Martin wrote: On Tue, Jul 04, 2006 at 04:49:42PM +0100, Hari Sekhon wrote: has anybody got the check_oracle plug-in working? I usually try to do this stuff from the command line first to see how it works before creating the check_command definition but it's not working for this plug-in. The error I get is: ./check_oracle --tns 192.168.1.99 Cannot determine ORACLE_HOME for sid 192.168.1.99 Which according to --help is supposed to check a remote oracle server, so why on earth is it asking for ORACLE_HOME, when this machine has no oracle on it and won't have a home? The same happens when using the tns name (which also resolves via dns). check_oracle is a shell script that calls tnsping or sqlplus to do its work. It requires that the oracle client utilities be installed for it to work. You need to either run this via ssh/NRPE or install Oracle on the host initiating the check. -Jason Martin oh bummer, thanks guys. is there a better binary plug-in anywhere that doesn't have these dependencies? It would be nice to get this working... -h Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642___ 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] Oracle plugin check_oracle
Hari Sekhon wrote: is there a better binary plug-in anywhere that doesn't have these dependencies? It would be nice to get this working... Don't know about a binary plugin doing this. The Oracle Instantclient (sqlplus) is available here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html When using Gentoo, you can install it using emerge oracle-instantclient-sqlplus. Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ 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] Oracle plugin check_oracle
Elias Probst wrote: Hari Sekhon wrote: is there a better binary plug-in anywhere that doesn't have these dependencies? It would be nice to get this working... Don't know about a binary plugin doing this. The Oracle Instantclient (sqlplus) is available here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html When using Gentoo, you can install it using "emerge oracle-instantclient-sqlplus". Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ 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, good guess I'm using gentoo, the link you provided seems broken though, and emerge has it listed as a restricted package so I have to fetch it manually, how 90s... but the link emerge has given me seems to work... Thanks again, you've got the ball rolling ! -h Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642___ 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] Oracle plugin check_oracle
Don't know about a binary plugin doing this. The Oracle Instantclient (sqlplus) is available here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/ linuxsoft.html [snip] The check_oracle client won't work with just the Instant Client, because it doesn't include tnsping. Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ 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] Oracle plugin check_oracle
oh bummer, thanks guys. is there a better binary plug-in anywhere that doesn't have these dependencies? Trying to recreate the Oracle client within a plugin would probably be more trouble than it's worth. If all you want to know is if the database is listening, you can always just do a TCP check against the TNS listener port. If you want anything really conclusive, though, you're going to need to connect to the database with an Oracle client one way or another. Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ 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] Oracle plugin check_oracle
On 4 Jul 2006, at 18:41, Morris, Patrick wrote:Don't know about a binary plugin doing this. The Oracle Instantclient (sqlplus) is available here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/ linuxsoft.html [snip] The check_oracle client won't work with just the Instant Client, because it doesn't include tnsping. When I've used check_oracle, I use the --login option instead of --tnsping. This simulates a login, and returns OK if it gets a "invalid login, incorrect username/password". This is a better check because it goes down the entire stack and grabs whatever errors are returned by Oracle (for instance, "shutdown in progress").I assume the Instantclient will still work with check_oracle (as it just needs sqlplus).Tonhttp://www.altinity.comT: +44 (0)870 787 9243F: +44 (0)845 280 1725Skype: tonvoon Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642___ 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] Oracle plugin check_oracle
Ton Voon wrote: On 4 Jul 2006, at 18:41, Morris, Patrick wrote: Don't know about a binary plugin doing this. The Oracle Instantclient (sqlplus) is available here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/ linuxsoft.html [snip] The check_oracle client won't work with just the Instant Client, because it doesn't include tnsping. When I've used check_oracle, I use the --login option instead of --tnsping. This simulates a login, and returns OK if it gets a "invalid login, incorrect username/password". This is a better check because it goes down the entire stack and grabs whatever errors are returned by Oracle (for instance, "shutdown in progress"). I assume the Instantclient will still work with check_oracle (as it just needs sqlplus). Ton http://www.altinity.com T: +44 (0)870 787 9243 F: +44 (0)845 280 1725 Skype: tonvoon Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ 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 yes this is probably what i'll do as well -h Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642___ 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