[Mapserver-users] msOCIConnect() in msOracleSpatialLayerOpen(): OracleSpatial error.

[Timothy.Mackey at ga.gov.au]

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