Nagios Support Forum

Hi,

1. When using check_oracle_health-3.1.0.3 to check Oracle Server, the status information reply error(see below), how to fix that?

2. How to setup tnsnames.ora?


ORACLE_HOME=/usr/lib/oracle/12.2/client64​
LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib

https://imgur.com/a/D0PDeo9
https://imgur.com/a/aIg3ZEx


​​1. check_xi_oraclequery
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib ORACLE_HOME=/usr/lib/oracle/12.2/client64 $USER1$/check_oracle_health $ARG1$

2. check_xi_oracleserverspace
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib ORACLE_HOME=/usr/lib/oracle/12.2/client64 $USER1$/check_oracle_health $ARG1$

3. check_xi_oracletablespace
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib ORACLE_HOME=/usr/lib/oracle/12.2/client64 $USER1$/check_oracle_health $ARG1$

4.
https://imgur.com/a/vYbTF8Y
https://imgur.com/a/iN9dZC1

Your Oracle Administrator will have to set this up. Here's some basic information:

https://oracle-base.com/articles/misc/o ... figuration

http://www.orafaq.com/wiki/Tnsnames.ora

http://www.orafaq.com/wiki/Listener.ora