Nagios Support Forum

Hello,
My company is currently having me evaluate your product for use. My current issue is that I'm having trouble connecting to my database and running a mere tablespace check.

I am running the 64bit VM, installed on a Redhat 64 bit server. I have the oracle client installed as the manual suggested and imported my tnsnames.ora file into the $ORACLE_HOME/network/admin, and set the TNS_ADMIN variable. SQLPLUS connection to the database instance is working and pulling info from the USERS tablespace is working.

Errors are ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach)

Also, how do I monitor a specific tablespace such as USERS, if I cannot specify the SID in the oracle tablespace wizard?

Thanks

What is the full check command that you have setup in XI?

the full check command is the one that comes standard. I read it and it doesn't make sense to me. In the wizard for the oracle_tablespace wizard, it only asks for the server and tablespace name, however where do I put in the SID? Also, the documentation for the check_oracle_health has far more arguments. Is the standard check definition not enough?


/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client $USER1$/check_oracle_health $ARG1$

I apologize, I want to see the full check, including your connect string. I am mostly checking syntax, so feel free to obfuscate.

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 $USER1$/check_oracle_health --connect=$ARG1$ --username=$ARG2$ --password=$ARG3$ --mode=$ARG4$ --tablespace=$ARG5$

I figured my first question; the oracle_tablespace wizard is faulty and doesn't allow you to input enough arguments to do anything useful. Instead I modified the command string up above to include more and use the check_oracle_health plugin better.

Now my question is, how do I attain trends/graphs out of this?

So just to verify, you have this working minus graphing?

To answer about graphing, that is more up to the plugin than nagios. If you were to execute the plugin via cli and look at the output returned, at the end of the return message you see in nagios is there a "|" and additional data? In nagios any data after a | in object=value format will be included as performance data and graphable. If the plugin does not have this functionality, there isn't too much we can do. Some plugins do require you to use an additional flag to return this data.