Monitoring remote server oracle from nagios server using check_oracle_health

[Steven Carr]

What do you have in your tnsnames.ora file for the database you are trying
to connect to?

http://www.orafaq.com/wiki/Tnsnames.ora
http://docs.oracle.com/cd/B28359_01/network.111/b28317/tnsnames.htm

Steve


On 25 January 2013 02:08, Yu Watanabe <yu.watanabe at jp.fujitsu.com> wrote:

> Hi all.
>
> I have some trouble executing check_oracle_health. It would be helpful if
> someone can help me out.
>
> I have successfully compiled both ORACLE DBD and check_oracle_health on a
> nagios server.
> And as a test , I am trying to execute tnsping to the remote oracle server.
>
> Whenever I execute the plugin , I get the follwoing error.
>
> check_oracle_health --connect=xe --user=system --password=root
> --mode=connection-time
> CRITICAL - cannot connect to xe. ORA-12154: TNS:could not resolve the
> connect identifier specified (DBD ERROR: OCIServerAttach)
>
> The error it self is obvious that its because remote ip address is not
> defined.
>
> Does anyone know where can you defien the info about address or hostname?
>
> Thanks,
> Yu
>
>
>
> ------------------------------------------------------------------------------
> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. ON SALE this month only -- learn more at:
> http://p.sf.net/sfu/learnnow-d2d
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20130125/28f63de5/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
-------------- next part --------------
_______________________________________________
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