Check_oracle

[Joe Benson]

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