Nagios Support Forum

Hello,

Trying to configure monitoring for Oracle box. Was able successively install all RPM according to this doc: http://assets.nagios.com/downloads/nagi ... lation.pdf
Initial error was: CRITICAL - cannot connect to x.x.x.x:1521. ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA (DBD ERROR: OCIServerAttach)
After I modified line to: x.x.x.x:1521/Service_name
Getting new error:

COMMAND: /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client /usr/local/nagios/libexec/check_oracle_health --connect "x.x.x.x:1521/name" --username user --password "pass" --mode sga-data-buffer-hit-ratio --warning 98: --critical 95:
OUTPUT: CRITICAL - cannot connect to x.x.x.x:1521/name. ORA-21561: OID generation failed (DBD ERROR: OCISessionBegin)

Some people had same issue because of wrong client version 64/32 bit. In my case it's CentOS i386 and client i386 as well.

Please help.

Thanks

Did your DBA setup the tnsnames.ora and listener.ora on the Oracle server?

Here is some basic information, but your Oracle Administrator will have to set this up.

http://www.oracle-base.com/articles/mis ... ration.php

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

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

Oracle has listener and tnsnames
After I configured tnsname.ora file on Nagios Server I am getting now: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach)

Thanks

did you configure the listener as well?

Yes it's configured on the Oracle server itself. I dont it on Nagios right?

After you configured the listener, did you try running the same command?
Are you still getting the same output?