Nagios Support Forum

Hello,

We have installed Oracle plugin using this doc:
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

Installation was successful but we are not able to monitor Oracle DB. Attaching the command and Output for same:

ORACLE VERSION = 12C

[root@incrpvmnagios lib]# echo $LD_LIBRARY_PATH
/usr/lib/oracle/12.2/client64/lib
[root@incrpvmnagios lib]# echo $ORACLE_HOME
/usr/lib/oracle/12.2/client64
[root@incrpvmnagios lib]# !/usr
/usr/local/nagios/libexec/check_oracle_health --connect "152.63.1.229:1522/ggpulse" --username system --password "manager" --mode connected-users --warning 50 --critical 100
Use of qw(...) as parentheses is deprecated at /usr/local/nagios/libexec/check_oracle_health line 4162.
Use of qw(...) as parentheses is deprecated at /usr/local/nagios/libexec/check_oracle_health line 6166.
CRITICAL - cannot connect to 152.63.1.229:1522/ggpulse. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)
[root@incrpvmnagios lib]#

That response is coming from the Oracle server itself. Here's documentation on the error:
https://docs.oracle.com/cd/B19306_01/se ... t12500.htm

The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.

It would appear as though the Oracle server either does not know of the ggpulse service, or the service is not included in the current connection context.

I would suggest consulting with your Oracle database admins on this matter.

Thanks @mcapra