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/
