<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!--P{margin-top:0;margin-bottom:0;} .ms-cui-menu {background-color:#ffffff;border:1px rgb(166, 166, 166) solid;font-family:"Segoe UI","Segoe WP","Segoe UI WPC",Tahoma,Arial,sans-serif;font-size:10pt;color:rgb(51, 51, 51);} .ms-cui-menusection-title {display:none;} .ms-cui-ctl {vertical-align:text-top;text-decoration:none;color:rgb(51, 51, 51);} .ms-cui-ctl-on {background-color:rgb(205, 230, 247);opacity: 0.8;} .ms-cui-img-cont-float {display:inline-block;margin-top:2px} .ms-cui-smenu-inner {padding-top:0px;} .ms-owa-paste-option-icon {margin: 0px 6px 0px 6px;vertical-align:middle!important;padding-bottom: 2px;display:inline-block;} .ms-rtePasteFlyout-option:hover {background-color:rgb(205, 230, 247) !important;opacity:1 !important;} .ms-rtePasteFlyout-option {padding:8px 4px 8px 4px;outline:none;} .ms-cui-menusection {float:left; width:85px;height:24px;overflow:hidden}.wf {speak:none; font-weight:normal; font-variant:normal; text-transform:none; -webkit-font-smoothing:antialiased; vertical-align:middle; display:inline-block;}.wf-family-owa {font-family:'o365Icons'}@font-face { font-family:'o365IconsIE8'; src:url('prem/15.0.995.34/resources/styles/office365icons.ie8.eot?#iefix') format('embedded-opentype'), url('prem/15.0.995.34/resources/styles/office365icons.ie8.woff') format('woff'), url('prem/15.0.995.34/resources/styles/office365icons.ie8.ttf') format('truetype'); font-weight:normal; font-style:normal;}@font-face { font-family:'o365IconsMouse'; src:url('prem/15.0.995.34/resources/styles/office365icons.mouse.eot?#iefix') format('embedded-opentype'), url('prem/15.0.995.34/resources/styles/office365icons.mouse.woff') format('woff'), url('prem/15.0.995.34/resources/styles/office365icons.mouse.ttf') format('truetype'); font-weight:normal; font-style:normal;}.wf-family-owa {font-family:'o365IconsMouse'}.ie8 .wf-family-owa {font-family:'o365IconsIE8'}.ie8 .wf-owa-play-large:before {content:'\e254';}.notIE8 .wf-owa-play-large:before {content:'\e054';}.ie8 .wf-owa-play-large {color:#FFFFFF/*$WFWhiteColor*/;}.notIE8 .wf-owa-play-large {border-color:#FFFFFF/*$WFWhiteColor*/; width:1.4em; height:1.4em; border-width:.1em; border-style:solid; border-radius:.8em; text-align:center; box-sizing:border-box; -moz-box-sizing:border-box; padding:0.1em; color:#FFFFFF/*$WFWhiteColor*/;}.ie8 .wf-size-play-large {width:40px; height:40px; font-size:30px}.notIE8 .wf-size-play-large {width:40px; height:40px; font-size:30px}.notIE8 .wf-owa-triangle-down-small:before {content:'\e052';}.ie8 .wf-owa-triangle-down-small:before { content:'\e052';}.ie8 .wf-owa-triangle-down-small {color:#666666/*$WFGreyColor*/;}.wf-size-x20 {font-size: 20px!important;}
<!--
@font-face
{font-family:Calibri}
@font-face
{font-family:"Segoe UI"}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
span.EmailStyle17
{font-family:"Segoe UI","sans-serif";
color:windowtext}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:70.85pt 70.85pt 70.85pt 70.85pt}
ol
{margin-bottom:0cm}
ul
{margin-bottom:0cm}
-->
--></style>
</head>
<body dir="ltr" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Haven't used DBI myself but on the surface it does look like the DBI perl modules aren't working. You might try loading them from CPAN to get later versions.<br>
</p>
<p><br>
</p>
<div id="Signature">----------------------------<br>
<div name="divtagdefaultwrapper" style="font-family:Calibri; font-size:12pt"><span lang="en-AU">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> Xymon <xymon-bounces@xymon.com> on behalf of Johan.Grotherus@vattenfall.com <Johan.Grotherus@vattenfall.com><br>
<b>Sent:</b> Tuesday, 15 September 2015 4:29 PM<br>
<b>To:</b> xymon@xymon.com<br>
<b>Subject:</b> [Xymon] Oracle monitoring with dbcheck fails</font>
<div> </div>
</div>
<div style="margin:14pt 0 10pt 0"><font face="Tahoma,sans-serif" size="2"><span style="font-size:10pt"><b></b></span></font></div>
</span></div>
</div>
<div style="color: rgb(33, 33, 33);">
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"">Hi all,</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif""> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">I am currently under way migrating from my current Xymon server running on Ubuntu to redundant Xymon servers running on CentOS. I am having Oracle monitoring
enabled with dbcheck on my Ubuntu server and it is working fine, but the same setup does not work on CentOS.</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"><span style="">1.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">The oracle client is installed</span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"><span style="">2.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">All required perl modules are installed</span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"><span style="">3.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">The same dbcheck.ini file used on Ubuntu has been copied over to CentOS</span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"><span style="">4.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">The dbcheck task is running</span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"><span style="">5.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">ORACLE_HOME and LD_LIBRARY_PATH has been set</span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"><span style="">6.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">I can connect to all my monitored Oracle instances with: sqlplus64 xymonuser/xymonpassword@host/SID as the Xymon user</span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"><span style="">7.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">The following perl script gives no error output</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="DE">#!/usr/bin/perl</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="DE"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="DE">use DBI;</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="DE"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR">$ENV{'ORACLE_HOME'}="/usr/lib/oracle/11.2/client64/";</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR">$dbhost="hostname";</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR">$port=1521;</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR">$sid="SID";</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR">$user="xymonuser";</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR">$pw="xymonpassword";</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR">$data_source="DBI:Oracle:host=$dbhost;port=$port;sid=$sid";</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">$dbh = DBI->connect($data_source,$user,$pw ,{ RaiseError => 1,</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">PrintError =>1}); $dbh->disconnect;</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">exit 0;</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">However, the only thing I get in the dbfast.log is: Timeout connecting to DBI:Oracle:host=hostname;port=1521;sid=SID!</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">This is weird, and it got even more weird when I realized that dbcheck does not even try to communicate with the Oracle instances, it simply logs the error
message and exits. I ran tcpdump to verify this and there is no connection attempt being made by dbcheck.</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">The only thing that really differs between the Ubuntu machine and the CentOS machine are the version numbers for certain per modules:</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">Ubuntu looks like this:</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">2015-09-15 08:56:42 Using default environment file /usr/lib/xymon/client/etc/xymonserver.cfg</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">Program Information</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> dbcheck.pl version 1.09</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> Hobbit_fd_lib.pm version 1.16</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">OS Information</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> Linux hmon01 3.13.0-63-generic #103-Ubuntu SMP Fri Aug 14 21:42:59 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> Perl version is v5.18.2</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">Module Information</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> FindBin 1.51</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> POSIX 1.32</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> Text::Wrap 2012.0818</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> Time::Local 1.2300</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">
</span><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR">Sys::SigAction 0.20</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR"> Config::IniFiles 2.82</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR"> DBI 1.63</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR">
</span><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">DBD::DBM 0.08</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> DBD::ExampleP 12.014311</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> DBD::File 0.42</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> DBD::Gofer 0.015327</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> DBD::ODBC 1.45</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> DBD::Oracle 1.74</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> DBD::Sponge 12.010003</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> DBD::mysql 4.025</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">CentOS looks like this:</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">2015-09-15 08:55:28.619868 Using default environment file /home/xymon/server/etc/xymonserver.cfg</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">Program Information</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> dbcheck.pl version 1.09</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> Hobbit_fd_lib.pm version 1.16</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">OS Information</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> Linux hxm01.ds.driss.se 3.18.17-13.el6.x86_64 #1 SMP Tue Jul 21 17:17:17 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> Perl version is v5.10.1</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">Module Information</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> FindBin 1.50</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> POSIX 1.17</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> Text::Wrap 2009.0305</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> Time::Local 1.1901</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">
</span><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR">Sys::SigAction 0.11</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR"> Config::IniFiles 2.56</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR"> DBI 1.609</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="FR">
</span><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">DBD::DBM 0.03</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> DBD::ExampleP 12.010007</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> DBD::File 0.37</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">
</span><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="DA">DBD::Gofer 0.011565</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="DA"> DBD::Oracle 1.74</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="DA"> DBD::Sponge 12.010002</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="DA">
</span><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">DBD::mysql 4.013</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">So, I must be missing something, but I have not found what that is, any ideas?</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US">/Johan</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Segoe UI","sans-serif"" lang="EN-US"> </span></p>
</div>
</div>
</div>
</body>
</html>