[gdal-dev] Build GDAL with OCI support on Linux

Stefano Iacovella stefano.iacovella at gmail.com
Mon Apr 29 23:35:57 PDT 2013


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


2013/4/30 Even Rouault <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
> > Fax: + 351 22 606 75 78
> > Mail: rcavaco at sig2000.pt
> > ________________________________________
> > De: Ivan Lucena [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>
> > >  To: 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
> > >  _______________________________________________
> > >  gdal-dev mailing list
> > >  gdal-dev at lists.osgeo.org
> > >  http://lists.osgeo.org/mailman/listinfo/gdal-dev
> >
> > _______________________________________________
> > gdal-dev mailing list
> > gdal-dev at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/gdal-dev
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20130430/47a8db13/attachment-0001.html>


More information about the gdal-dev mailing list