Oracle for Mapserver

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

• With mapserver installed do

  sudo apt-get install libmsplugin-oracle-src 
  

• 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