Oracle / OCI error

[François Prunayre]

Thanks Fernando. Problem was read access to ORACLE_HOME for apache users.


-----Message d'origine-----
De : UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] De la
part de Fernando Simon
Envoyé : lundi 8 août 2005 15:03
À : MAPSERVER-USERS at LISTS.UMN.EDU
Objet : Re: [UMN_MAPSERVER-USERS] Oracle / OCI error

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.
>
>
>  
>

--
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.


-- 
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.