Oracle Query Wizard

[sujitt]

Oracle query wizard returned out of bounds exception to check with error 127
when i looked with the command config I see that it is using check_oracle_health and I do not see a check_oracle_health plug-in in the directory
/usr/local/nagios/libexec.

I do not see a download option on the exchange and the web site http://labs.consol.de/nagios/check_oracle_health is unreachable. what are my options?

[sreinhardt]

The download is a little hidden but still there. It's about a quarter of the way down the page, just search the page for check_oracle_health-1.7.8.1.tar.gz. You are correct that the 127 error is that the plugin is missing or unaccessable.

[sujitt]

I am unable to find it. Could you post a link to the archive please.
the one I downloaded from http://git.mathias-kettner.de/git/?p=om ... a74cf9e266
i was not able to untar it. do you have a different link i could use? I thought this was part of the wizard. why is it missing?

[slansing]

The download button is right in the installation section.. Here is the link:

http://labs.consol.de/download/shinken- ... 8.1.tar.gz

If you did have the plugin it would be right where you were looking:

Code: Select all

/usr/local/nagios/libexec

Though I recommend you follow our guide on this:

http://assets.nagios.com/downloads/nagi ... lation.pdf

There are a number of things you will need to do to get off the ground and monitoring oracle.

[sujitt]

I have already setup the plug in now I am unable to connect with various different error messages due to connection string issues.
within the wizard how do I provide a connect string
there is the spots for Hostname , port and database name. where do you provide service name.

I have a wierd error coming up when I try through command line after research where ./check_oracle_health -connect <host>:1521/<servicename> --username..

the error says
CRITICAL - cannot connect to agasc41u:1521/MBLPR01. ORA-21561: OID generation failed (DBD ERROR: OCISessionBegin)

[abrist]

Are you using the download from console labs or did you follow our document?

[sujitt]

I downloaded plug-in from http://git.mathias-kettner.de/git/?p=om ... a74cf9e266
and followed your doc for install of clients and config.

[slansing]

Please take a look at this post and verify that you have "hosts" set correctly:

http://sourceforge.net/p/tora/discussio ... d/f68b89ad

[sujitt]

The query wizard is very non intuitive. you need to change the database field or another field to specify system id or SID .
because the connection string should be like <host>:<port>/<SID>. It took me a long time to figure this out. No document is defining this.
Now within the wizard I had to specify <port>/<SID> for the wizrd to configure correctly. Please add this to changes for the wizard.

It was not a pleasant experience with the wizards in my proof of concept for nagios. needs a lot of improvement.