[Mapserver-users] msOCIConnect() in msOracleSpatialLayerOpen(): OracleSpatial error.
Timothy.Mackey at ga.gov.au
Timothy.Mackey at ga.gov.au
Wed Apr 16 17:39:35 PDT 2003
Hi,
I also got this error, and traced it back to environment settings in Apache, for ORACLE_SID TWO_TASK TNS_ADMIN ORACLE_HOME.
Do you have this line in your httpd.conf?
PassEnv ORACLE_SID TWO_TASK TNS_ADMIN ORACLE_HOME
Also, you can look at the "printenv" CGI program that comes with Apache, to see if the variables your are setting in httpd.conf are getting to the shell Apache creates to run the CGI programs.
regards,
Tim Mackey
Webmaster
Geoscience Australia
timothy.mackey at ga.gov.au
http://www.ga.gov.au
-----Original Message-----
From: nakts at latnet.lv [mailto:nakts at latnet.lv]
Sent: Wednesday, 16 April 2003 7:49 PM
To: mapserver-users at lists.gis.umn.edu
Subject: [Mapserver-users] msOCIConnect() in msOracleSpatialLayerOpen():
OracleSpatial error.
Hello
msOCIConnect() in msOracleSpatialLayerOpen(): OracleSpatial error.
on Windows XP with
Oracle Client 8.1.7.
MapServer version 3.6.1 ..INPUT=ORACLESPATIAL ..
MapServer is on my local PC, Oracle DB - on other linux server.
Mapserver works fine with .shp files.
I can connect through SQPLUS, bu not this way:
LAYER
NAME "ielaaas"
STATUS DEFAULT
CONNECTIONTYPE oraclespatial
CONNECTION 'username.../pwd... at po1'
TYPE POLYGON
DATA "GEOM FROM SHP_CLIP96 USING SRID 82305"
CLASS
NAME "ielaaas"
COLOR 220 220 220
OUTLINECOLOR 0 0 0
END
END
I tried a lot of combinations in httpd.conf like:
LoadModule env_module modules/mod_env.so
...
<IfModule mod_env.c>
SetEnv ORACLE_SID po1
SetEnv ORACLE_HOME "C:\oracle\ora81"
SetEnv ORA_NLS33 "C:\oracle\ora81\ocommon\nls\ADMIN\DATA"
SetEnv LD_LIBRARY_PATH "C:\oracle\ora81\lib"
SetEnv TNS_ADMIN "C:\oracle\ora81\network\ADMIN"
</IfModule>
Where could be the problem, how to test what Mapserver is doing, how it tries to
connect to DB ?
Thanks,
Ima
_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
More information about the MapServer-users
mailing list