issue with check_oracle and check_by_ssh
Thierry Lacoste
lacoste at miage.univ-paris12.fr
Tue Nov 6 12:22:04 CET 2007
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
More information about the Users
mailing list