Oracle Plugin Issue

[vendor-support]

I just setup the latest Nagios XI version for evaluation on a newly install CentOS 6.5 (minimal) and an having issues trying to get the Oracle monitoring working. I have followed the instructions at:
http://assets.nagios.com/downloads/nagi ... lation.pdf

At first it wasn't working, but I found on this forum that I had to change the ORACLE_HOME and LD_CONFIG_PATH for the check commands (Configure -> CCM -> commands -> check_xi_oraclequery / check_xi_oracleserverspace / check_xi_oracletablespace) to:

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib ORACLE_HOME=/usr/lib/oracle/12.1/client64

I now get the following error:
CRITICAL - cannot connect to xxx.xxx.xxx.xxx:1521/sid. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)

the only thing I found was a possbile issue with tnsnames.ora which didn't exist on the Nagios server so I had to create the network/admin directories in the oracle home and made a tnsnames.ora file but still getting the same error.

I do not know where to go from here, is there a config issue on the Nagios server still or the Oracle server? Any help would be greatly appreciated.

[abrist]

he only thing I found was a possbile issue with tnsnames.ora which didn't exist on the Nagios server

It should not exist on the nagios server, but on the oracle server (it probably already exists).

I now get the following error:
CRITICAL - cannot connect to xxx.xxx.xxx.xxx:1521/sid. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)

You need to edit the listener file on the oracle server to include the nagios server:
http://www.orafaq.com/wiki/Tnsnames.ora
This is something your dba should be able to do.

[vendor-support]

Yes thank you for your response, I figured it out last night just by chance... I wish the documentation was just a little more clear. It turns out the tnsnames.ora on the oracle server had a different SID descriptor that I had to change to match on the Nagios server.