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

[Even Rouault]

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