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

[Jeff McKenna]

I also took the time to update the OracleSpatial docs 
(https://mapserver.org/input/vector/oracle.html).   If you have any 
enhancements please be sure to file your new issue or pull request to 
the "docs" instance at https://github.com/mapserver/docs

thanks!

-jeff




On 2019-07-16 7:24 AM, Kai Behncke wrote:
> Allright, finally I got it.
> 
> 
> I declared:
> export ORACLE_HOME=/usr/lib/oracle/12.2/client64
> export LD_LIBRARY_PATH=${ORACLE_HOME}:/usr/lib
> 
> and in my case I got a problem with the ORACLE_INCLUDE_DIR.
> 
> I changed in the cmake-directory cmake/FindOracle.cmake:
> 
>   if(DEFINED ENV{ORACLE_HOME})
>   27
>   28   set(ORACLE_HOME $ENV{ORACLE_HOME})
>   29   message("ORACLE_HOME=${ORACLE_HOME}")
>   30
>   31   find_path(ORACLE_INCLUDE_DIR
>   32     NAMES oci.h
>   33     PATHS
>   34
>   35     /usr/include/oracle/12.2/client64)
> 
> 
> And I configured mapserver by:
> 
> cmake .. -DCMAKE_BUILD_TYPE='debug' 
> -DCMAKE_INSTALL_PREFIX=/opt/mapserver 
> -DCMAKE_PREFIX_PATH=/usr/lib/oracle/12.2/client64:/usr/include/oracle/12.2/client64:
> /usr/lib:/usr/lib64:/usr/share/gdal -DWITH_ORACLESPATIAL=1 
> -DWITH_PROTOBUFC=0 -DWITH_FCGI=0 -DWITH_CURL=1
> 
> and then I got it:
> 
> 
> --   * LIBXML2: /usr/lib64/libxml2.so
> --   * POSTGIS: /usr/lib64/libpq.so
> --   * GEOS: /usr/lib64/libgeos_c.so
> --   * FastCGI: disabled
> --   * PROTOBUFC: disabled
> --   * Oracle Spatial: 
> /usr/lib/oracle/12.2/client64/lib/libclntsh.so;/usr/lib/oracle/12.2/client64/lib/libocci.so;/usr/lib/oracle/12.2/client64/lib/libnnz12.so
> --   * Exempi XMP: disabled
> --  * Optional features
> --   * WMS SERVER: ENABLED
> --   * WFS SERVER: ENABLED
> --   * WCS SERVER: ENABLED
> 
> 
> 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 <mailto:kai.behncke at ibbenbueren.de>
> 
> Rathaus II
> Roncallistraße 3-5
> 1. Stock, Raum 105
> 49477 Ibbenbüren
> 
> 
>>>> Jeff McKenna <jmckenna at gatewaygeomatics.com> 15.07.2019 18:42 >>>
> Oh and I always use the "Basic" package, but I guess "lite" will work as
> Mike said.   -jeff
> 
> 
> 
> On 2019-07-15 1:40 PM, Jeff McKenna wrote:
>  > Further to what Mike said, I usually grab the instant client from this
>  > page (it is often hard to find):
>  > 
> https://www.oracle.com/database/technologies/instant-client/downloads.html
> 
>  >
>  > -jeff
>  >
>  >
>  >
>