Page 1 of 1
Monitoring Oracle Database-facing problem
Posted: Mon Apr 28, 2014 1:12 am
by nagiostool
Hi,
I have tried to configured Oracle database using Oracle Serverspace wizard. I'm getting the following error when configured.
CRITICAL - cannot connect to 172.17.43.94:1521/contorl1. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)
Any help regarding this ?
Re: Monitoring Oracle Database-facing problem
Posted: Mon Apr 28, 2014 2:30 am
by nagiostool
i have tried to execute the below command from Nagios XI server command line but got as Cannot determine ORACLE_HOME for sid <sid>
/usr/local/nagios/libexec/check_oracle --tns <sid>
Re: Monitoring Oracle Database-facing problem
Posted: Mon Apr 28, 2014 1:15 pm
by scottwilkerson
Please see this guide
Code: Select all
http://assets.nagios.com/downloads/nagiosxi/docs/Oracle_Plugin_Installation.pdf
You will see you need to add the variables to the path such as
Code: Select all
/usr/bin/env ORACLE_HOME=/usr/lib/oracle/11.2/client LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib /usr/local/nagios/libexec/check_oracle --tns <sid>
Re: Monitoring Oracle Database-facing problem
Posted: Tue May 06, 2014 1:53 am
by nagiostool
I'm getting the same error.
I have a doubt, should we install the Oracle Version which we need to monitor or the latest Oracle Version ?
Re: Monitoring Oracle Database-facing problem
Posted: Tue May 06, 2014 9:36 am
by abrist
What is the full command you are attempting to use for the check?