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=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 > > > > > [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