Hi Iratxe,
Looks like mapserver doesnt know the TNS name 'orcl' that you have defined.
I assume that the machine where mapserver runs has an oracle client
installed? Can you log into sql plus i..e sqlplus mddata/<passwd>@orcl from
a command prompt on this box? I assume you will get the same TNS error.
Which will mean that your tnsnames.ora file is not set correctly. The file
should be located under $ORACLE_HOME\network\admin\tnsnames.ora. There
should be an entry in there like:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = <server_name_or_IP)
(PORT = <usually_1521>)
)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <oracle_service_name>)
)
)
Hope this helps,
Pano
Iratxe Lejarreta wrote:
>
> Hi,
>
> I installed MapServer-5.2.0 on CentOS 5.2 with Oracle 10g, but when I run
> the
> WFS service...
>
> http://localhost/cgi-
> bin/mywfs?SERVICE=WFS&VERSION=1.0.0&REQUEST=getfeature&TYPENAME=cities
>
> ...the result is:
> −
> <ServiceExceptionReport version="1.2.0"
> xsi:schemaLocation="http://www.opengis.net/ogc
> http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd";>
> −
> <ServiceException code="NoApplicableCode" locator="mapserv">
>
> msWFSGetFeature(): WFS server error. ms_error->code not found
> msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI
> Handlers.
> Connection failure. Check the connection string. Error: ORA-12154:
> TNS:could
> not resolve the connect identifier specified
> .
> msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI
> Handlers.
> Connection failure. Check the connection string. Error: ORA-12154:
> TNS:could
> not resolve the connect identifier specified
> .
>
> </ServiceException>
> </ServiceExceptionReport>
>
>
> Mapfile:
>
> MAP
> NAME WFS_TEST
> STATUS ON
> SIZE 400 300
> EXTENT -180 -90 180 90
> UNITS METERS
> IMAGECOLOR 255 255 255
> WEB
> METADATA
> "wfs_title" "WFS TEST"
> "wfs_onlineresource" "http://localhost/cgi-bin/mywfs?";
> "wfs_srs" "EPSG:4326"
> END
> END
> PROJECTION
> "init=epsg:4326"
> END
> LAYER
> NAME cities
> TYPE POINT
> CONNECTIONTYPE oraclespatial
> CONNECTION "MDDATA/**...@orcl"
> DATA "GEOM FROM CITIES USING UNIQUE FID SRID 4326 VERSION 10g"
> METADATA
> "wfs_title" "cities"
> "gml_featureid" "FID"
> "gml_include_items" "all"
> END
> STATUS ON
> DUMP TRUE
> CLASS
> STYLE
> OUTLINECOLOR 0 0 0
> COLOR 0 128 128
> END
> END
> END # Cities
> END # Map File
>
>
> Somebody can help me?
>
> Thanks in advance.
>
> --
> Iratxe Lejarreta
> www.axios.es
>
> _______________________________________________
> mapserver-users mailing list
> [email protected]
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
--
View this message in context:
http://n2.nabble.com/mapserver-error-tp2671622p2674567.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
