MapServer and Oracle Spatial

Thu Oct 13 19:17:49 PDT 2005

Hello!
Thanks Fernando, this how-to is more exact now. It should be a bit easier 
to combine the great powers of Oracle spatial and MapServer.

Jukka
ps. I was not able to modify the mentioned page myself even after I 
registered and logged in.

Fernando Simon <fsimon at univali.br>
13/10/2005 18:05

        To:     Bart van den Eijnden <BEN at SYNCERA-ITSOLUTIONS.NL>
        cc:     MAPSERVER-USERS at LISTS.UMN.EDU, Jukka.Sirvio at ARBONAUT.COM
        Subject:        Re: [UMN_MAPSERVER-USERS] MapServer and Oracle 
Spatial

Hi Bart and Jukka,
    I updated the Oracle Spatial howto in Mapserver site 
(http://ms.gis.umn.edu/docs/howto/oracle_spatial_howto) with the last 
information about the Oracle Spatial connection.
    Regards.

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

Bart van den Eijnden wrote:

>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.
>>>
>>>
>>>
>>>
>>>
>>> 
>>>
>>
>>
>>
>>
>> 
>>
>
> 
>