[Qgis-user] Can't Add Oracle Spatial Vector Layer with QGIS 2.0 on Mac OSx

[William Kyngesburye]

You'll have to compile QGIS yourself...

You need OCI Basic (or Basic Lite) and OCI SDK.

unzip the sdk

unzip basic

rename the clntsh dylib to remove the numbers at the end (should end with .dylib).  you can ignore the occi dylib since it's not used.  copy libclntsh and libnnz11 to /usr/local/lib

update clntsh with:
  install_name_tool -id /usr/local/lib/libclntsh.dylib -change /ade/b/2649109290/oracle/ldap/lib/libnnz11.dylib /usr/local/lib/libnnz11.dylib /usr/local/lib/libclntsh.dylib

add to QGIS cmake configure before the last ".." (make sure to fill in correct path to your OCI sdk):

-D WITH_ORACLE=true -D OCI_LIBRARY=/usr/local/lib/libclntsh.dylib \
-D OCI_INCLUDE_DIR=/path/to/unzipped/oci/sdk/include \


On Oct 23, 2013, at 8:30 AM, chris marx wrote:

> Hi,
>  Ok, thanks for taking a look. Given that I'm just getting started with QGIS, I'm a little lost on where to start with how I would do this then on my own? Any pointers?
> Thanks,
> Chris-
> 
> 
> On Tue, Oct 22, 2013 at 8:00 PM, William Kyngesburye <woklist at kyngchaos.com> wrote:
> Now I remember another reason(s) why I stopped supporting Oracle (in GDAL)...
> 
> Attitude - registration I can deal with, but requiring full business contact info is too much.
> 
> They STILL don't know how to name OS X libraries.  As is, cmake will not find them.  Neither will standard configure scripts (ie GDAL).  This means renaming the libraries (and fixing the internal linking) and organizing the libraries and headers to build for them.  But while end-users could do the same library renaming without much fuss, the internal link fixing requires a tool from Xcode, which defeats the point of installing prebuilt binaries.
> 
> I don't really want to deal with this. :(
> 
> On Oct 22, 2013, at 9:25 AM, chris marx wrote:
> 
> > Ok, Thanks for the heads up. I've been using the Oracle instant client as well as Oracle Sql Developer with no problems on my mac. I think the OCI libraries come with the instant client?
> >
> > http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html
> >
> >
> > On Tue, Oct 22, 2013 at 10:18 AM, William Kyngesburye <woklist at kyngchaos.com> wrote:
> > I figured someone else would have a good answer.  I wasn't aware of the new Oracle driver, and when you mentioned it I thought it was self-contained or used GDAL.
> >
> > But now that I look at it closer, I did not build QGIS with Oracle support (it's direct support, not thru GDAL).  I gave up on the OCI libraries for OSX a long time ago, but maybe they've caught up recently.  I'll look into it.  There's nothing you can do to get the existing build to work.
> >
> > On Oct 22, 2013, at 8:47 AM, chris marx wrote:
> >
> > > In case anyone wants to earn a bounty over at stackexchange, I've gotten no responses, so I've offered one-
> > >
> > > http://gis.stackexchange.com/questions/74842/add-oracle-spatial-vector-layer-with-qgis-2-0-on-mac-osx
> > >
> > >
> > > On Fri, Oct 18, 2013 at 5:15 PM, chris marx <chrismarx at gmail.com> wrote:
> > > I installed version 2.0 using the recommended mac installer (http://www.kyngchaos.com/software/qgis), and the installation went fine, but there is no option to add an oracle spatial layer(not in the layer dropdown, or the sidebar buttons). I assume this has to do with gdal configuration, but I'm not sure how to fix that. I have the oracle instant client installed, and I can connect to oracle with sqlplus. Has anyone been able to get the new support for oracle to work on a Mac (Lion)?
> > > Thanks,
> > > Chris-
> > >
> > >
> > > PS - stackexchange link - http://gis.stackexchange.com/questions/74842/add-oracle-spatial-vector-layer-with-qgis-2-0-on-mac-osx
> > >
> > > _______________________________________________
> > > Qgis-user mailing list
> > > Qgis-user at lists.osgeo.org
> > > http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> > -----
> > William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
> > http://www.kyngchaos.com/
> >
> > Theory of the Universe
> >
> > There is a theory which states that if ever anyone discovers exactly what the universe is for and why it is here, it will instantly disappear and be replaced by something even more bizarrely inexplicable.  There is another theory which states that this has already happened.
> >
> > -Hitchhiker's Guide to the Galaxy 2nd season intro
> >
> >
> >
> > _______________________________________________
> > Qgis-user mailing list
> > Qgis-user at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> -----
> William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
> http://www.kyngchaos.com/
> 
> "I ache, therefore I am.  Or in my case - I am, therefore I ache."
> 
> - Marvin
> 
> 
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user

-----
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
http://www.kyngchaos.com/

"Oh, look, I seem to have fallen down a deep, dark hole.  Now what does that remind me of?  Ah, yes - life."

- Marvin