[mapserver-users] Antw: Re: MapServer with oracle-spatial on a linuxsystem

[michael.smith.erdc at gmail.com]

Kai,
Check the cmake build log too. You also need the libaio library. 

I also set the following ENV variables
ORACLE_HOME - set to the path to the instantclient location
LD_LIBRARY_PATH - set to the path to the instantclient location

Michael Smith

> On Jul 16, 2019, at 2:59 AM, Kai Behncke <Kai.Behncke at ibbenbueren.de> wrote:
> 
> Hi Michael, Hi Jeff,
> 
> First of all thank you very much for your responses.
> 
> Meanwhile I have installed from that page:
> https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
> 
> a) in version 11.2: Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
> b) Instant Client Package - SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client
> 
> by "rpm -i".
> 
> But (so far) nevertheless I don`t get mapserver configured with oracle spatial.
> 
> For me it`s not clear with path I have to set. I have (e.g.) tried:
> 
> 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
> 
> 
> ...without success.
> 
> On SUSE SLES 15 I have "oracle-entires" at:
> 
> 
> /usr/share/oracle/11.2/client64
> /usr/lib/oracle/11.2/client64/
> /usr/include/oracle/11.2/client64/
> 
> I there any other step I have to do?
> 
> Thank you very much, Kai
> 
> 
> 
> 
> 
> Mit freundlichen Grüßen
> Im Auftrag
> 
> Kai Behncke
> Geoinformation
> Tel.: +49 5451 931-7125
> 
> E-Mail: kai.behncke at ibbenbueren.de 
> 
> Rathaus II
> Roncallistraße 3-5
> 1. Stock, Raum 105
> 49477 Ibbenbüren
> 
> 
> >>> Michael Smith <michael.smith.erdc at gmail.com> 15.07.2019 18:19 >>>
> Kai,
>  
> 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.
>  
> You need Instant Client Package – SDK and the Basic (or Basic Light) Package.
>  
> Mike
>  
>  
> --
> Michael Smith
> Remote Sensing/GIS Center
> US Army Corps of Engineers
>  
>  
> From: mapserver-users <mapserver-users-bounces at lists.osgeo.org> on behalf of Kai Behncke <Kai.Behncke at ibbenbueren.de>
> Date: Monday, July 15, 2019 at 11:49 AM
> To: "mapserver-users at lists.osgeo.org" <mapserver-users at lists.osgeo.org>
> Subject: [mapserver-users] MapServer with oracle-spatial on a linuxsystem
>  
> Dear users,
>  
> on a SUSE System (SLES 15) I try to configure mapserver 7.4. with Oracle-spatial support.
>  
> Important: The Oracle Database is installed on another server.
>  
> 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/
>  
> I try to configure with:
>  
> 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
>  
> ...but in the output I always get: CMake Error at CMakeLists.txt:73 (message): ORACLESPATIAL library/component/dependency could not be found.
>  
> Does that mean I definetely need an oracle installation?
>  
> Thank you very much, Kai
> Mit freundlichen Grüßen
> Im Auftrag
> Kai Behncke
> Geoinformation
> Tel.: +49 5451 931-7125
> E-Mail: kai.behncke at ibbenbueren.de
> Rathaus II
> Roncallistraße 3-5
> 1. Stock, Raum 105
> 49477 Ibbenbüren
>  
> _______________________________________________ mapserver-users mailing list mapserver-users at lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20190716/08691256/attachment.html>