[Gdal-dev] Oracle-bindings

[Ethan Alpert]

Do an ldd `which ogrinfo`

You should have the Oracle libraries libclntsh.so.x.x and libwtcx.so
linked in if not then there was a problem building ogr note the 'x' is
the version number. I still use 9.0 but can connect to 10g fine.

Also make sure your tnsnames.ora file is correct.

-e

-----Original Message-----
From: gdal-dev-bounces at lists.maptools.org
[mailto:gdal-dev-bounces at lists.maptools.org] On Behalf Of Stephan Holl
Sent: Wednesday, November 16, 2005 5:52 AM
To: gdal-dev at lists.maptools.org
Subject: [Gdal-dev] Oracle-bindings


Dear List,

I am trying to force OGR to read layer-information out of oracle-spatial
on a remote maschine. With reference to the oracle-specific site[1] I
tried the given example and adopted to my needs, but it did not work.

ogrinfo -ro OCI:user/pw at 192.168.1.199
Unable to open datasource `OCI' with the following drivers. [...]

which gave me an error. When I am on the localhost-maschine, where
oracle is installed, everything works nicely and I get the list of
layers.

Since I am no oracle-guru (first installation) I am wondering if I need
to configure oracle to accept conncetions from within the internal
network and from other maschines. Perhaps someone can give me a hint
where to look at.

TIA for any pointers.

Best
	Stephan