On Wed, 21 May 2014 17:28:53 -0700, Christopher Jones <christopher.jo...@oracle.com> wrote:
> > > On 05/19/2014 01:48 PM, H.Merijn Brand wrote: > > On Thu, 17 Apr 2014 23:49:24 -0700, Christopher Jones > > <christopher.jo...@oracle.com> wrote: > > > >> > >> I appreciate the wealth of information. > >> It really does help when we have to prioritize project and features. > > > > FEEDBACK! > > > > I have perl-5.18.2-ia64 running with 12c client in a 10g environment :) > > It sounds like you have a client using 12c libraries from a mixed environment > directory! > I'd have to ask "why?". I couldn't recommend doing it. Neither would I, BUT … perl-5.14.2 and newer with OpenSSL-1.0.0 or newer and DBD::Oracle does not work for quite a few of our applications when linking DBD::Oracle to the 10g client that is available in the 10g database environment. The client is not (yet) willing to move on to 11g or 12c, so the 10g is there to stay. Being a perl-hacker one tries to find a way to make it work :) The whole thing worked fine (same OS, same perl, same version of DBI and DBD::Oracle and the same version of OpenSSL) under a 12c install environment, so the obvious solution is to try to get DBD::Oracle linked against 12c client libraries working in the 10g environment to make the client, and thus us, happy. > Chris > > > 1. Install 12c-client for HP-UX itanium > > 2. Build DBD::Oracle against that and install > > > > 3. Move to the 10g environment > > 4. Get these files from 12c into the 10g tree: none of them overwrites > > an other file! > > > > lib/libclntsh.so.12.1 > > lib/libnnz12.so > > lib/libclntshcore.so.12.1 > > oracore/zoneinfo/timezdif.csv > > oracore/zoneinfo/timezlrg_1.dat > > oracore/zoneinfo/timezlrg_10.dat > > oracore/zoneinfo/timezlrg_11.dat > > oracore/zoneinfo/timezlrg_12.dat > > oracore/zoneinfo/timezlrg_13.dat > > oracore/zoneinfo/timezlrg_14.dat > > oracore/zoneinfo/timezlrg_15.dat > > oracore/zoneinfo/timezlrg_16.dat > > oracore/zoneinfo/timezlrg_17.dat > > oracore/zoneinfo/timezlrg_18.dat > > oracore/zoneinfo/timezlrg_2.dat > > oracore/zoneinfo/timezlrg_3.dat > > oracore/zoneinfo/timezlrg_4.dat > > oracore/zoneinfo/timezlrg_5.dat > > oracore/zoneinfo/timezlrg_6.dat > > oracore/zoneinfo/timezlrg_7.dat > > oracore/zoneinfo/timezlrg_8.dat > > oracore/zoneinfo/timezlrg_9.dat > > oracore/zoneinfo/timezone_1.dat > > oracore/zoneinfo/timezone_10.dat > > oracore/zoneinfo/timezone_11.dat > > oracore/zoneinfo/timezone_12.dat > > oracore/zoneinfo/timezone_13.dat > > oracore/zoneinfo/timezone_14.dat > > oracore/zoneinfo/timezone_15.dat > > oracore/zoneinfo/timezone_16.dat > > oracore/zoneinfo/timezone_17.dat > > oracore/zoneinfo/timezone_18.dat > > oracore/zoneinfo/timezone_2.dat > > oracore/zoneinfo/timezone_3.dat > > oracore/zoneinfo/timezone_4.dat > > oracore/zoneinfo/timezone_5.dat > > oracore/zoneinfo/timezone_6.dat > > oracore/zoneinfo/timezone_7.dat > > oracore/zoneinfo/timezone_8.dat > > oracore/zoneinfo/timezone_9.dat > > > > > > HP-UX 11.31/64 U rx2660/64 Itanium 2 9100/1710(2) ia64 4075 Mb > > > > This is perl 5, version 14, subversion 2 (v5.14.2) built for > > IA64.ARCHREV_0-LP64-ld > > > > DBI-1.631 > > DBD::Oracle-1.74 > > > > SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 19 22:45:19 2014 > > > > Copyright (c) 1982, 2005, Oracle. All rights reserved. > > > > > > Connected to: > > Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production > > With the Partitioning, OLAP and Data Mining options > > > > $ llldd > > /pro/asql/o83R/lib/perl/5.14.2/IA64.ARCHREV_0-LP64-ld/auto/DBD/Oracle/Oracle.so > > > > Lib Real path > > Size Date Refs > > ------------------------------------ ------------------------------------ > > --------- ------------------- ---- > > /pro/asql/o83R/lib/perl/5.14.2/IA64. /pro/asql/o83R/lib/perl/5.14.2/IA64. > > 668072 2014-05-19 18:39:46 25 > > /pro/oracle/v102/lib/libclntsh.so.12 /pro/oracle/v102/lib/libclntsh.so.12 > > 117402552 2014-05-19 18:33:03 21 > > /pro/oracle/v102/lib/libnnz12.so /pro/oracle/v102/lib/libnnz12.so > > 16442824 2013-12-05 09:29:34 12 > > /pro/oracle/v102/lib/libclntshcore.s /pro/oracle/v102/lib/libclntshcore.s > > 14541616 2014-05-19 18:33:03 11 > > /usr/lib/hpux64/librt.so.1 /usr/lib/hpux64/librt.so.1 > > 85568 2007-02-15 22:36:36 1 > > /usr/lib/hpux64/libdl.so.1 /usr/lib/hpux64/libdl.so.1 > > 78704 2012-07-20 08:34:04 0 > > /usr/lib/hpux64/libm.so.1 /usr/lib/hpux64/libm.so.1 > > 6481912 2011-05-18 22:53:12 0 > > /usr/lib/hpux64/libpthread.so.1 /usr/lib/hpux64/libpthread.so.1 > > 1613024 2011-08-10 22:04:54 0 > > /usr/lib/hpux64/libnsl.so.1 /usr/lib/hpux64/libnsl.so.1 > > 1511400 2010-07-30 16:06:08 3 > > /usr/lib/hpux64/libc.so.1 /usr/lib/hpux64/libc.so.1 > > 4900360 2012-08-27 09:33:45 1 > > /usr/lib/hpux64/libxti.so.1 /usr/lib/hpux64/libxti.so.1 > > 298552 2011-02-22 16:00:36 0 > > /usr/lib/hpux64/libunwind.so.1 /usr/lib/hpux64/libunwind.so.1 > > 714608 2010-12-06 22:57:42 1 > > /usr/lib/hpux64/libuca.so.1 /usr/lib/hpux64/libuca.so.1 > > 85680 2007-02-15 22:36:36 0 > > /usr/lib/hpux64/libdiskown.so /usr/lib/hpux64/libdiskown.so.1 > > 95736 2013-04-01 10:43:49 0 > > /pro/oracle/v102/lib/libons.so /pro/oracle/v102/lib/libons10.so > > 218944 2005-06-27 10:04:00 5 > > > > In the end, all products work with both the libons.so from 10g as well > > as with libons.so from 12c -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ using perl5.00307 .. 5.19 porting perl5 on HP-UX, AIX, and openSUSE http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/ http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/