MapServer and Oracle Spatial

[Fernando S.]

Hi,
    I believe that the problem can be with the webserver variables.
    Here in my server needed to set in httpd.conf of apache this variables:
.....
SetEnv ORACLE_SID flserver
SetEnv ORACLE_BASE /oracle
SetEnv ORACLE_HOME /oracle/product/10.1.0/client_1/
SetEnv ORA_NLS33 /oracle/product/10.1.0/client_1/nls/data/
SetEnv NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1
SetEnv LD_LIBRARY_PATH
"/oracle/product/10.1.0/client_1/lib:/lib:/usr/lib:/usr/local/lib"
.....
     Thanks.

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



Lyndon Tiu wrote:

> Hello,
>
> I have:
>
> 1) Mapserver 4.4.1 on Linux compiled with oraclespatial support.
>
> 2) Oracle Spatial 10g on Solaris.
>
> 3) Tnsnames are configured properly and sqlplus from the Linux command
> line can connect to Oracle database on Solaris box.
>
> 4) Listener and database have both been started and are both running on
> Solaris box.
>
> 5) mapserver map file:
>
>        LAYER
>          NAME "oggma"
>          CONNECTIONTYPE oraclespatial
>          CONNECTION "user/pass at orasptl"
>          DATA "GEOM FROM OGGMA USING SRID NULL"
>          STATUS ON
>          TYPE POLYGON
>          CLASS
>                STYLE
>                        OUTLINECOLOR 0 0 0
>                        COLOR 225 225 185
>                END
>          END
>          PROJECTION
>                        "init=epsg:42102"
>        END
>        END
>
> The connect string:
>
> user/pass at ora10g works fine from the command line and from Oracle
> Enterprise Manager so I know tnsnames is configured properly.
>
> Also, the table OGGMA and data are loaded and I can do a select * from
> OGGMA and data would come back fine.
>
>
> 6) Pointing a web browser at mapserver produces the following error:
>
> <?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
> <!DOCTYPE ServiceExceptionReport SYSTEM
> "http://schemas.opengeospatial.net/wms/1.1.1/exception_1_1_1.dtd">
> <ServiceExceptionReport version="1.1.1">
> <ServiceException>
> msDrawMap(): Image handling error. Failed to draw layer named
> &#39;ogma&#39;.
> msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI
> Handlers. Connection failure. Check the connection string. Error: .
> </ServiceException>
> </ServiceExceptionReport>
>
>
> Can someone help me with this issue?
>
> Thank you for any tips and suggestions.
>
> --
> Lyndon Tiu
>