Monitoring Oracle Database-facing problem

[nagiostool]

Hi,

I have tried to configured Oracle database using Oracle Serverspace wizard. I'm getting the following error when configured.

CRITICAL - cannot connect to 172.17.43.94:1521/contorl1. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)

Any help regarding this ?

[nagiostool]

i have tried to execute the below command from Nagios XI server command line but got as Cannot determine ORACLE_HOME for sid <sid>

/usr/local/nagios/libexec/check_oracle --tns <sid>

[scottwilkerson]

Please see this guide

Code: Select all

http://assets.nagios.com/downloads/nagiosxi/docs/Oracle_Plugin_Installation.pdf

You will see you need to add the variables to the path such as

Code: Select all

/usr/bin/env ORACLE_HOME=/usr/lib/oracle/11.2/client LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib /usr/local/nagios/libexec/check_oracle --tns <sid>

[nagiostool]

I'm getting the same error.

I have a doubt, should we install the Oracle Version which we need to monitor or the latest Oracle Version ?

[abrist]

What is the full command you are attempting to use for the check?