Oracle / OCI error

[Fernando Simon]

Hi François,
    This problem can occur when the user that run Mapserv can't access 
the Oracle home. Did you define the same variables in the console that 
the user that run Mapserver? Can this user access (read permission) the 
ORACLE_HOME folder?
    You need to specify the Oracle enviroments for Oracle Spatial 
support (native connection) in Mapserver, you can check this link how to 
define it: 
http://www.puschitz.com/InstallingOracle9i.shtml#SettingOracleEnvironments
    Thanks.

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


François Prunayre wrote:

>Hi, question for Oracle users
>
>Mapserver error is :
>msDrawMap(): Image handling error. Failed to draw layer named 'CIBA'. 
>msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers.
>Connection failure. Check the connection string. Error: . 
>
>With mapfile :
>CONNECTIONTYPE oraclespatial
>CONNECTION "zonage/zonage at rnde"
>DATA "GEOM FROM CIBA USING UNIQUE ID SRID 41014"
>
>With OGR, same problem
>  CONNECTION "oci:zonage/zonage at rnde"
>  CONNECTIONTYPE OGR
>  DATA "CIBA"
>
>And ogrinfo oci:zonage/zonage at rnde CIBA works fine.
>
>Httpd.conf is :
>LoadModule cgi_module modules/mod_cgi.so 
>#LoadModule fastcgi_module modules/mod_fastcgi.so
>
><IfModule mod_env.c>
>SetEnv TNS_ADMIN "/usr/local/oracle/product/10.2.0/client_1/network/admin"
>SetEnv PATH "/usr/local/oracle/product/10.2.0/client_1/bin"
>#SetEnv ORACLE_SID rnde
>#SetEnv ORACLE_HOME /usr/local/oracle/product/10.2.0/client_1
>#SetEnv LD_LIBRARY_PATH
>/usr/local/oracle/product/10.2.0/client_1/lib:/usr/local/oracle/product/10.2
>.0/client_1
>SetEnv NLS_LANG AMERICAN_AMERICA.WE8ISO8859P15 </IfModule>
>
>
>Any ideas on what is wrong ? I would like to use fastcgi once cgi works.
>What do we have to set for fastcgi to work with oracle &mapserver ? 
>
>Thanks. 
>Francois
>
>
>
>Office International de l'EAU
>Web         : http://www.oieau.fr
>
>
>--
>Ce message a ete verifie par MailScanner pour des virus ou des polluriels et
>rien de suspect n'a ete trouve.
>
>Les donnees et renseignements contenus dans ce message sont personnels,
>confidentiels et prives. Toute publication, utilisation ou diffusion, meme
>partielle, doit etre autorisee.
>
>Any data and information contained in this electronic mail is personal,
>confidential and secret. Any total or partial publication, use or
>distribution must be authorized.
>
>
>  
>