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

[Michael Smith]

Thanks Jeff!

M

On 7/16/19, 1:17 PM, "mapserver-users on behalf of Jeff McKenna" <mapserver-users-bounces at lists.osgeo.org on behalf of jmckenna at gatewaygeomatics.com> wrote:

    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
    >  >
    >  >
    >  >
    > 
    _______________________________________________
    mapserver-users mailing list
    mapserver-users at lists.osgeo.org
    https://lists.osgeo.org/mailman/listinfo/mapserver-users