[gdal-dev] Build GDAL with OCI support on Linux
Rui Cavaco
rcavaco at sig2000.pt
Tue Apr 30 04:21:33 PDT 2013
Hi Even, Stefano, Ivan, Peter.
Thank you all for your quick replies!
Even's suggestion of using make clean did the trick!
After 'make clean' and building again the "OCI" label appeared in the
ogrinfo -formats result.
Indeed, I had many previously failed building attempts, specially before
I completely decided which compile options
I truly needed!
Stefano suggestion of having /etc/ld.so.conf.d/oracle.conf: the file was
already in place.
Also important was the advice from Peter Halls (p.halls at york.ac.uk) to
pay attention to have defined these two
env. variables: ORACLE_HOME and TNS_ADMIN.
ORACLE_HOME was set during Oracle Instant Client setup, but TNS_ADMIN
was not. TNS_ADMIN should point
to tnsnames.ora file directory, necessary to use TNS-based (simpler)
connection strings to Oracle.
Again, thank you all very much!
On 04/30/2013 07:35 AM, Stefano Iacovella wrote:
> You may also want to add path to instantclient in /etc/ld.so.conf.d
> Just add a file, i.e oracle.conf, and insert inside it path to oracle
> instant client installation.
> You may also want to check if
> ldd /usr/local/bin/gdalinfo
>
> lists reference to oracle libraries.
>
>
> Cheers,
>
> Stefano
>
> ---------------------------------------------------
> 41.95581N 12.52854E
>
>
> http://www.linkedin.com/in/stefanoiacovella
>
> http://twitter.com/#!/Iacovellas <http://twitter.com/#%21/Iacovellas>
>
>
> 2013/4/30 Even Rouault <even.rouault at mines-paris.org
> <mailto:even.rouault at mines-paris.org>>
>
> Le mardi 30 avril 2013 01:12:34, Rui Cavaco a écrit :
> > Hi Ivan, thanks for your quick reply!
> >
> > Yes, ogrinfo --formats doesn't list OCI.
>
> Did you try a "make clean" ? Because if you configured in serveral
> times, it is
> possible that the code that registers the driver didn't get
> recompiled.
>
> >
> > I'll check the thread in OTN you mentioned, it seems it has
> something
> > specific about Ubuntu. I'll feedback the results.
> >
> > Many thanks!
> > --
> > Rui Cavaco
> > ___________________________
> > SIG2000, Sist. de Infor. Geográfica, Lda.
> > Rua do Campo Alegre, 1306 Sala 308/107 4150 - 174 Porto
> > Tel.: + 351 22 606 75 77 <tel:%2B%20351%2022%20606%2075%2077>
> > Fax: + 351 22 606 75 78 <tel:%2B%20351%2022%20606%2075%2078>
> > Mail: rcavaco at sig2000.pt <mailto:rcavaco at sig2000.pt>
> > ________________________________________
> > De: Ivan Lucena [ivan.lucena at princeton-ma.us
> <mailto:ivan.lucena at princeton-ma.us>]
> > Enviado: segunda-feira, 29 de Abril de 2013 21:53
> > Para: Rui Cavaco; ""
> > Assunto: Re: [gdal-dev] Build GDAL with OCI support on Linux
> >
> > Hi Rui,
> >
> > > -------Original Message-------
> > > From: Rui Cavaco <rcavaco at sig2000.pt <mailto:rcavaco at sig2000.pt>>
> > > To: gdal-dev at lists.osgeo.org <mailto:gdal-dev at lists.osgeo.org>
> > > Subject: [gdal-dev] Build GDAL with OCI support on Linux
> > > Sent: Apr 29 '13 15:29
> > >
> > > Hello!
> > >
> > > I'm trying to get OCI support in GDAL / OGR in Ubuntu 12.04
> 32-bit.
> > >
> > > I've successfully installed Oracle Instant Client 11_2 .
> SQLPlus works
> > > flawlessly.
> > > Building GDAL also ended with no errors.
> > >
> > > But executing ogrinfo --formats, OCI format is not listed.
> > >
> > > Building script is:
> > >
> > > export LDFLAGS="-Wl,-no-as-needed"
> > > ./configure \
> > >
> > > --with-python --with-libkml=no --with-geotiff=internal \
> > > --with-threads --with-libtiff=internal --with-geotiff=internal
> > >
> > > --with-jpeg=internal --with-gif=internal --with-png=internal
> > > --with-libz=internal \
> > >
> > > --with-oci=yes \
> > >
> > >
> --with-oci-include=/usr/lib/oracle/instantclient_11_2/sdk/include \
> > >
> > > --with-oci-lib=/usr/lib/oracle/instantclient_11_2
> > >
> > > make
> > > sudo make install
> > >
> > > Environment variables:
> > >
> > >
> LD_LIBRARY_PATH=/usr/local/pgsql/lib:/usr/lib/oracle/instantclient_11_2:
> > > /usr/local/lib:
> > >
> PATH=/usr/lib/lightdm/lightdm:/usr/local/sbin:/usr/local/bin:/usr/sbin:
> > > /usr/bin:/sbin:/bin:/usr/games:/usr/lib/oracle/instantclient_11_2
> > >
> > > In Config.log, we can see:
> > >
> > > configure:22485: checking for Oracle OCI headers in
> > > /usr/lib/oracle/instantclient_11_2/sdk/include
> > > configure:22518: g++ -c -g -O2
> > > -I/usr/lib/oracle/instantclient_11_2/sdk/include conftest.cpp >&5
> > > configure:22518: $? = 0
> > > configure:22531: result: yes
> > > configure:22552: checking for Oracle OCI libraries in
> > > /usr/lib/oracle/instantclient_11_2
> > > configure:22578: g++ -o conftest -g -O2
> > > -I/usr/lib/oracle/instantclient_11_2/sdk/include
> -Wl,-no-as-needed
> > > -L/usr/lib/oracle/instantclient_11_2 -lclntsh conftest.cpp
> -L/usr/lib
> > > -lpq -lpthread -lm -lrt -ldl >&5
> > > configure:22578: $? = 0
> > > configure:22582: result: yes
> > > configure:22626: checking if Oracle OCI version is >= 10.0.1
> > > configure:22646: result: yes
> > > configure:22649: checking for Oracle version >= 10.x to use
> -lnnz10 flag
> > > configure:22654: result: yes
> > > configure:22675: checking if Oracle support is enabled
> > > configure:22689: result: yes
> > >
> > > configure:24105: checking for Oracle OCI headers in
> > > /usr/lib/oracle/instantclient_11_2/sdk/include
> > > configure:24138: g++ -c -g -O2
> > > -I/usr/lib/oracle/instantclient_11_2/sdk/include conftest.cpp >&5
> > > configure:24138: $? = 0
> > > configure:24151: result: yes
> > > configure:24172: checking for Oracle OCI libraries in
> > > /usr/lib/oracle/instantclient_11_2
> > > configure:24198: g++ -o conftest -g -O2
> > > -I/usr/lib/oracle/instantclient_11_2/sdk/include
> -Wl,-no-as-needed
> > > -L/usr/lib/oracle/instantclient_11_2 -lclntsh conftest.cpp
> -lexpat
> > > -L/usr/lib -lpq -lpthread -lm -lrt -ldl >&5
> > > configure:24198: $? = 0
> > > configure:24202: result: yes
> > > configure:24246: checking if Oracle OCI version is >= 8.1.7
> > > configure:24266: result: yes
> > > configure:24269: checking for Oracle version >= 10.x to use
> -lnnz10 flag
> > > configure:24274: result: yes
> > > configure:24295: checking if Oracle support is enabled
> > > configure:24309: result: yes
> > >
> > > Apparently, no errors to be found.
> > >
> > > But OGR tools cannot access Oracle datasources.
> >
> > What is the command line and the error message that tells you that?
> >
> > Can you see OCI as one of the driver when you run "ogrinfo
> --formats" ?
> >
> > There was a discussion about building GDAL on Ubuntu on OTN:
> >
> >
> https://forums.oracle.com/forums/thread.jspa?threadID=1128217&tstart=0&mess
> > ageID=10658264#10658264
> >
> > Regards,
> >
> > Ivan
> >
> > > Hoping to get some help on this,
> > >
> > > --
> > > Rui Cavaco
> > > Mail: rcavaco at sig2000.pt <mailto:rcavaco at sig2000.pt>
> > > _______________________________________________
> > > gdal-dev mailing list
> > > gdal-dev at lists.osgeo.org <mailto:gdal-dev at lists.osgeo.org>
> > > http://lists.osgeo.org/mailman/listinfo/gdal-dev
> >
> > _______________________________________________
> > gdal-dev mailing list
> > gdal-dev at lists.osgeo.org <mailto:gdal-dev at lists.osgeo.org>
> > http://lists.osgeo.org/mailman/listinfo/gdal-dev
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org <mailto:gdal-dev at lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
>
--
Rui Cavaco
___________________________
SIG2000, Sist. de Infor. Geográfica, Lda.
Rua do Campo Alegre, 1306 Sala 308/107 4150 - 174 Porto
Tel.: + 351 22 606 75 77
Fax: + 351 22 606 75 78
Mail: rcavaco at sig2000.pt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20130430/1dbf00f7/attachment.html>
More information about the gdal-dev
mailing list