[mapserver-users] mapserver error

[Pano]

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
> mapserver-users at lists.osgeo.org
> 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.