Mapserver and oracle instantclient

[ludovic gnemmi]

Maybe it can help someone who
doesn't want install the standard Oracle Client to
have oraclespatial support. Here is the steps i follow
to compile mapserver and php_mapscript on Linux system
to have oraclespatial support with oracle
instantclient 10g.

*Download and install oracle instantclient and
instantclient-devel packages.

*Adjust LD_LIBRARY_PATH to the instantclient lib
directory.

*Configure Mapserver with oraclespatial support.

*Manually edit Makefiles before compiling to adjust
ORACLESPATIAL_INC and ORACLESPATIAL_LIB paths:
-adjust ORACLESPATIAL_INC to the oci.h file
installation directory.
-adjust the -L portion of ORACLESPATIAL_LIB to the
libclntsh.so.10.1 file installation directory.

looks like this in my Makefile:
ORACLESPATIAL_LIB=-L/usr/lib/oracle/10.1.0.3/client/lib
-lclntsh
ORACLESPATIAL_INC=-I/etc/oracle/include

*Compile  and install  
Mapserver and php_mapscript.

*Configure tnsnames.ora

*Declare oracle variables in httpd.conf:
SetEnv TNS_ADMIN "path/to/tnsnames.ora"
SetEnv LD_LIBRARY_PATH "path to the directory
containing    libclntsh.so.10.1"

I did a lot of things but i think these steps are the
main things.

I'm on Linux Debian with Apache 1.4, php5 (cgi) with
mapserver 4.6.beta3

Ludovic


	

	
		
_____________________________________________________________________________ 
Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails, photos et vidéos ! 
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com