Oracle for GDAL and Mapserver

• You need the Oracle Instant Client
  • For this tutorial we'll assume that's it is installed in /opt/oracle/

• With gdal and mapserver installed do

  sudo apt-get install libmsplugin-oracle-src libgdal-oci-src
  

• To install the GDAL plugin:

  sudo gdal-oci-build /opt/oracle/sdk/include /opt/oracle/
  

  The script takes 2 arguments, first is the path to the include directory and the second one is the path to the lib directory Now you should see OCI in ogrinfo --formats
• To install the Mapserver plugin:
  • We need to set the ORACLE_HOME environment variable first

     export ORACLE_HOME=/opt/oracle/ 
    

  • Then we run

     sudo mapserver-oracle-build yes
    

  • To use the Mapserver Oracle plugin you need to use the plugin connectiontype and specify the path to libmsplugin-oracle.so, like this

     MAP
     ...
     CONNECTIONTYPE plugin
     PLUGIN "/usr/lib/msplugins/libmsplugin-oracle.so"
     ...
     END