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]#
Oracle Monitoring Issue
Re: Oracle Monitoring Issue
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
I would suggest consulting with your Oracle database admins on this matter.
https://docs.oracle.com/cd/B19306_01/se ... t12500.htm
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.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.
I would suggest consulting with your Oracle database admins on this matter.
Former Nagios employee
https://www.mcapra.com/
https://www.mcapra.com/
-
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
- Contact: