[gdal-dev] Problem Compiling with Oracle (--with-oci)

[Chris Hodgson]

Just wanted to wrap this up with my final findings for anyone who 
stumbles onto this thread in the future.

While the solution below did allow me to successfully build and connect 
to oracle, I also wanted to build with support for PostgreSQL/PostGIS. 
The PostgreSQL client also requires expat, and so my little 
-with-expat=no trick didn't allow the postgres support to be included in 
the build. The final solution was to download the oracle instant client 
(for linux) - both the "basic" client package and the "SDK" package were 
required.

Before configuring, I needed to do the following in the instant client 
directory:

ln -s libclntsh.so.11.1 libclntsh.so
ln -s libocci.so.11.1 libocci.so

And then I needed to specify the paths to where I unzipped the instant 
client packages (in /opt) to configure:

--with-oci-lib=/opt/instantclient_11_2
--with-oci-include=/opt/instantclient_11_2/sdk/include

And that's it (as it should be). No LDFLAGS or messing with 
LD_LIBRARY_PATH, no ORACLE_HOME even, just here's the libs, here's the 
includes, go. This works so much better because the instant client has 
all of it's pre-req's statically linked in (it's a ridiculously huge 
library as a result...) whereas the libraries that come in the /lib/ dir 
of the full oracle package do not (and so are only somewhat less 
ridiculously large).

Hope that helps someone, someday.

Cheers,
Chris


Chris Hodgson wrote:
> Thanks for the confirmation Mike. I'm guessing the oracle instant 
> client was compiled with a bit more care for the use of external 
> developers. However I have managed to get a successful compile after 
> setting the LDFLAGS environment variable to include the oracle lib 
> folder (to get their old expat onto the path):
>
> export LDFLAGS=-L/opt/oracle/product/11.2.0/dbhome_1/lib/
>
> and then configured with the gdal expat turned off (if I leave it on I 
> end up with the same original problem):
>
> ./configure --with-oci=/opt/oracle/product/11.2.0/dbhome_1/ 
> --with-expat=no
>
> I still have to test if this actually lets me connect to oracle. If 
> not I'll download the instant client and try configuring/compiling 
> against that.
>
> Thanks,
> Chris
>
> Smith, Michael D ERDC-CRREL-NH wrote:
>> I have the expat 1.95 added via standed RHEL repo and using oracle 
>> instant client (11.2) without a problem with GDAL from SVN
>>
>> I use
>>
>> ./configure \
>>     --with-libtiff=internal \
>>     --with-geotiff=internal \
>>     --with-jpeg=internal \
>>     --with-libz=internal \
>>     --with-png=internal \
>>     --with-oci=/oracle/instantclient_11_1 \
>>     --with-geos=/usr/local/bin/geos-config \
>>     --with-curl \
>>     --with-threads \
>>     --with-expat=yes \
>>     --with-libkml \
>>     --with-python
>>
>>
>> Mike
>>
>>
>> -- 
>> Michael Smith
>> Remote Sensing/GIS Center
>> US Army Corps of Engineers
>> Hanover, NH
>>
>>
>>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev