[Qgis-developer] Help on Oracle provider on Debian

[Richard Duivenvoorde]

Hi Martin,

I owe you a beer :-)

Thanks! Succesfull. Biggest hurdle was that I was in the impression that
the libocci.so.12.1 was the mail lib, but it appears that
libclntsh.so.12.1 is the one you need.

Will do some connections testing and test with qgisserver, and write a
blog article about it.

Regards,

Richard

On 20-08-14 09:15, Martin Dobias wrote:
> 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
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>