[Qgis-developer] Help on Oracle provider on Debian

[Martin Dobias]

Hi Richard!

I have installed oracle client on my ubuntu some time ago - hopefully
it will be the same with Debian - if it works I opt for a beer ;-)

=[ client SDK ]=

- download from Oracle web (need to register):

instantclient-basiclite-linux.x64-12.1.0.1.0.zip
instantclient-sdk-linux.x64-12.1.0.1.0.zip

- unzip (e.g. somewhere to home dir)

=[ QGIS with Oracle ]=

- configure: -DWITH_ORACLE=TRUE
   + point to the library + include dir

- make sure the client library path is in LD_LIBRARY_PATH
- run QGIS with custom QT_PLUGIN_PATH=...../output/lib/qgis/plugins
  (so that the OCI plugin for Qt is found)

- if running QGIS from Qt Creator, make sure to setup environment for running,
  otherwise it will fail to log in with weird error messages, e.g.
    ORA-12162: TNS:net service name is incorrectly specified
  environment:
    ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
    ORACLE_SID=XE
    LD_LIBRARY_PATH=/home/martin/Downloads/oracle/instantclient_12_1

(note: I run Oracle server on localhost, not sure if anything else is
necessary when run on a different machine)

Cheers
Martin



On Wed, Aug 20, 2014 at 1:48 PM, Richard Duivenvoorde
<rdmailings at duif.net> wrote:
> Hi devs,
>
> I want to invest some time into testing/working with the QGIS Oracle
> driver (both for QGIS-Desktop and QGIS-Server).
>
> First thing needed, I have: installed Oracle DB on a CentOS machine.
>
> But for next thing: compiling QGIS with OracleProvider on Linux/Debian
> enabled, I'll need some hints.
>
> Anybody experience with installing/compiling OCI on Debian, and able to
> provide a link or info about how that's done.
>
> I found this (old) link:
>
> http://ggorjan.blogspot.com/2007/04/oracle-instantclient-odbc-on-debian.html
>
> Which reminded me to earlier Oracle work: there is always so much to
> download, not clear what you need and what is just cruft.
>
> So if somebody is able to describe the minimal Oracle stuff I need to be
> able to build Oracle Driver that would be great.
>
> I'm happy to describe it later in a blogpost and I'll buy you a
> beer/applepie/pizza whatever whenever we meet ;-)
>
> Regards,
>
> Richard Duivenvoorde
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer