oracke monitoring

[Brian Sudis]

 If you have the NRPE client installed on your oracle platform you can
run check_procs against the smon process to ensure the database is up.

-----Original Message-----
From: nagios-users-admin at lists.sourceforge.net
[mailto:nagios-users-admin at lists.sourceforge.net] On Behalf Of Evgeny
Stepanov
Sent: Wednesday, March 22, 2006 3:02 AM
To: Nagios-users at lists.sourceforge.net
Subject: [Nagios-users] oracke monitoring

Nagios-users at lists.sourceforge.net !

hello, people!

we are using nagios to monitor our network resources very effectively.
nagios is running under FreeBSD. It works as a breeze, thanks
developers.

we also check several Oracle servers among other things.
Couple of days ago i faced the situation when oracle listener was
working but database instance was broken. The problem is that i don't
have oracle client installed on nagios host, so i check only oracle host
is alive and TCP port 1521 is open. Obviously this is not enough for
Oracle checking. I don't have possibility to install oracle client on
nagios host due to several reasons.
So i look towards 2 schemes of monitoring:
1. to find some "light" oracle client (oh, i forgot to say, that oracle
database is v.8, so 10g client doesn't work with it and 9i is _very_ big
and it's installation on FreeBSD requires skills i don't have :-() it
can be done with kylix and dbexpress through core lab oracle driver (i
have such experience on linux), but this approach requires proprietary
stuff i don't have and kylix doesn't work on FreeBSD. So is there some
"light"
oracle client or similar that can be used in shell scripts (like
sqlplus), open (or free at least)?

2. to find any machine with oracle client installed and implement
monitoring through nrpe (or nsclient++ that i use on windows machines)
with shell scripting (or cygwin) or wscript or whatever.

maybe some other way i don't see. Do you guys have any suggestions for
my case?

---
best regards
Evgeny Stepanov



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding
territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
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


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
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