Can you tnsping the oracle SID? The check_oracle plugin uses tnsping. If it works than the monitor should also. Make sure the Oracle env variables are set for the user that nagios runs as.
Mohan, Ajit (CFSA) wrote: > Yes I am able to telnet on port 1521. Both the nagios and the oracle > server are on the same LAN. > > -----Original Message----- > From: Joe Benson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 21, 2006 3:33 PM > To: Mohan, Ajit (CFSA) > Cc: nagios-users@lists.sourceforge.net > Subject: Re: [Nagios-users] Check_oracle > > Can you telnet to the oracle server on port 1521 ? ( I'm assuming you > are running on the default port). If not make sure the listener is > running. The database can be up without the listener running. It also > could be a firewall issue. > > Joe > > Mohan, Ajit (CFSA) wrote: >> Command I am running is "/usr/local/nagios/libexec/check_oracle -tns >> XXX" . Where XXX is the DB/INSTANCE name of the database >> >> I am running this command on the Nagios server and trying to monitor a > >> remote Oracle 9i database >> >> >> >> The env variables set are >> >> /usr/local/nagios/libexec> env | grep "ORA" >> >> ORACLE_SID=XXX >> >> ORACLE_BASE=/opt/oracle >> >> ORA_NLS33=/opt/oracle/product/9ir2/ocommon/nls/admin/data >> >> ORACLE_HOME=/opt/oracle/product/9ir2 >> >> >> >> > ------------------------------------------------------------------------ >> *From:* John Furlong [mailto:[EMAIL PROTECTED] >> *Sent:* Wednesday, June 21, 2006 3:18 PM >> *To:* Mohan, Ajit (CFSA); nagios-users@lists.sourceforge.net >> *Subject:* Re: [Nagios-users] Check_oracle >> >> >> >> >> What's the full command you're running - check_oracle -WHAT ? >> >> Are you running the check_oracle on the system running Oracle or > another >> box ? >> >> Postie. >> >> On 21/6/06 19:36, Mohan, Ajit (CFSA) ([EMAIL PROTECTED]) wrote: >> >> Hi, >> >> I am trying to monitor the oracle database using the "check_oracle" >> plugin. I have installed Oracle client on the machine and configured > the >> TNSNAMES.ORA file to point to the oracle server. However when I try to > >> test the connection using "check_oracle" I get the below error > message. >> I have verified the ORA_HOME and the TNSNAMES use the IP address of > the >> Oracle server >> >> */"No TNS Listener on XXX" >> /* >> The database is up and running >> >> Any ideas? >> >> Thank you >> >> > ------------------------------------------------------------------------ >> All the advantages of Linux Managed Hosting--Without the Cost and > Risk! >> Fully trained technicians. The highest number of Red Hat > certifications in >> the hosting industry. Fanatical Support. Click to learn more >> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642 > > <http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=12164 > 2> >> > ------------------------------------------------------------------------ >> _______________________________________________ >> 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 >> >> >> >> >> [EMAIL PROTECTED] >> >> >> > ------------------------------------------------------------------------ >> All the advantages of Linux Managed Hosting--Without the Cost and > Risk! >> Fully trained technicians. The highest number of Red Hat > certifications in >> the hosting industry. Fanatical Support. Click to learn more >> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&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 > > -- Joe Benson NetDeposit 4141 South Highland Dr. Suite 220 Salt Lake City, UT 84124 801-273-6031 [EMAIL PROTECTED] All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&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
