<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">Kai,<div>Check the cmake build log too. You also need the libaio library. </div><div><br></div><div>I also set the following ENV variables</div><div>ORACLE_HOME - set to the path to the instantclient location</div><div>LD_LIBRARY_PATH <span style="background-color: rgba(255, 255, 255, 0);">- set to the path to the instantclient location</span></div><div><br></div><div>Michael Smith</div><div><div dir="ltr"><br>On Jul 16, 2019, at 2:59 AM, Kai Behncke <<a href="mailto:Kai.Behncke@ibbenbueren.de">Kai.Behncke@ibbenbueren.de</a>> wrote:<br><br></div><blockquote type="cite"><div dir="ltr">
<meta name="Generator" content="Novell Groupwise Client (Version 14.2.1 Build: 124595)">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<div class="GroupWiseMessageBody" id="GroupWiseSection_1563259917000_Kai.Behncke@ibbenbueren.de_A4138AB005DF00008D73746134313865_"><div>Hi Michael, Hi Jeff,</div><div><br></div><div>First of all thank you very much for your responses.</div><div><br></div><div>Meanwhile I have installed from that page:</div><div><a href="https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html"><font color="#0066cc">https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html</font></a></div><div><br></div><div>a) in version 11.2: <span>Instant Client Package - Basic:</span> <span>All files required to run OCI, OCCI, and JDBC-OCI applications</span></div><div><span>b) <span>Instant Client Package - SDK:</span> <span>Additional header files and an example makefile for developing Oracle applications with Instant Client</span></span></div><div><span><span><br></span></span></div><div><span><span>by "rpm -i".</span></span></div><div><span><span><br></span></span></div><div><span><span>But (so far) nevertheless I don`t get mapserver configured with oracle spatial.</span></span></div><div><span><span><br></span></span></div><div><span><span>For me it`s not clear with path I have to set. I have (e.g.) tried:</span></span></div><div><span><span><br></span></span></div><div><span><span>cmake .. -DCMAKE_PREFIX_PATH=/usr/lib64:/usr/share/gdal:/usr/share/oracle/11.2/client64 -DWITH_ORACLESPATIAL=1 -DWITH_HARFBUZZ=0 -DWITH_PROTOBUFC=0 -DWITH_FRIBIDI=0 -DWITH_FCGI=0</span></span></div><span><span></span></span></div><div><br></div><div><br></div><div>...without success.</div><div><br></div><div>On SUSE SLES 15 I have "oracle-entires" at:</div><div><br></div><span><div><br>/usr/share/oracle/11.2/client64<span><br>/usr/lib/oracle/11.2/client64/<div>/usr/include/oracle/11.2/client64/</div><div><br></div><div>I there any other step I have to do?</div><div><br></div><div>Thank you very much, Kai</div><div><br></div></span></div></span><div><span><span><br></span></span></div><div><span><span><br></span></span></div><span><span></span></span><div><span><span></span></span><div><br></div><span id="GWSignatureSent" style="padding-right: 0px; padding-left: 0px; margin-bottom: 5px; display: block;"><span style="display: block;"><br><span style="font-size: 10pt; display: inline-block; -ms-word-wrap: normal;">
<div><!--GWSignatureRecordId 5C5442A6.STADT-IBB-DOM.STADT-IBB-PO.100.1646D74.1.7B.1 GWSignatureRecordId--><div>Mit freundlichen Grüßen<br>Im Auftrag</div><div><br></div><div>Kai Behncke<br>Geoinformation<br>Tel.: +49 5451 931-7125</div><div><br></div><div>E-Mail: <a href="mailto:kai.behncke@ibbenbueren.de">kai.behncke@ibbenbueren.de</a> </div><div><br></div><div>Rathaus II<br>Roncallistraße 3-5<br>1. Stock, Raum 105<br>49477 Ibbenbüren</div><br></div></span></span></span><span style="margin-bottom: 5px; display: block;"><br></span><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
<div class="GroupWiseMessageBody" id="GroupWiseSection_1563259916000_Kai.Behncke@ibbenbueren.de_A4138AB005DF00008D73746134313865_"><span class="GroupwiseReplyHeader">>>> Michael Smith <<a href="mailto:michael.smith.erdc@gmail.com">michael.smith.erdc@gmail.com</a>> 15.07.2019 18:19 >>><br></span><div><div class="WordSection1"><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">Kai,<o:p></o:p></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">To compile mapserver with oracle support, you need the sdk and the oracle client library. The instant client library and sdk files are fine for this. You do not need a local install of the database or the full client.<o:p></o:p></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">You need Instant Client Package – SDK and the Basic (or Basic Light) Package.<o:p></o:p></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">Mike<o:p></o:p></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="color: black; font-size: 10.5pt;">--<o:p></o:p></span></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="color: black; font-size: 10.5pt;">Michael Smith<o:p></o:p></span></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="color: black; font-size: 10.5pt;">Remote Sensing/GIS Center<o:p></o:p></span></div></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="color: black; font-size: 10.5pt;">US Army Corps of Engineers</span><o:p></o:p></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div><div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) currentColor currentColor; padding: 3pt 0cm 0cm; border-image: none;"><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><b><span style="color: black; font-size: 12pt;">From: </span></b><span style="color: black; font-size: 12pt;">mapserver-users <<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a>> on behalf of Kai Behncke <<a href="mailto:Kai.Behncke@ibbenbueren.de">Kai.Behncke@ibbenbueren.de</a>><br><b>Date: </b>Monday, July 15, 2019 at 11:49 AM<br><b>To: </b>"<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>" <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br><b>Subject: </b>[mapserver-users] MapServer with oracle-spatial on a linuxsystem<o:p></o:p></span></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div></div><div id="GroupWiseSection_1563205301000_Kai.Behncke@ibbenbueren.de_A4138AB005DF00008D73746134313865_"><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">Dear users,<o:p></o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">on a SUSE System (SLES 15) I try to configure mapserver 7.4. with Oracle-spatial support.<o:p></o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">Important: The Oracle Database is installed on another server.<o:p></o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">I wonder if I need also the oracle-installation on the SLES 15-server or if the oracle client is enough? So far I installed the client at /usr/lib64/oracle/11.2.0.4.0/client/lib/<o:p></o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">I try to configure with:<o:p></o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">cmake .. -DCMAKE_PREFIX_PATH=/usr/lib64:/usr/share/gdal:/usr/lib64/oracle/11.2.0.4.0/client/lib -DWITH_ORACLESPATIAL=1 -DWITH_HARFBUZZ=0 -DWITH_PROTOBUFC=0 -DWITH_FRIBIDI=0<o:p></o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">...but in the output I always get: CMake Error at CMakeLists.txt:73 (message): ORACLESPATIAL library/component/dependency could not be found.<o:p></o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">Does that mean I definetely need an oracle installation?<o:p></o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><o:p> </o:p></div></div><div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">Thank you very much, Kai<o:p></o:p></div></div><div class="MsoNormal" style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm;" margin-bottom:3.75pt'="" margin-top:0cm;="" margin-left:0cm;="" margin-right:0cm;=""><span style="font-size: 10pt;">Mit freundlichen Grüßen<br>Im Auftrag<o:p></o:p></span></div></div><div><div class="MsoNormal" style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm;" margin-bottom:3.75pt'="" margin-top:0cm;="" margin-left:0cm;="" margin-right:0cm;=""><span style="font-size: 10pt;">Kai Behncke<br>Geoinformation<br>Tel.: +49 5451 931-7125<o:p></o:p></span></div></div><div><div class="MsoNormal" style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm;" margin-bottom:3.75pt'="" margin-top:0cm;="" margin-left:0cm;="" margin-right:0cm;=""><span style="font-size: 10pt;">E-Mail: <a href="mailto:kai.behncke@ibbenbueren.de">kai.behncke@ibbenbueren.de</a> <o:p></o:p></span></div></div><div><div class="MsoNormal" style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm;" margin-bottom:3.75pt'="" margin-top:0cm;="" margin-left:0cm;="" margin-right:0cm;=""><span style="font-size: 10pt;">Rathaus II<br>Roncallistraße 3-5<br>1. Stock, Raum 105<br>49477 Ibbenbüren<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm;" .0001pt"="" 0cm=""><o:p> </o:p></div></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;">_______________________________________________ mapserver-users mailing list <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a> <a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><o:p></o:p></div></div></div></div>
</div></blockquote><blockquote type="cite"><div dir="ltr"><span>_______________________________________________</span><br><span>mapserver-users mailing list</span><br><span><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a></span><br><span><a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a></span></div></blockquote></div></body></html>