issue with check_oracle and check_by_ssh

[Thierry Lacoste]

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
Nagios-users at lists.sourceforge.net
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