[gdal-dev] Build OGR with Oracle support

[Ivan]

Normand,

Just a quick complimentary reference:

"""Instant Client allows you to run your applications without installing the standard Oracle client 
or having an ORACLE_HOME. OCI, OCCI, Pro*C, ODBC, and JDBC applications work without modification, 
while using significantly less disk space than before. Even SQL*Plus can be used with Instant 
Client. No recompile, no hassle.""" [http://www.oracle.com/technology/tech/oci/instantclient/index.html]

But of course, running is one thing, compiling is another.

Regards,

Ivan

Normand Savard wrote:
> Mateusz Loskot wrote:
>>
>>
>> ./configure generates a log file called config.log.
>> If something goes wrong, there should be some diagnostic in this file.
>> It would be helpful if you could share it, for instance, here:
>>
>> http://pastebin.com/
>>
>> This will help to find what's the problem.
>>
>>   
> Maateusz,
> 
> You were right, this help a lot.  I succeeded to build OGR with Oracle 
> 10g and 11g but for those who may come on a similar issue in the future, 
> I'm posting the process I went through.
> 
> I downloaded
> oracle-instantclient-basic-10.2.0.4-1.i386.zip (library)
> oracle-instantclient-devel-10.2.0.4-1.i386.zip (headers)
> 
> or
> instantclient-basic-linux32-11.1.0.7.zip (library)
> instantclient-sdk-linux32-11.1.0.7.zip (headers)
> 
> 
> As suggested I checked the config.log (see 1) and noticed that there was 
> a link problem (-lclntsh).  I went to the instantclient directory to 
> check for libclntsh.so, but it was not there.  So I added a link to 
> libclntsh.so.11.1.
> I redid the configure and checked the config.log again (see 2).  I 
> noticed that libnnz11.so library was not found.  I went to the 
> instantclient directory but the library was present.  Since I use the 
> fgs-dev environment the libraries are not in a traditional path so the 
> linker could not find it.  To solve this issue, I added the path to 
> where the library was installed to $LD_LIBRARY_PATH.  There was a 
> problem with libaio.so.1 library.  For this particular issue I had to 
> install libaio-dev on my system (Ubuntu:  apt-get install).
> 
> It works fine after that.
> 
> Thank you to both of you.
> 
> Norm
> 
> 
> 
> 1)config.log
> configure:23653: checking for Oracle OCI headers in 
> /home/fgs/fgs-dev/built/ins\
> tantclient_11_1/sdk/include
> configure:23696: g++ -c -fPIC  -g -DDEBUG  
> -I/home/fgs/fgs-dev/built/instantcli\
> ent_11_1/sdk/include conftest.cpp >&5
> configure:23702: $? = 0
> configure:23715: result: yes
> configure:23740: checking for Oracle OCI libraries in 
> /home/fgs/fgs-dev/built/i\
> nstantclient_11_1
> configure:23743: result: norm: 
> -L/home/fgs/fgs-dev/built/instantclient_11_1 -lc\
> lntsh
> configure:23745: result: norm: 
> -I/home/fgs/fgs-dev/built/instantclient_11_1/sdk\
> /include
> configure:23781: g++ -o conftest -fPIC  -g -DDEBUG  
> -I/home/fgs/fgs-dev/built/i\
> nstantclient_11_1/sdk/include  
> -L/home/fgs/fgs-dev/built/instantclient_11_1 -lc\
> lntsh conftest.cpp -L/home/fgs/fgs-dev/built/jpeg 
> -L/home/fgs/fgs-dev/built/jpe\
> g/lib -ljpeg -L/home/fgs/fgs-dev/built/libgeotiff/lib -lgeotiff 
> -L/home/fgs/fgs\
> -dev/built/tiff/lib -ltiff -L/home/fgs/fgs-dev/built/libpng 
> -L/home/fgs/fgs-dev\
> /built/libpng/lib -lpng -lpq -L/home/fgs/fgs-dev/built/postgresql/lib 
> -lpq -lz \
> -L/home/fgs/fgs-dev/built/zlib -L/home/fgs/fgs-dev/built/zlib/lib  -lm 
> -lrt -ld\
> l  >&5
> /usr/bin/ld: cannot find -lclntsh
> collect2: ld returned 1 exit status
> configure:23787: $? = 1
> configure: failed program was:
> |
> |                 /* confdefs.h.  */
> | #define PACKAGE_NAME ""
> | #define PACKAGE_TARNAME ""
> 
> 
> 
> 
> 
> 
> 2) config.log
> 
> configure:23740: checking for Oracle OCI libraries in 
> /home/fgs/fgs-dev/built/i\
> nstantclient_11_1
> configure:23743: result: norm: 
> -L/home/fgs/fgs-dev/built/instantclient_11_1 -lc\
> lntsh
> configure:23745: result: norm: 
> -I/home/fgs/fgs-dev/built/instantclient_11_1/sdk\
> /include
> configure:23781: g++ -o conftest -fPIC  -g -DDEBUG  
> -I/home/fgs/fgs-dev/built/i\
> nstantclient_11_1/sdk/include  
> -L/home/fgs/fgs-dev/built/instantclient_11_1 -lc\
> lntsh conftest.cpp -L/home/fgs/fgs-dev/built/jpeg 
> -L/home/fgs/fgs-dev/built/jpe\
> g/lib -ljpeg -L/home/fgs/fgs-dev/built/libgeotiff/lib -lgeotiff 
> -L/home/fgs/fgs\
> -dev/built/tiff/lib -ltiff -L/home/fgs/fgs-dev/built/libpng 
> -L/home/fgs/fgs-dev\
> /built/libpng/lib -lpng -lpq -L/home/fgs/fgs-dev/built/postgresql/lib 
> -lpq -lz \
> -L/home/fgs/fgs-dev/built/zlib -L/home/fgs/fgs-dev/built/zlib/lib  -lm 
> -lrt -ld\
> l  >&5
> /usr/bin/ld: warning: libnnz11.so, needed by 
> /home/fgs/fgs-dev/built/instantcli\
> ent_11_1/libclntsh.so, not found (try using -rpath or -rpath-link)
> /usr/bin/ld: warning: libaio.so.1, needed by 
> /home/fgs/fgs-dev/built/instantcli\
> ent_11_1/libclntsh.so, not found (try using -rpath or -rpath-link)
> /home/fgs/fgs-dev/built/instantclient_11_1/libclntsh.so: undefined 
> reference to\
> `nzos_ServiceWriteQueue'
> /home/fgs/fgs-dev/built/instantclient_11_1/libclntsh.so: undefined 
> reference to\
> `nzosCipherSpecToStr'
> /home/fgs/fgs-dev/built/instantclient_11_1/libclntsh.so: undefined 
> reference to\
> `C_SetCRLBER'
> 
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
> 
>