I have two linux boxes with oracle. I'd like to make them cross-check_oracle each other with check_by_ssh from my nagios host.
Both oracle boxes have the following tnsnames.ora SID10 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = hostA)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SID10INT) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = hostB)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) Host A has oracke 10.1.0 and Host B has oracle 10.2.0 Form my nagios host I have no problem to make Host A check it's local db as well as the remote db: ./check_by_ssh -l oracle -H IP.OF.HOST.A -i /var/spool/nagios/.ssh/id_rsa -C "/usr/lib/nagios/plugins/check_oracle --tns sid10" OK - reply time 0 msec from sid10 ./check_by_ssh -l oracle -H IP.OF.HOST.A -i /var/spool/nagios/.ssh/id_rsa -C "/usr/lib/nagios/plugins/check_oracle --tns orcl" OK - reply time 10 msec from orcl With Host B I can check it's own db but not the remote one: ./check_by_ssh -l oracle -H IP.OF.HOST.B -i /var/spool/nagios/.ssh/id_rsa -C "/usr/lib/nagios/plugins/check_oracle --tns orcl" OK - reply time 0 msec from orcl ./check_by_ssh -l oracle -H IP.OF.HOST.B -i /var/spool/nagios/.ssh/id_rsa -C "/usr/lib/nagios/plugins/check_oracle --tns sid10" Cannot determine ORACLE_HOME for sid sid10 Now from a terminal on Host B as user oracle: /usr/lib/nagios/plugins/check_oracle --tns orcl OK - reply time 0 msec from orcl /usr/lib/nagios/plugins/check_oracle --tns sid10 OK - reply time 10 msec from sid10 Any idea what's going wrong? Regards, Thierry. ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Nagios-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
