[MAPSERVER-USERS] Debian Oracle10g OCI

[Dan Little]

Umberto is right, for Mapserver to connect to Oracle you need to specify that capability at compile time.  But for you ge tthat far I think you need to make sure that some of the basics work.

Also, if you cannot connect to Oracle via SQL*Plus (assuming the binary is installed) you have other problems including but not limited to:
- needing to set the LD_LIBRARY_PATH to include all the libraries.  This may also need to be done in Apache while running mapserver to access Oracle.
- needing to configure your TNSNAMES file.
- check firewall setting in order to make sure you can connect on 1521 (or whatever port you are using for Oracle).

Generally, when running an Oracle layer, you want to try the following diagnostic steps:
1) Use SQL Developer to connect to the database (it has it's own drivers built in, so there's no software dependency issues).  This will resolve whether or not the databas is working.
2) On the machine, try connecting with SQL Plus.  This will determine whether or not you have your client configured correctly.  Do not move on until this works.
3) Try and re-compile Mapserver with Oracle Spatial.  At the end of the ./configure script there is an output screen, ensure that you see Oracle is turned on, otherwise scroll up in the screen and see what's missing.



----- Original Message ----
> From: Umberto Nicoletti <umberto.nicoletti at gmail.com>
> To: dzizes <dzizes451 at gmail.com>
> Cc: mapserver-users at lists.osgeo.org
> Sent: Monday, September 15, 2008 7:45:48 AM
> Subject: Re: [MAPSERVER-USERS] Debian Oracle10g OCI
> 
> You have to recompile mapserver with the:
> 
> --with-oraclespatial=[path to oracle home]
> 
> option. That's all that is needed to enable oracle spatial support in mapserver.
> 
> HTH,
> Umberto
> 
> On Mon, Sep 15, 2008 at 2:05 PM, dzizes wrote:
> >
> > Hi,
> >
> > I've installed mapserver on Debian (lenny distribution). I've managed to
> > create mapfile based on shp data and successfully send a wms request to get
> > a map. I seems that mapserver works fine.
> >
> > I've also installed oracle-ex and I can connect to my Oracle via sqlplus.
> > However, when I request wms (to a map file pointing to Oracle10g) I receive
> > the following:
> >
> > msDrawMap(): Image handling error. Failed to draw layer named 'test'.
> > msOracleSpatialLayerOpen(): OracleSpatial error. OracleSpatial is not
> > supported
> >
> > I've found that I need OCI installed and configured properly, but there is
> > no clear tutorial.
> > Please provide me a some step by step guide.
> >
> > Greets,
> > Michal
> >
> > --
> > View this message in context: 
> http://www.nabble.com/Debian-Oracle10g-OCI-tp19491636p19491636.html
> > Sent from the Mapserver - User mailing list archive at Nabble.com.
> >
> > _______________________________________________
> > mapserver-users mailing list
> > mapserver-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapserver-users
> >
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users