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/

Reply via email to