Oracle Monitoring Issue

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
vinish098
Posts: 136
Joined: Fri Oct 21, 2016 6:30 am

Oracle Monitoring Issue

Post by vinish098 »

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]#
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: Oracle Monitoring Issue

Post by mcapra »

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.
Former Nagios employee
https://www.mcapra.com/
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Oracle Monitoring Issue

Post by scottwilkerson »

Thanks @mcapra
Former Nagios employee
Creator:
ahumandesign.com
enneagrams.com
Locked