[mapserver-users] Oracle Spatial configuration

[Begoña Gonzalez]

Hello Brok
I am relatively new in mapserver but I´m working with spatial oracle.
As you, I follow the steps of Oracle Spatial "howtos". Your September
env seem to be well, and the chain of connection tambiñen.

Your apache httpd.conf and mapfile seem to be well,  these are mine:

#Añadido para conectar a Oracle
SetEnv ORACLE_SID eiel3
SetEnv TNS_ADMIN "c:/oracle/product/10.2.0/client_1/NETWORK/ADMIN"
SetEnv ORACLE_HOME "c:/oracle/product/10.2.0/client_1"


Have you also followed these steps?
http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-10g

I hope this will help you
Begoña

LAYER
 NAME "INFRAESTRUCTURA_VIARIA"
 STATUS ON
 TYPE POLYGON
 CONNECTIONTYPE oraclespatial
 CONNECTION "****/****@eiel3"
 DATA "GEOLOC FROM MY_TABLE  USING UNIQUE MI_PRINX SRID 82337"
 METADATA
  qstring_validation_pattern '.'
 END
 CLASS
  STYLE
    COLOR 252 183 12
    OUTLINECOLOR 255 0 0
  END
  TEMPLATE "templates/INFRAESTRUCTURA_VIARIA.html"
 END
END

On Fri, Feb 22, 2008 at 11:20 PM, Brock Anderson
<banders at refractions.net> wrote:
> Hi Folks,
>
> I've just compiled Mapserver 4.10 for windows with Oracle Spatial
> support against Oracle's "instant client SDK" and "instant client
> basic".  That seemed to go smoothly.  I'm now trying to configure
> Mapserver and my map file with an Oracle Spatial layer.  So far I
> haven't successfully served up my Oracle Spatial data.
>
> When I make a WMS getmap request for my layer I get back an XML error
> message saying this:
> msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI
> Handlers. Connection failure. Check the connection string. Error:
> ORA-12705: Cannot access NLS data files or invalid environment specified
>
> I think my problem is with the environment variables that Mapserver and
> the Oracle instant client depend on.  I've followed Oracle Spatial
> "howtos" here:
> http://mapserver.gis.umn.edu/docs/howto/oracle_spatial_howto
> http://mapserver.gis.umn.edu/docs/howto/Configure%20Oracle%20and%20UMN
>
> Here's a snippet from my apache httpd.conf:
>
> <Location "/cgi-bin/">
>    SetEnv ORACLE_HOME "c:/oracle_sdk/instantclient_11_1"
>    SetEnv TNS_ADMIN "c:/DevSuiteHome/network/admin"
>    SetEnv ORACLE_SID "MY_ORACLE"
>    SetEnv PATH "c:/oracle_sdk/instantclient_11_1"
> </Location>
>
> I've also defined each of those variables directly as windows
> environment variables, just to be safe. Mapserver seems to pick up my
> tnsnames.ora file, so TNS_ADMIN is probably getting recognized.  My
> mapfile is pasted below.
>
> Does anyone else have Oracle Spatial support working?  Can you share
> with me which environment variables you use, how you set them, and what
> values you set them to?
>
> Cheers,
> Brock
>
> MAP
>  EXTENT 200000 200000 2100000 2100000
>  SIZE 100 100
>  UNITS meters
>  WEB
>    METADATA
>      "wms_title" "test"
>      "wms_onlineresource" ""
>      "wms_srs" "epsg:4269 epsg:4326 epsg:26909 epsg:42102 epsg:3005"
>      "wfs_onlineresource" ""
>    END #end metadata
>  END #end web
>  PROJECTION
>    "init=epsg:3005"
>  END #end projection
>  DEBUG ON
>
>  LAYER
>    NAME 'test'
>        CONNECTIONTYPE oraclespatial
>        CONNECTION 'user/pass at MY_ORACLE'
>        DATA 'GEOMETRY FROM MY_TABLE USING UNIQUE MAP_FEATURE_ID SRID
> 3005 VERSION 10g'
>        CLASS
>            STYLE
>                COLOR 194 164 84
>      END #end style
>    END #end class
>    TYPE line
>    STATUS ON
>    PROJECTION
>            "init=epsg:3005"
>    END
>        METADATA
>            "wms_title" "test"
>        END #end metadata
>        DEBUG ON
>  END #end layer
>
> END #end map
>
>
>
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>