mapserver 4.4.0 / Oracle 9.2.0.4 on SuSE SLES9

[Benjamin Thelen]

Hi,

are there any tricks to get mapserver 4.4.0 compiled with Oracle?
Compiling mapserver 4.2.5 on the same machine with oracle was no
problem at all!
As far as I know, it isn't required to install oracle server, oracle
client is sufficient - at least under windows.

Please look at the following error:

SVR -DUSE_WMS_LYR -DUSE_WFS_SVR -DUSE_WFS_LYR -DUSE_WCS_SVR
-DUSE_ORACLESPATIAL   -DUSE_GD_PNG -DU
SE_GD_JPEG -DUSE_GD_WBMP -DUSE_GD_FT -DGD_HAS_GETBITMAPFONTS
-DUSE_OGR -DUSE_GDAL  -DUSE_ICONV
  -DUSE_POSTGIS    -I/usr/include        -I/usr/local/include
-I/usr/include/pgsql    -I/opt/oracle/O
raHome1/rdbms/demo -I/opt/oracle/OraHome1/rdbms/public    mapwms.c -o
mapwms.o
gcc -c -O2 -fPIC  -Wall -DIGNORE_MISSING_DATA -DNEED_STRLCAT
-DUSE_PROJ -DUSE_PROJ_API_H -DUSE_WMS
_SVR -DUSE_WMS_LYR -DUSE_WFS_SVR -DUSE_WFS_LYR -DUSE_WCS_SVR
-DUSE_ORACLESPATIAL   -DUSE_GD_PNG -DU
SE_GD_JPEG -DUSE_GD_WBMP -DUSE_GD_FT -DGD_HAS_GETBITMAPFONTS
-DUSE_OGR -DUSE_GDAL  -DUSE_ICONV
  -DUSE_POSTGIS    -I/usr/include        -I/usr/local/include
-I/usr/include/pgsql    -I/opt/oracle/O
raHome1/rdbms/demo -I/opt/oracle/OraHome1/rdbms/public
mapwmslayer.c -o mapwmslayer.o
gcc -c -O2 -fPIC  -Wall -DIGNORE_MISSING_DATA -DNEED_STRLCAT
-DUSE_PROJ -DUSE_PROJ_API_H -DUSE_WMS
_SVR -DUSE_WMS_LYR -DUSE_WFS_SVR -DUSE_WFS_LYR -DUSE_WCS_SVR
-DUSE_ORACLESPATIAL   -DUSE_GD_PNG -DU
SE_GD_JPEG -DUSE_GD_WBMP -DUSE_GD_FT -DGD_HAS_GETBITMAPFONTS
-DUSE_OGR -DUSE_GDAL  -DUSE_ICONV
  -DUSE_POSTGIS    -I/usr/include        -I/usr/local/include
-I/usr/include/pgsql    -I/opt/oracle/O
raHome1/rdbms/demo -I/opt/oracle/OraHome1/rdbms/public
maporaclespatial.c -o maporaclespatial.o
maporaclespatial.c:107:17: oci.h: No such file or directory
                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

maporaclespatial.c:125: error: parse error before "OCINumber"
maporaclespatial.c:125: warning: no semicolon at end of struct or union
maporaclespatial.c:126: warning: type defaults to `int' in declaration
of `y'
maporaclespatial.c:126: warning: data definition has no type or
storage class
maporaclespatial.c:127: error: parse error before "z"
maporaclespatial.c:127: warning: type defaults to `int' in declaration
of `z'
maporaclespatial.c:127: warning: data definition has no type or
storage class
maporaclespatial.c:129: warning: type defaults to `int' in declaration
of `SDOPointObj'
maporaclespatial.c:129: warning: data definition has no type or
storage class
maporaclespatial.c:133: error: parse error before "OCINumber"
maporaclespatial.c:133: warning: no semicolon at end of struct or union
maporaclespatial.c:134: warning: type defaults to `int' in declaration
of `srid'
maporaclespatial.c:134: warning: data definition has no type or
storage class
maporaclespatial.c:135: error: parse error before "point"
maporaclespatial.c:135: warning: type defaults to `int' in declaration
of `point'
maporaclespatial.c:135: warning: data definition has no type or
storage cla






Indeed, there is no oci.h! I found one on a oracle server installation
  and copied this and some other missing *.h files to

/OraHome/../rdbms/demo/
/OraHome/../rdbms/public/


on the oracle client machine. But the same error occured again.

I then copied these *.h files to /usr/local, what caused another
error. Please see below. I suppose, that copy some files some where
wasn't the best thing I could do :-)!


gcc -c -O2 -fPIC  -Wall -DIGNORE_MISSING_DATA -DNEED_STRLCAT
-DUSE_PROJ -DUSE_PROJ_API_H -DUSE_WMS
_SVR -DUSE_WMS_LYR -DUSE_WFS_SVR -DUSE_WFS_LYR -DUSE_WCS_SVR
-DUSE_ORACLESPATIAL   -DUSE_GD_PNG -DU
SE_GD_JPEG -DUSE_GD_WBMP -DUSE_GD_FT -DGD_HAS_GETBITMAPFONTS
-DUSE_OGR -DUSE_GDAL  -DUSE_ICONV
  -DUSE_POSTGIS    -I/usr/include        -I/usr/local/include
-I/usr/include/pgsql    -I/opt/oracle/r
dbms/demo -I/opt/oracle/rdbms/public    shp2img.c -o shp2img.o
gcc -O2 -fPIC  -Wall -DIGNORE_MISSING_DATA -DNEED_STRLCAT   -DUSE_PROJ
-DUSE_PROJ_API_H -DUSE_WMS_SV
R -DUSE_WMS_LYR -DUSE_WFS_SVR -DUSE_WFS_LYR -DUSE_WCS_SVR
-DUSE_ORACLESPATIAL   -DUSE_GD_PNG -DUSE_
GD_JPEG -DUSE_GD_WBMP -DUSE_GD_FT -DGD_HAS_GETBITMAPFONTS    -DUSE_OGR
-DUSE_GDAL  -DUSE_ICONV    -D
USE_POSTGIS    -I/usr/include        -I/usr/local/include
-I/usr/include/pgsql    -I/opt/oracle/rdbm
s/demo -I/opt/oracle/rdbms/public    shp2img.o  -L. -lmap -lgd
-L/usr/lib -lgd -ljpeg -lfreetype -lp
ng -lz    -ljpeg -lfreetype -lpng -lz   -lproj -ljpeg
-L/usr/local/lib -lgdal  -L/usr/lib -lpq  -L/
usr/lib -lcurl -L/usr/ssl/lib -lz -lssl -lcrypto -ldl
-L/opt/oracle/lib -lclntsh    -lc  -lm -lstdc+
+  -o shp2img
/usr/lib/gcc-lib/i586-suse-linux/3.3.3/../../../../i586-suse-linux/bin/ld:

cannot find -lclntsh
collect2: ld returned 1 exit status
make: *** [shp2img] Error 1



Has somebody any idea? What about this oci.h? Why is it missing on the
oracle client. Why does ms-4.2.5 compile successfully? What can I do
with ms-4.4.0?

Thanks for any help!

Best Regards,
Benjamin