Error in the oracle connection OCI Handlers.

[Fernando Simon]

Hi Daniel,
    This error (the "Error: ." problem) appear when the Mapserver CGI or 
PHP Module can't find the Oracle environments.
    Are you using Apache or IIS? If you are using apache you need to 
define the environments inside the httpd.conf (using the setenv). Did 
you already try to connect using PHP, without Mapserver, just to test? 
Another issue is about the user that runs the webserver, the user have 
permission to access the Oracle directory?
    Best regards.

-------------------------------------------
Fernando Simon

Daniel Muñoz Castro wrote:
> Hello list.
>
> I'm trying to connect to oracle data base in windows with ms4w.
>
> I have this configured
>
> D:\ms4w\Apache\cgi-bin>mapserv -v
> MapServer version 4.10.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP 
> OUTPUT=PD
> F OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE 
> SUPPORTS=WMS_SERVER SUPP
> ORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT 
> SUPPORTS=WCS_SERVER SUPP
> ORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS 
> INPUT=JPEG INPUT
> =POSTGIS INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE 
> DEBUG=MSDEBUG
>
> and,
>
>   LAYER
>     NAME "Gerencia Oracle"
>     STATUS ON
>     TYPE POLYGON
>     CONNECTIONTYPE ORACLESPATIAL
>     CONNECTION "gis/gis at GIS"
>     DATA "GEOMETRIA FROM GERENCIA3"
>     DUMP TRUE
>     CLASS
>      STYLE
>        OUTLINECOLOR 0 0 0
>        COLOR 0 128 128
>      END
>     END
>   END
>
>
> and,
>
> ALLUSERSPROFILE=C:\Documents and Settings\All Users
> APPDATA=C:\Documents and Settings\geoazul\Application Data
> CommonProgramFiles=C:\Program Files\Common Files
> COMPUTERNAME=DHCP-CORTES
> ComSpec=C:\WINNT\system32\cmd.exe
> GEOSERVER_DATA_DIR=C:\Program Files\GeoServer 1.5.1\data_dir
> HOMEDRIVE=C:
> HOMEPATH=\Documents and Settings\geoazul
> LOGONSERVER=\\DHCP-CORTES
> NUMBER_OF_PROCESSORS=1
> ORACLE_BASE=D:\oracle\product\10.2.0
> ORACLE_HOME=D:\oracle\product\10.2.0\client_1
> ORACLE_SID=GIS
> OS=Windows_NT
> Os2LibPath=C:\WINNT\system32\os2\dll;
> Path=D:\oracle\product\10.2.0\client_1\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\S
> ystem32\Wbem;C:\Program Files\Support Tools\
> PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
> PGLOCALEDIR=C:\Program Files\PostgreSQL\8.2\share\locale
> PROCESSOR_ARCHITECTURE=x86
> PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 7, GenuineIntel
> PROCESSOR_LEVEL=15
> PROCESSOR_REVISION=0207
> ProgramFiles=C:\Program Files
> PROMPT=$P$G
> SESSIONNAME=Console
> SystemDrive=C:
> SystemRoot=C:\WINNT
> TEMP=C:\DOCUME~1\geoazul\LOCALS~1\Temp
> TMP=C:\DOCUME~1\geoazul\LOCALS~1\Temp
> TNS_ADMIN=D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
> USERDOMAIN=DHCP-CORTES
> USERNAME=geoazul
> USERPROFILE=C:\Documents and Settings\geoazul
> windir=C:\WINNT
>
>
> and at last the error
>
>
> *Warning*: [MapServer Error]: msDrawMap(): Failed to draw layer named 
> 'Gerencia Oracle'. in *D:\ms4w\apps\exphp\htdocs\ctacont0.php* on line 
> *155*
>
> *Warning*: [MapServer Error]: msOracleSpatialLayerOpen(): Cannot 
> create OCI Handlers. Connection failure. Check the connection string. 
> Error: . in *D:\ms4w\apps\exphp\htdocs\ctacont0.php* on line *155*
>
> *Fatal error*: Call to a member function saveWebImage() on a 
> non-object in *D:\ms4w\apps\exphp\htdocs\ctacont0.php* on line *156*
>
> I have proved whit other programs and the db is totaly accesible.
>
> I don't know what to do I hope some one can help me.
>
> Thanks.
> -- 
> Salu2!.
>
> Daniel Muñoz Castro
> Ingeniero Catastral y Geodesta
> Cel. 300 2174698
> Casa. 4095990
> Oficina. 7470001 Ext. 1141 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070814/2f509bba/attachment.htm>