Re: DBD::Oracle 1.72 fail
"H.Merijn Brand" <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase.devel |
|---|---|
| Message-ID | <[email protected]> |
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 :) 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 > Chris > > On 4/17/14, 11:41 PM, H.Merijn Brand wrote: > > On Thu, 17 Apr 2014 15:55:27 -0700, Christopher Jones > > <[email protected]> wrote: > > > >> > >> [I thought I'd replied this morning, but can't see it in my outbox] > >> > >> On 04/16/2014 08:42 AM, H.Merijn Brand wrote: > >>> On Wed, 16 Apr 2014 08:18:10 -0700, Christopher Jones > >>> <[email protected]> wrote: > >>> > >>>> Hi, > >>>> > >>>> An enhancement request for including tnsping already exists in the > >>>> Oracle bug database. If you can give me a description of how you use > >>>> tnsping, I will add it to the enhancement request. Having the actual > >>>> words of a customer always helps prioritization and design. > >>> > >>> $ tnsping $TWO_TASK > >> > >> To be sure I understand: > >> - Do you run tnsping just once during installation? > >> Or is it part of some run-time processing? > > > > Always from the command line > > Incidentally > > Never automated > > > > I run it after setup to check if the setup is working at all. > > First I try tnsping, then I try sqlplus, and then I build DBD::Oracle > > and try perl. Quite often that process is repeated on failure > > > > I also use tnsping when I have access problems later on, just to see if > > the remote database is still accessible > > > >> - What action(s) do you take after running tnsping? > > > > Of course that depends on what tnspings shows. When it shows a fail, I > > call the customer that their database is not accessible and that it is > > not our application's fault. Or when using locally, I dig to find the > > connection problem. > > > > The big advantage of tnsping over sqlplus and applications is that it > > tests the connection without the need of user authentication. This > > will show problems like that the database is accessible but the > > password did expire or other authentication is impossible. > > > >> - Could you use 'sqlplus -l' in some cases, or are user credentials not known? > > > > Sometimes they are not known or they have expired. > > Mostly they are known. > > > > I see the advantage of tnsping in that it only tests $TWO_TASK > > accessibility > > > >>>> One discussion point we have internally is about packaging. In > >>>> particular whether to have fewer packages each containing more > >>>> components, or whether to keep each package more self contained. I'd > >>>> be interested in your thoughts on this. Should tnsping be in the > >>>> 'tools' package? > >>> > >>> I personally would like to see a TWO client packages. One that > >>> includes the possibility to build against it (minimal sdk so I can > >>> build DBD::Oracle), and one without that, which can be installed at > >>> the customer site (they can install their own) > >>> > >>> In my perception, I would prefer a single .tar.gz that includes all > >>> files in their proper location. (including a > >>> network/admin/tnsnames.ora.example) > >> > >> I'll bring this up when we next have packaging discussions. The > >> developer vs. production split is appealing. Thanks for the input. > > > > Welcome, and thanks for listening > > > >> Do you use the "Easy Connect" connect string format at all? Or do you > >> need the more complex settings of a tnsnames entry? > >> http://docs.oracle.com/cd/E16655_01/network.121/e17610/gettingstart.htm#NETAG172 > > > > For tnsping, I only use $ORACLE_HOME, $LD_LIBRARY_PATH and $TWO_TASK. -- 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/