[osgeo4w-dev] Binary inconpatible GDAL plugin for Oracle

[Ivan Lucena]

Hi Jürgen,

Thank you for taking the time to sort that out.

OK. Here is the error message that comes just after open the OSGeo4W shell command line. I don't know if you have ever noticed that by some Windows message can be copied&pasted as text, so here is the message in text format:

====================================================
[Window Title]
gdalinfo.exe

[Main Instruction]
gdalinfo.exe has stopped working

[Content]
A problem caused the program to stop working correctly. Please close the program.

[Close the program] [Debug the program]
====================================================

Here is the result of running ogrinfo (with debugging):

====================================================
C:\>ogrinfo oci:scott/tiger at orcl --debug on
OCI: Userid=scott, Password=tiger, Database=orcl
OCI: Prepare(ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD' NLS_TIME_FORMAT='HH24:MI:SS' NLS_TIME_TZ_FORMAT='HH24:MI:SS TZHTZM' NLS_TIMESTAMP_FORMAT='YYYY/MM/DD  H24:MI:SS'         NLS_TIMESTAMP_TZ_FORMAT='YYYY/MM/DD HH24:MI:SS TZHTZM')
OCI: Prepare(SELECT TABLE_NAME, OWNER FROM ALL_SDO_GEOM_METADATA)

C:\>
====================================================

As you can see there is no error message (printed or in a GUI) and the debugging doesn't return any hint. 

And here my work around. Like I said before, I copy the plugins from these gisinternals.com/sdk installers: 

- gdal-19-1600-core.msi
- gdal-19-1600-oracle.msi

====================================================
C:\OSGeo4W\bin\gdalplugins\1.9>copy "C:\Program Files (x86)\GDAL\gdalplugins\gdal_GEOR.dll" .
        1 file(s) copied.

C:\OSGeo4W\bin\gdalplugins\1.9>copy "C:\Program Files (x86)\GDAL\gdalplugins\ogr_OCI.dll" .
        1 file(s) copied.
====================================================

After that command, launching the OSGeo4W shell doesn't give me any error, all GDAL command line works perfectly with Oracle drivers. Quantum GIS also works well with Raster or Vector coming from a Oracle Spatial connection.

To make sure that the issue was not related to the OCI.DLL installed by OSGeo4W installer, I put my instant client up front on the PATH:

====================================================
C:\>set PATH=C:\instantclient_11_2;%PATH%
====================================================

By doing that, nothing changes, the original OSGeo4W DLL doesn't work and the one from Tamasz work, as long as it is VC 1600 compiled.

So are you going to update the OSGeo4W installer with the ones you re-compiled?

Could you please let me know when is it ready, so I can give it a try?

Thanks a lot.

Regards,

Ivan

>  -------Original Message-------
>  From: Jürgen E. Fischer <jef at norbit.de>
>  To: osgeo4w-dev at lists.osgeo.org
>  Subject: Re: [osgeo4w-dev] Binary inconpatible GDAL plugin for Oracle
>  Sent: Feb 27 '13 16:07
>  
>  Hi Ivan,
>  
>  On Wed, 27. Feb 2013 at 13:49:30 -0500, Ivan Lucena wrote:
>  > 1 - After installing GDAL latest (1.9.2) with GDAL-Oracle plugins, the
>  >     OSGeo4W show an error message when it tries to run "gdalinfo --version"
>  >     at the end of the shell initialization script.
>  
>  Some useful error message or just a mostly useless crash notification?
>  
>  
>  > 2 - Running gdalinfo or ogrinfo with Oracle driver doesn't work and the
>  >     errors random, sometimes an error message pops up, sometimes nothing
>  >     happens, just the prompt comes back without any printing.
>  
>  Hm, for me gdalinfo --formats reported GeoRaster and ogrinfo OCI.  But I must
>  admit that I never tried georaster so far - apparently that didn't work here.
>  I'm relativly sure I've used ogr2ogr with that oci driver before.
>  
>  Anyway, I've rebuilt both - georaster now works for me (populating oracle with
>  gdal_translate tif to geor and viewing using the qgis oracle raster plugin from
>  qgis).
>  
>  > 3 - QGIS also doesn't work when you try to load vector or raster. You might
>  >     get a connection sometimes or even get a georaster to display but it
>  >     crashes when loading geometries.
>  
>  Works for me now, too.  Didn't retest with the previous DLLs.
>  
>  > One more think. I have users that got QGIS directly from QGIS website and
>  > encountered the same problem after installing and trying to use the Oracle
>  > plugins. Would that be a coincidence?
>  
>  The standalone installer uses the OSGEO4W packages too (but doesn't include
>  oracle support).  So no coincidence at all.
>  
>  
>  Jürgen
>  
>  --
>  Jürgen E. Fischer         norBIT GmbH               Tel. +49-4931-918175-31
>  Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
>  Software Engineer         D-26506 Norden               http://www.norbit.de
>  committ(ed|ing) to Quantum GIS                         IRC: jef on FreeNode                        
>  
>  --
>  norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
>  Rheinstrasse 13, 26506 Norden
>  GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502
>  
>  _______________________________________________
>  osgeo4w-dev mailing list
>  osgeo4w-dev at lists.osgeo.org
>  http://lists.osgeo.org/mailman/listinfo/osgeo4w-dev
>