Re: DBD::Oracle 1.72 fail

On 05/19/2014 01:48 PM, H.Merijn Brand wrote:
> On Thu, 17 Apr 2014 23:49:24 -0700, Christopher Jones
> <[email protected]> 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.

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
>
>
>

-- 
[email protected]  http://twitter.com/ghrd
Free PHP & Oracle book:
http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html