MapServer and Oracle Spatial

Thu Oct 13 09:59:20 EDT 2005

Hi Jukka,

the Wiki is read-only because of spam so no new content can be added there.

Please add the comments on the new Plone site, you can do it yourself there:

http://ms.gis.umn.edu/docs/howto/oracle_spatial_howto/view?searchterm=oracle%20spatial

First join the site, then you can add comments. Thanks in advance.

Best regards,
Bart

Bart van den Eijnden
Syncera IT Solutions
Postbus 270
2600 AG  DELFT

tel.nr.: 015-7512436
email: BEN at Syncera-ITSolutions.nl

>>> Jukka Sirviö <Jukka.Sirvio at ARBONAUT.COM> 13-10-2005 15:03:16 >>>
Ok, thank you for help, 
MapServer native support for oracle spatial seems to be working now.

Could you (or probaply the author: Bart van den Eijnden, The Netherlands, 
bartvde at xs4all.nl)  add following comments to Oracle Spatial 
MaopServerWiki:

=========
For Windows users:
Add following enviroment variables (under System) pointing to your actual 
oracle client home directory, these variables tell the MapServer where the 
oracle client binaries and tnsnames.ora information can be found. If you 
receive errormessage like "Error: .". It's related with access to Oracle 
files and you should check these enviroment variables!
ORACLE_SID "database sid from tnsnames.ora"
TNS_ADMIN "folder where the tnsnames.ora exist"
ORACLE_HOME "oracle client home directory"
=========

Yours:
Jukka

Fernando Simon <fsimon at univali.br>
13/10/2005 08:48

        To:     Jukka Sirviö <Jukka.Sirvio at arbonaut.com>
        cc:     MAPSERVER-USERS at LISTS.UMN.EDU 
        Subject:        Re: [UMN_MAPSERVER-USERS] MapServer and Oracle 
Spatial

Hi Jukka,
    This error occur when the Mapserver can't access the ORACLE_HOME 
directory.
    When the Oracle Spatial connection return an empty error: "Error: 
.". It's relate with access to Oracle files.
     In your case I believe that if you set the same enviroments in 
console this error disappear.
    Can you set the Oracle enviroments in console (as System variables 
in Windows) instead of httpd env?
    Here, for Windows, I use the Hobu Mapserver binaries 
(http://hobu.stat.iastate.edu/mapserver/) with Oracle Spatial support.
    Thanks again.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------

Jukka Sirviö wrote:

>Hello Fernando!
>Sorry for not including the information from original threads to my 
>message, Below is the headers of earlier discussions, I face exatly same 
>kind of problems even after the proposed solutions.Wiki for MapServer + 
>Ora Spatial does not give any additional information 
>(http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?OracleSpatial).
>
>Mapserver error is :
>msDrawMap(): Image handling error. Failed to draw layer named 'xxxx'. 
>msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI 
>Handlers. Connection failure. Check the connection string. Error: . 
>
>My httpd.conf contains following:
>SetEnv MS_ERRORFILE "D:\Apache2\logs\stderr_mapserver.log"
>SetEnv ORACLE_SID UDIGTEST
>SetEnv ORACLE_BASE "C:\Oracle\"
>SetEnv ORACLE_HOME "C:\Oracle\10.1.0Client_1\"
>SetEnv TNS_ADMIN "C:\Oracle\10.1.0Client_1\network\admin\"
>
>And my mapfile have following entry:
>CONNECTIONTYPE oraclespatial
>CONNECTION "xxx/xxx at UDIGTEST"
>DATA "GEOLOC FROM METSIKKOKUVIOT"
>TYPE POLYGON
>
>And my tnsnames.ora have following entry (works with sqlplus and 
tnsping):
>UDIGTEST =
>  (DESCRIPTION =
>    (ADDRESS_LIST =
>      (ADDRESS = (PROTOCOL = TCP)(HOST = jukka)(PORT = 1521))
>    )
>    (CONNECT_DATA =
>      (SERVICE_NAME = udigtest)
>    )
>  )
>
>I tried several mapserver binaries which include oracle support. Next I 
>will try different mapserver binaries against 10g database (currently 
>testing against 9.2.0.6 -release)
>
>-Jukka
>::::::::::::::::::::::::::::::::::::
>:::::: THREAD1 ::::::
>::::::::::::::::::::::::::::::::::::
>Date:         Thu, 11 Aug 2005 08:49:31 +0200
>Reply-To:     François Prunayre <fx.prunayre at OIEAU.FR>
>Sender:       UMN MapServer Users List <MAPSERVER-USERS at LISTS.UMN.EDU>
>From:         François Prunayre <fx.prunayre at OIEAU.FR>
>Organization: Office International de l'Eau
>Subject:      Re: Oracle / OCI error
>In-Reply-To:  <42F7581A.4050505 at univali.br>
>Content-Type: text/plain; charset="iso-8859-1"
>
>::::::::::::::::::::::::::::::::::::
>:::::: THREAD2 ::::::
>::::::::::::::::::::::::::::::::::::
>Date:         Wed, 26 Jan 2005 08:41:48 +0000
>Reply-To:     "Fernando S." <fsimon at UNIVALI.BR>
>Sender:       UMN MapServer Users List <MAPSERVER-USERS at LISTS.UMN.EDU>
>From:         "Fernando S." <fsimon at UNIVALI.BR>
>Subject:      Re: MapServer and Oracle Spatial
>In-Reply-To:  <41F6DEDC.4070009 at alumni.sfu.ca>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>
>
>
>
>
>Fernando Simon <fsimon at univali.br>
>12/10/2005 14:57
> 
>        To:     Jukka Sirviö <jukka.sirvio at ARBONAUT.COM>, 
>MAPSERVER-USERS at LISTS.UMN.EDU 
>        cc: 
>        Subject:        Re: [UMN_MAPSERVER-USERS] MapServer and Oracle 
>Spatial
>
>
>Hi Jukka,
>    I didn't understand the situation that you described, can you sent 
>the error message that Mapserver returned?
>    Thanks again.
>
>------------------------------------------------------------------------
>Fernando Simon
>Mapserver and Oracle Spatial developer
>G10 - Laboratorio de Computacao Aplicada - Brazil
>http://www.univali.br/g10 - UNIVALI/CTTMAR
>------------------------------------------------------------------------
>
>
>Jukka Sirviö wrote:
>
> 
>
>>Hello!
>>I have exatly same situation, but I'm receiving the same errormessage 
>> 
>>
>even
> 
>
>>after setting the apache enviroment variables. MapServer is running on 
>> 
>>
>Win
> 
>
>>XP sp1 with Apache 2.0.54 (tested also on win NT 4.0 with apache 1.3.33)
>>
>>There is read / write access to oracle_home for anyone -user.
>>
>>
>>
>> 
>>
>
>
>
>
> 
>