[Gdal-dev] OCI support for Oracle 9i

Tue May 15 08:37:15 EDT 2007

Hi Mateusz,

On Tue, 15 May 2007 13:47:26 +0200
Mateusz Loskot <mateusz at loskot.net> wrote:

> 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

yes, but the header files are in two folders - so I use:

--with-oci-include='/usr/lib/oracle/9.2.0/OraHome/rdbms/public \
/usr/lib/oracle/9.2.0/OraHome/rdbms/demo' 

Problem here: it only looks into the first of the two folders. The oci.h header
is in /usr/lib/oracle/9.2.0/OraHome/rdbms/demo. Do I have to use another
syntax? I tried with different quotation marks without success.

-> checking for Oracle OCI headers in /usr/lib/oracle/9.2.0/OraHome/rdbms/public
/usr/lib/oracle/9.2.0/OraHome/rdbms/demo
... #error Oracle oci.h header not found

> 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
> ?

ok, I attach a list with all files in /usr/lib/oracle/9.2.0/OraHome/lib

regards,
 Otto
-------------- next part --------------
/usr/lib/oracle/9.2.0/OraHome/lib/activation.jar
/usr/lib/oracle/9.2.0/OraHome/lib/clntsh.map
/usr/lib/oracle/9.2.0/OraHome/lib/clntst_1.lis
/usr/lib/oracle/9.2.0/OraHome/lib/clntst_2.lis
/usr/lib/oracle/9.2.0/OraHome/lib/clntst.lis
/usr/lib/oracle/9.2.0/OraHome/lib/facility.lis
/usr/lib/oracle/9.2.0/OraHome/lib/jsse.jar
/usr/lib/oracle/9.2.0/OraHome/lib/lclasses11.zip
/usr/lib/oracle/9.2.0/OraHome/lib/lclasses12.zip
/usr/lib/oracle/9.2.0/OraHome/lib/ldflags
/usr/lib/oracle/9.2.0/OraHome/lib/ldflagsO
/usr/lib/oracle/9.2.0/OraHome/lib/libagent9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libclient9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libclntsh.so
/usr/lib/oracle/9.2.0/OraHome/lib/libclntsh.so.9.0
/usr/lib/oracle/9.2.0/OraHome/lib/libclntst9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libcommon9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libcore9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libcorejava.so
/usr/lib/oracle/9.2.0/OraHome/lib/libcprts.so
/usr/lib/oracle/9.2.0/OraHome/lib/libcprts.so.3
/usr/lib/oracle/9.2.0/OraHome/lib/libcxa.so
/usr/lib/oracle/9.2.0/OraHome/lib/libcxa.so.3
/usr/lib/oracle/9.2.0/OraHome/lib/libgeneric9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libheteroxa9.so
/usr/lib/oracle/9.2.0/OraHome/lib/libirc.a
/usr/lib/oracle/9.2.0/OraHome/lib/libjmisc.so
/usr/lib/oracle/9.2.0/OraHome/lib/libldapclnt9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libldapjclnt9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libldapjclnt9.so
/usr/lib/oracle/9.2.0/OraHome/lib/libmm.a
/usr/lib/oracle/9.2.0/OraHome/lib/libn9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libnbeq9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libncrypt9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libnhost9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libnjni9.so
/usr/lib/oracle/9.2.0/OraHome/lib/libnl9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libnldap9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libnls9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libnoname9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libnro9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libnsgr9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libnsslb9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libntcp9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libntcps9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libntns9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libnus9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libnzjs9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libocijdbc9.so
/usr/lib/oracle/9.2.0/OraHome/lib/libocijdbcst9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libOsUtils.so
/usr/lib/oracle/9.2.0/OraHome/lib/libplc9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libplp9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libpls9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libpsa9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libskgxp9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libskgxp9.so
/usr/lib/oracle/9.2.0/OraHome/lib/libskgxpd.a
/usr/lib/oracle/9.2.0/OraHome/lib/libskgxpd.so
/usr/lib/oracle/9.2.0/OraHome/lib/libskgxpu.a
/usr/lib/oracle/9.2.0/OraHome/lib/libskgxpu.so
/usr/lib/oracle/9.2.0/OraHome/lib/libslax9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libsnls9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libsql9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libsqlplus.a
/usr/lib/oracle/9.2.0/OraHome/lib/libtrace9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libtracefe9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libtracept9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libunls9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libunwind.so
/usr/lib/oracle/9.2.0/OraHome/lib/libunwind.so.3
/usr/lib/oracle/9.2.0/OraHome/lib/libvsn9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libwtc9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libwtc9.so
/usr/lib/oracle/9.2.0/OraHome/lib/libxml9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libxmlg9.a
/usr/lib/oracle/9.2.0/OraHome/lib/libxsd9.a
/usr/lib/oracle/9.2.0/OraHome/lib/mail.jar
/usr/lib/oracle/9.2.0/OraHome/lib/naect.o
/usr/lib/oracle/9.2.0/OraHome/lib/naedhs.o
/usr/lib/oracle/9.2.0/OraHome/lib/naeet.o
/usr/lib/oracle/9.2.0/OraHome/lib/nautab.o
/usr/lib/oracle/9.2.0/OraHome/lib/nigcon.o
/usr/lib/oracle/9.2.0/OraHome/lib/nigtab.o
/usr/lib/oracle/9.2.0/OraHome/lib/nnfgt.o
/usr/lib/oracle/9.2.0/OraHome/lib/ntcontab.o
/usr/lib/oracle/9.2.0/OraHome/lib/osntabst.o
/usr/lib/oracle/9.2.0/OraHome/lib/s0main.o
/usr/lib/oracle/9.2.0/OraHome/lib/scorept.o
/usr/lib/oracle/9.2.0/OraHome/lib/servlet.jar
/usr/lib/oracle/9.2.0/OraHome/lib/sscoreed.o
/usr/lib/oracle/9.2.0/OraHome/lib/sysliblist

/usr/lib/oracle/9.2.0/OraHome/lib/stubs:
ld-linux-2.2.2-stub.so
ld-linux.so.2
libBrokenLocale-2.2.2-stub.so
libBrokenLocale.so
libBrokenLocale.so.1
libc-2.2.2-stub.so
libcrypt-2.2.2-stub.so
libcrypt.so
libcrypt.so.1
libc.so
libc.so.6
libc.so.sbs
libc.so.tmp
libdl-2.2.2-stub.so
libdl.so
libdl.so.2
libm-2.2.2-stub.so
libm.so
libm.so.6
libNoVersion-2.2.2-stub.so
libNoVersion.so.1
libnsl-2.2.2-stub.so
libnsl.so
libnsl.so.1
libpthread-2.2.2-stub.so
libpthread.so
libpthread.so.0
libresolv-2.2.2-stub.so
libresolv.so
libresolv.so.2
librt-2.2.2-stub.so
librt.so
librt.so.1
libutil-2.2.2-stub.so
libutil.so
libutil.so.1