Check_oracle

[Mohan, Ajit (CFSA)]

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:jbenson at netdeposit.com] 
Sent: Wednesday, June 21, 2006 3:33 PM
To: Mohan, Ajit (CFSA)
Cc: nagios-users at 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:John.Furlong at dsl.pipex.com]
> *Sent:* Wednesday, June 21, 2006 3:18 PM
> *To:* Mohan, Ajit (CFSA); nagios-users at 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) (Ajit.Mohan at dc.gov) 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 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
> 
> 
> 
> 
> postie at dsl.pipex.com
> 
> 
>
------------------------------------------------------------------------
> 
> 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 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


-- 
Joe Benson
NetDeposit
4141 South Highland Dr.
Suite 220
Salt Lake City, UT 84124
801-273-6031
jbenson at netdeposit.com

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