Page 1 of 2
Oracle Plugin timeout
Posted: Thu Jan 24, 2013 4:09 pm
by maxwellmiranda
i am trying to configure monitoring services in Nagios for our Oracle database servers. but the plugins are timing out.
i am able to ping to the servers but none of the plugins are returning results. i have the SSH port open between these servers...
is there anything else that i have to take care of
Re: Oracle Plugin timeout
Posted: Thu Jan 24, 2013 5:20 pm
by sreinhardt
Which particular Oracle check(s) are you using? Are you certain that the Nagios host and user have been allowed access to the Oracle servers?
Re: Oracle Plugin timeout
Posted: Fri Jan 25, 2013 11:37 am
by maxwellmiranda
yes....SSH access has been set up between these servers and nagios XI server...
also i can SSH to these servers from NAGIOS ( password-less access)
i am using check_oracle_health plugin.....
i have successfully set it up on our other server
Re: Oracle Plugin timeout
Posted: Fri Jan 25, 2013 11:44 am
by slansing
What is the exact error you are receiving from the checks...
Make sure to test them from the Nagios command line and get that working first.. I assume that you did follow this guide when integrating the plugins with the Oracle system, and ran into 'none' of the errors listed in the document?..
http://assets.nagios.com/downloads/nagi ... lation.pdf
Re: Oracle Plugin timeout
Posted: Fri Jan 25, 2013 11:49 am
by maxwellmiranda
the plugin times out from commandline as well...this is the only error i get
Re: Oracle Plugin timeout
Posted: Fri Jan 25, 2013 11:51 am
by slansing
But what is the error you are receiving, please copy and paste it from the command line. How do you have the command defined?
Re: Oracle Plugin timeout
Posted: Fri Jan 25, 2013 1:08 pm
by maxwellmiranda
/usr/bin/env TNS_ADMIN=/usr/lib/oracle/11.2/client/network/admin LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = plmhau.bose.com)(PORT = 1527)))(CONNECT_DATA =(SID = PLP)))" --username nagios --password "nagios" --mode tnsping
CRITICAL - connection could not be established within 60 seconds
nagusgrd1:/usr/lib/oracle/11.2/client64>
Re: Oracle Plugin timeout
Posted: Fri Jan 25, 2013 3:37 pm
by scottwilkerson
I know you mentioned you have the ssh port open, but do you have the port your --connect is set to talk on open ( 1527 )?
Re: Oracle Plugin timeout
Posted: Fri Jan 25, 2013 4:17 pm
by maxwellmiranda
Can you provide me with information on what all ports are used in setting up monitoring from NagiosXI server to other hosts....
i understand that 1521/1527 would be needed in my case where we are setting up oracle monitoring.....
Re: Oracle Plugin timeout
Posted: Fri Jan 25, 2013 4:57 pm
by sreinhardt
There could be any number of ports that are needed, nrpe, nsca, nrds, and nrdp all use different ports and protocols. In addition to checking http, ssh, sql or any number of other checks from the nagios machine directly would also use different ports and protocols. Could you be more specific in what you are looking for or what you are using and need to have ports opened for?