Hari Sekhon wrote: > On 10/07/06, Jason Martin <[EMAIL PROTECTED]> wrote: >> On Mon, Jul 10, 2006 at 05:57:08PM +0100, Hari Sekhon wrote: >> > "Cannot determine ORACLE_HOME for sid <dbname>" with status UNKNOWN >> > This happened to me before but since it was working earlier I don't >> > see how this could have broken... >> Soemthing must have changed... >> >> >> > For one, why do I need ORACLE_HOME, >> sql/plus requires this since it uses it to find the tnsnames.ora >> file as well as the location of the error messages translation >> file. >> >> > nagios user environment when I "su - nagios", and three sqlplus is in >> > the nagios user's path and I can do "sqlplus <user/[EMAIL PROTECTED]>" >> > and successfully get a login prompt on the database server. >> How does it get in the nagios users's path? Could Nagios have >> been restarted in such a way that the profile or whatever didn't >> get sourced? >> >> -Jason Martin >> -- >> This message is PGP/MIME signed. >> >> >> > > I would expect that to be it as well but it's strange to see this. I > rebooted nagios and it started working properly again. > > It started happening just after making a completely unrelated change > to a mysql check and rebooting nagios. > > This sounds suspicious but at that same time as soon as it started > giving me warning UNKNOWN for the status of the oracle machines, I > immediately tried > > sqlplus "username/[EMAIL PROTECTED]" > > from the nagios user and it worked normally and logged me in... and > > echo $ORACLE_HOME > > gave me the path to the oracle client installation... > > so why did the check stop working? > It's happened again, I changed a non-related service name and then restarted nagios and now again it doesn't find $ORACLE_HOME for the sids of the databases apparently. This is ridiculous since I can
su - nagios echo $ORACLE_HOME /usr/lib/oracle/10.2.0.2/client which gives me the path to the oracle client installation and I can also sqlplus "user/[EMAIL PROTECTED]" successfully and get a login. /usr/nagios/libexec/check_oracle --login dbname OK - dummy login connected Does anybody understand why this check has stopped working again when I haven't done anything to it, I have to get this working in a stable fashion, I can't have it doing this every time I restart nagios... -h ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Nagios-users mailing list Nagios-users@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
