Oracle Plugin timeout

[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

[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?

[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

[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

[maxwellmiranda]

the plugin times out from commandline as well...this is the only error i get

[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?

[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>

[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 )?

[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.....

[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?