[MAPSERVER-USERS] Debian Oracle10g OCI

Umberto Nicoletti umberto.nicoletti at gmail.com
Tue Sep 16 05:29:50 EDT 2008


Revert configure to the previous oraclespatial setting and try:

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

before configure.

Umberto


2008/9/16  <dzizes451 at gmail.com>:
> Now I get:
>
> checking if OracleSpatial support requested... yes, user supplied
> ORACLE_HOME
> configure: error: Oracle Spatial: libclntsh.so not found.
>
> I enclose the config.log.
>
> --
> Michał
>
>
> 2008/9/16 Umberto Nicoletti <umberto.nicoletti at gmail.com>
>>
>> try:
>>
>> -with-oraclespatial=/usr/lib/oracle/xe/app/oracle/product/10.2.0
>>
>> otherwise post the config.log file.
>>
>> Umberto
>>
>> 2008/9/16  <dzizes451 at gmail.com>:
>> > Thanks for the tip!
>> > The Makefile looks like:
>> >  -------------- Compiler Info -------------
>> >   C compiler:                gcc -O2 -fPIC -Wall
>> >   C++ compiler:              g++ -O2 -fPIC -Wall
>> >   Debug:
>> >   Generic NINT:
>> >
>> >  -------------- Renderer Settings ---------
>> >   zlib support:              -DUSE_ZLIB
>> >   png support:
>> >   palette rgba png support:
>> >   jpeg support:
>> >   iconv support:             -DUSE_ICONV
>> >   AGG support:
>> >   AGG Freetype support:
>> >   Ming(flash) support:
>> >   PDFLib support:
>> >
>> >  -------------- Support Libraries ---------
>> >   Proj.4 support:            -DUSE_PROJ
>> >   Libxml2 support:
>> >   FriBidi support:
>> >   Curl support:              -DUSE_CURL
>> >   FastCGI support:
>> >   Threading support:         -DUSE_THREAD
>> >   GEOS support:
>> >
>> >  -------------- Data Format Drivers -------
>> >   native tiff support:
>> >   PostGIS support:
>> >   EPPL7 support:             -DUSE_EPPL
>> >   ArcSDE support:
>> >   OGR support:               -DUSE_OGR
>> >   GDAL support:              -DUSE_GDAL
>> >   Oracle Spatial support:    -DUSE_ORACLESPATIAL
>> >
>> >  -------------- OGC Services --------------
>> >   WMS Server:                -DUSE_WMS_SVR
>> >   WMS Client:                -DUSE_WMS_LYR
>> >   WFS Server:
>> >   WFS Client:                -DUSE_WMS_LYR
>> >   WCS Server:
>> >   SOS Server:
>> >
>> >  -------------- MapScript -----------------
>> >   PHP MapScript:             no
>> >
>> > the make command throws the following error:
>> >
>> >  warning: libnnz10.so, needed by
>> > /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so,
>> > not
>> > found (try using -rpath or -rpath-link)
>> > /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:
>> > undefined reference to `nztSearchNZDefault'
>> > /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:
>> > undefined reference to `nzosCipherSpecToStr'
>> > /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:
>> > undefined reference to `nztwOpenWallet'
>> > /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so:
>> > undefined reference to `A_X931RandomInit'
>> > ....
>> > ends with
>> > collect2: ld returned 1 exit status
>> > make: *** [shp2img] Error 1
>> >
>> > any ideas!
>> >
>> > --
>> > Michał
>> >
>> >
>> > 2008/9/16 Umberto Nicoletti <umberto.nicoletti at gmail.com>
>> >>
>> >> Usign tiff AND gdal is not recommended, you'd better try these options:
>> >>
>> >> ./configure
>> >> -with-oraclespatial=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
>> >> -with-proj -with-wfsclient -with-wmsclient -with-gdal -with-ogr
>> >> -with-threads -with-freetype  -without-tiff -with-FastCGI
>> >>
>> >> as for the expat error:
>> >>
>> >> sudo apt-get install libexpat1 libexpat1-dev
>> >>
>> >> Umberto
>> >>
>> >> 2008/9/16  <dzizes451 at gmail.com>:
>> >> > Hi again,
>> >> >
>> >> > I've tried to compile mapserv executable with:
>> >> >
>> >> > ./configure
>> >> >
>> >> > -with-oraclespatial=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
>> >> > -with-proj -with-wfsclient -with-wmsclient -with-gdal -with-ogr
>> >> > -with-threads -with-freetype  -with-tiff -with-FastCGI
>> >> >
>> >> > and I receive this error:
>> >> >
>> >> > /usr/bin/ld: cannot find -lexpat
>> >> > collect2: ld returned 1 exit status
>> >> > make: *** [shp2img] Error 1
>> >> >
>> >> > Does anyone know what is wrong?
>> >> >
>> >> > --
>> >> > Michał
>> >> >
>> >> >
>> >> > On Mon, Sep 15, 2008 at 3:16 PM, Dan Little <danlittle at yahoo.com>
>> >> > wrote:
>> >> >>
>> >> >> 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
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >> > _______________________________________________
>> >> > mapserver-users mailing list
>> >> > mapserver-users at lists.osgeo.org
>> >> > http://lists.osgeo.org/mailman/listinfo/mapserver-users
>> >> >
>> >> >
>> >
>> >
>
>


More information about the mapserver-users mailing list