[gdal-dev] pg2oci

wochter wochter at seznam.cz
Mon Mar 31 08:18:21 EDT 2008


Hi,
I need migrate data from postgres (postgis) to oracle.
I'd like to compile own gdal-bin (ogr2ogr) package with OCI.
I running last kubuntu on 32bit platform.

I downloaded from oracle site this:

 instantclient-basic-linux32-10.2.0.3-20061115.zip
 instantclient-sdk-linux32-10.2.0.3-20061115.zip
 instantclient-sqlplus-linux32-10.2.0.3-20061115.zip

Unpacked to /usr/local/oraclient
ln -s libclntsh.so.10.1 libclntsh.so
ln -s libocci.so.10.1 libocci.so
ln -s libocci.so.10.1 liboci.so   /*don't know if is it good solution*/
Added /usr/local/oraclient to ld.so.conf

then:

ldconfig
cd /usr/src
apt-get source gdal-bin
cd gdal-1.4.1

vim debian/rules
 added this..
        --with-oci-include=/usr/local/oraclient/sdk/include \
	--with-oci-lib=/usr/local/oraclient \

$./debian/rules binary

gdal-bin package was compiled correctly, but
ogrinfo --formats   says no OCI driver is compiled in.

Here is extract from output displayed during compilation:

checking for Oracle OCI headers in /usr/local/oraclient/sdk/include... yes
checking for Oracle OCI libraries in /usr/local/oraclient... yes
checking if Oracle OCI version is >= 8.1.7... yes
checking for Oracle version >= 10.x to use -lnnz10 flag... yes
checking if Oracle support is enabled... yes

  OCI support:               yes


What is wrong?
Could you help me please?
Thank you a lot.

wochter




More information about the gdal-dev mailing list