[fdo-internals] RE: Oracle 10.2.0.3 Linux instant client

[Greg Boone]

I say we move the KingOracle provider to use the Oracle 11 client on Linux. I know it is not optimal, but I think the risks are fairly minimal.  We may wish to do the same for Windows, but I think that is less of an issue.

Greg

From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Trevor Wekel
Sent: Tuesday, March 09, 2010 11:54 AM
To: FDO Internals Mail List
Subject: [fdo-internals] RE: Oracle 10.2.0.3 Linux instant client

Hi Greg,

-lnnz10 is also a problem.  Oracle renamed this library to libnnz11.so for Oracle 11.  The additional -L and -I directives can coexist but we can only pick one version of  libnnz.

On the plus side, compilation against the Oracle 11 instant client worked without a hitch and the c++ libraries are consistent.  I have not tested the provider yet since I do not have an Oracle database set up.

Upgrading the Oracle client library after RC1 is probably a bit naughty from a "release" standpoint.  However, mixing c++ libraries seems like an accident waiting to happen.

Please note:  This dual c++ library problem should also manifest itself with other shared libraries build against the 10.2 client on CentOS/RedHat 5.


What should we do?


Regards,
Trevor

From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Greg Boone
Sent: March 9, 2010 9:34 AM
To: FDO Internals Mail List
Subject: [fdo-internals] RE: Oracle 10.2.0.3 Linux instant client

Yes... The Makefile changes are all I anticipate.

From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Trevor Wekel
Sent: Tuesday, March 09, 2010 11:21 AM
To: FDO Internals Mail List
Subject: [fdo-internals] RE: Oracle 10.2.0.3 Linux instant client

Ok.  No problem.  I assume we only need to make two small changes to -L and -I directives in KingOracle/src/Makefile.am and KingOracle/src/Provider/Makefile.am?

I will try it out.

Thanks Greg,
Trevor

From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Greg Boone
Sent: March 9, 2010 9:08 AM
To: FDO Internals Mail List
Subject: [fdo-internals] RE: Oracle 10.2.0.3 Linux instant client

We can change the compiler settings to first look for oracle 11 and then oracle 10. It is not a big change.

From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Trevor Wekel
Sent: Tuesday, March 09, 2010 9:48 AM
To: FDO Internals Mail List
Subject: [fdo-internals] Oracle 10.2.0.3 Linux instant client

Hi everyone,

I have been doing some .so dependency checking on Linux and have noticed that the Oracle 10.2.0.3 instant client used to compile the King.Oracle Provider contains shared lib references to libstdc++.so.5.  This is the c++ library for GCC 3.4.  However, we compile Fdo under GCC 4.1 so we end up referencing both libstdc++.so.5 and libstdc++.so.6.

>From a previous discussion, mixing headers from different C++ libs is problematic.  Will this mix of c++ libraries cause problematic behaviour (memory leaks, etc) with the King.Oracle Provider?  If so, do we need to upgrade the Oracle instant client?  I downloaded the 11.2 instant client and it correctly links to libstdc++.so.6.  I do not know if King.Oracle will compile against it though.

Please note, this would not a problem when compiling under CentOS/Redhat 4 since the default compiler was gcc/g++ 3.4.

Regards,
Trevor


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-internals/attachments/20100309/6adec87d/attachment.html