[Gdal-dev] OCI support for Oracle 9i

[Mateusz Loskot]

Otto Dassau wrote:
> Hi, 
> 
> I am trying to build gdal 1.4.1 with OCI support but with no success. The
> database is an oracle 9i. In the configure script I provide:
> 
> --with-oci=/usr/lib/oracle/9.2.0/OraHome \
> --with-oci-lib=/usr/lib/oracle/9.2.0/OraHome/lib

Otto,

You should use

--with-oci

*or* pair of options

--with-oci-include
--with-oci-lib

The single --with-oci is equivalent to ORACLE_HOME environment,
but it may not work well with older Oracle versions, because there were
some changes in structure of installation directory.

So, try to use the two latter options.

> There are two problems:
> 
> a) checking for Oracle OCI headers in /usr/lib/oracle/9.2.0/OraHome/rdbms/public
> 
> During configuration the header files are assumed to be in rdbms/public:
> ... checking for Oracle OCI headers in
> /usr/lib/oracle/9.2.0/OraHome/rdbms/public
> 
> but in my oracle installation the header files are located in /rdbms/demo/, so I
> have to copy them. Can I somehow add:
> 
> --with-oci-include='/usr/lib/oracle/9.2.0/OraHome/rdbms/public /usr/lib/oracle/9
> .2.0/OraHome/rdbms/demo' ?

Yes, you should use --with-oci-include.

> b) checking for Oracle OCI libraries in /usr/lib/oracle/9.2.0/OraHome/lib
> 
> here I get following error message that -lnnz10 is missing:
> 
> #configure:26066: checking for Oracle OCI libraries in
> #/usr/lib/oracle/9.2.0/OraHome/lib configure:26097: g++ -o conftest -g -O2 
> #-I/usr/lib/oracle/9.2.0/OraHome/rdbms/public 
> #-L/usr/lib/oracle/9.2.0/OraHome/lib -lclntsh -lnnz10 conftest.cc -L/usr/lib
> #-lxerces-c -lpthread -ljasper -lmfhdf -ldf -lgif -ljpeg -ltiff -lpng -lnetcdf
> #-lcfitsio -lpq -L/usr/lib -lpq -lz -lpthread -lm -lrt -ldl  >&5 /usr/bin/ld:
> #cannot find -lnnz10 collect2: ld returned 1 exit status
> #configure:26103: $? = 1
> #configure: failed program was:
> #| 
> #|                 /* confdefs.h.  */
> 
> I haven't found anything about it in other mailings, so I hope someone can give
> me a hint, how I can manage to get oracle support for current gdal 1.4.1. I
> worked with version 1.3.2 before and there I have oci support with the same
> configuration.

Could you give me list of libraries in your directory
/usr/lib/oracle/9.2.0/OraHome/lib
?

Cheers
-- 
Mateusz Loskot
http://mateusz.loskot.net