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