[32428] in Perl-Users-Digest
Perl-Users Digest, Issue: 3695 Volume: 11
daemon@ATHENA.MIT.EDU (Perl-Users Digest)
Sun May 20 21:09:27 2012
Date: Sun, 20 May 2012 18:09:11 -0700 (PDT)
From: Perl-Users Digest <Perl-Users-Request@ruby.OCE.ORST.EDU>
To: Perl-Users@ruby.OCE.ORST.EDU (Perl-Users Digest)
Perl-Users Digest Sun, 20 May 2012 Volume: 11 Number: 3695
Today's topics:
'make uninstall' - manual uninstall DBD::Oracle; fix pe <xtdkmqc@gmail.com>
Re: 'make uninstall' - manual uninstall DBD::Oracle; fi <vilain@NOspamcop.net>
Re: 'make uninstall' - manual uninstall DBD::Oracle; fi <ben@morrow.me.uk>
Re: 'make uninstall' - manual uninstall DBD::Oracle; fi xtdkmqc@gmail.com
Re: 'make uninstall' - manual uninstall DBD::Oracle; fi <ben@morrow.me.uk>
Re: DBD::Oracle build on aix 6.1 ( host is a 64 bit db <ben@morrow.me.uk>
Re: First Commercial Perl Program <ben@morrow.me.uk>
Re: Objective C (OT) (Seymour J.)
Digest Administrivia (Last modified: 6 Apr 01) (Perl-Users-Digest Admin)
----------------------------------------------------------------------
Date: Sun, 20 May 2012 22:45:19 +0000
From: Am Nym <xtdkmqc@gmail.com>
Subject: 'make uninstall' - manual uninstall DBD::Oracle; fix perllocal.pod
Message-Id: <wro4nrao4jk.fsf@mpttdph.xen.prgmr.com>
To save a build, I tarred the *good* (pre-install) build area
for DBD-Oracle on one host, then untarred it on 'ourdbserver02',
and ran a 'make install' which ran cleanly; but the
module fails to work.
GOAL: uninstall DBD::Oracle safely/cleanly on 'ourdbserver02'.
What is wrong w/deleting the list of files given by
'make uninstall' ( and deleting resulting empty dirs )?
Additionally I would manually edit:
/usr/opt/perl5/lib/5.8.8/aix-thread-multi/perllocal.pod
Am I missing anything?
--
thanks/regards,
--
More detail; "Uninstall is unsafe and deprecated" warning:
--snip/find suggests what was installed last Friday:
# ourdbserver02 root # find /usr/opt/perl5 -ctime -1 -type f
/usr/opt/perl5/lib/5.8.8/aix-thread-multi/perllocal.pod
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/GetInfo.pm
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Object.pm
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Troubleshooting.pm
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle.pm
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/Oraperl.pm
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/.packlist
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.bs
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.h
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.so
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/dbdimp.h
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/mk.pm
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/ocitrace.h
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/oraperl.ph
/usr/opt/perl5/man/man3/DBD::Oracle.3
/usr/opt/perl5/man/man3/DBD::Oracle::GetInfo.3
/usr/opt/perl5/man/man3/DBD::Oracle::Object.3
/usr/opt/perl5/man/man3/DBD::Oracle::Troubleshooting.3
/usr/opt/perl5/man/man3/DBD::Oraperl.3
# 14:16:37 Fri 120518 0j 3 56426638 /usr/local/src/perl/alt/DBD-Oracle-1.44
# ourdbserver02 root # ( source setup-build-env ; make uninstall )
Uninstall is unsafe and deprecated, the uninstallation was not performed.
We will show what would have been done.
unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle.pm
unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/GetInfo.pm
unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Object.pm
unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Troubleshooting.pm
unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/Oraperl.pm
unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.bs
unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.h
unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.so
unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/dbdimp.h
unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/mk.pm
unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/ocitrace.h
unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/oraperl.ph
unlink /usr/opt/perl5/man/man3/DBD::Oracle.3
unlink /usr/opt/perl5/man/man3/DBD::Oracle::GetInfo.3
unlink /usr/opt/perl5/man/man3/DBD::Oracle::Object.3
unlink /usr/opt/perl5/man/man3/DBD::Oracle::Troubleshooting.3
unlink /usr/opt/perl5/man/man3/DBD::Oraperl.3
unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/.packlist
Uninstall is unsafe and deprecated, the uninstallation was not performed.
Please check the list above carefully, there may be errors.
Remove the appropriate files manually.
Sorry for the inconvenience.
# 14:18:23 Fri 120518 0j 3 56426638 /usr/local/src/perl/alt/DBD-Oracle-1.44
# ourdbserver02 root #
--
The host that contained the good build tree ( containing Makefile, the
module source etc ), had a 32 bit client installed. 'ourdbserver02'
just has the 64 bit server w/o any 32 bit client (lib32) directories.
--
log of the install:
# 13:54:18 Fri 120518 0j 3 56426638 /usr/local/src/perl/alt/DBD-Oracle-1.44
# ourdbserver02 root # ( source setup-build-env ; make install )
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.bs
Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.h
Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.so
Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/dbdimp.h
Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/mk.pm
Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/ocitrace.h
Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/Oraperl.pm
Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/oraperl.ph
Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle.pm
Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/GetInfo.pm
Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Object.pm
Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Troubleshooting.pm
Installing /usr/opt/perl5/man/man3/DBD::Oracle.3
Installing /usr/opt/perl5/man/man3/DBD::Oracle::GetInfo.3
Installing /usr/opt/perl5/man/man3/DBD::Oracle::Object.3
Installing /usr/opt/perl5/man/man3/DBD::Oracle::Troubleshooting.3
Installing /usr/opt/perl5/man/man3/DBD::Oraperl.3
Appending installation info to /usr/opt/perl5/lib/5.8.8/aix-thread-multi/perllocal.pod
--snip
# 18:32:46 Sun 120520 0j 0 38469768 ~
# ourdbserver02 txr6 $ tail -25 /usr/opt/perl5/lib/5.8.8/aix-thread-multi/perllocal.pod
=back
=head2 Fri May 18 13:55:02 2012: C<Module> L<DBD::Oracle|DBD::Oracle>
=over 4
=item *
C<installed into: /usr/opt/perl5/lib/site_perl/5.8.8>
=item *
C<LINKTYPE: dynamic>
=item *
C<VERSION: 1.44>
=item *
C<EXE_FILES: >
=back
# 18:32:59 Sun 120520 0j 0 38469768 ~
# ourdbserver02 txr6 $
------------------------------
Date: Sun, 20 May 2012 15:50:12 -0700
From: Michael Vilain <vilain@NOspamcop.net>
Subject: Re: 'make uninstall' - manual uninstall DBD::Oracle; fix perllocal.pod
Message-Id: <vilain-6AB45F.15501120052012@news.individual.net>
In article <wro4nrao4jk.fsf@mpttdph.xen.prgmr.com>,
Am Nym <xtdkmqc@gmail.com> wrote:
> To save a build, I tarred the *good* (pre-install) build area
> for DBD-Oracle on one host, then untarred it on 'ourdbserver02',
> and ran a 'make install' which ran cleanly; but the
> module fails to work.
>
> GOAL: uninstall DBD::Oracle safely/cleanly on 'ourdbserver02'.
>
> What is wrong w/deleting the list of files given by
> 'make uninstall' ( and deleting resulting empty dirs )?
>
> Additionally I would manually edit:
>
> /usr/opt/perl5/lib/5.8.8/aix-thread-multi/perllocal.pod
>
> Am I missing anything?
>
> --
> thanks/regards,
>
> --
> More detail; "Uninstall is unsafe and deprecated" warning:
>
> --snip/find suggests what was installed last Friday:
> # ourdbserver02 root # find /usr/opt/perl5 -ctime -1 -type f
> /usr/opt/perl5/lib/5.8.8/aix-thread-multi/perllocal.pod
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/GetInfo.pm
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Object.pm
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Troubleshooti
> ng.pm
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle.pm
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/Oraperl.pm
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/.packlis
> t
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.b
> s
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.h
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.s
> o
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/dbdimp.h
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/mk.pm
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/ocitrace
> .h
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/oraperl.ph
> /usr/opt/perl5/man/man3/DBD::Oracle.3
> /usr/opt/perl5/man/man3/DBD::Oracle::GetInfo.3
> /usr/opt/perl5/man/man3/DBD::Oracle::Object.3
> /usr/opt/perl5/man/man3/DBD::Oracle::Troubleshooting.3
> /usr/opt/perl5/man/man3/DBD::Oraperl.3
> # 14:16:37 Fri 120518 0j 3 56426638 /usr/local/src/perl/alt/DBD-Oracle-1.44
> # ourdbserver02 root # ( source setup-build-env ; make uninstall )
>
> Uninstall is unsafe and deprecated, the uninstallation was not performed.
> We will show what would have been done.
>
> unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle.pm
> unlink
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/GetInfo.pm
> unlink
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Object.pm
> unlink
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Troubleshooti
> ng.pm
> unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/Oraperl.pm
> unlink
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.b
> s
> unlink
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.h
> unlink
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.s
> o
> unlink
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/dbdimp.h
> unlink
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/mk.pm
> unlink
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/ocitrace
> .h
> unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/oraperl.ph
> unlink /usr/opt/perl5/man/man3/DBD::Oracle.3
> unlink /usr/opt/perl5/man/man3/DBD::Oracle::GetInfo.3
> unlink /usr/opt/perl5/man/man3/DBD::Oracle::Object.3
> unlink /usr/opt/perl5/man/man3/DBD::Oracle::Troubleshooting.3
> unlink /usr/opt/perl5/man/man3/DBD::Oraperl.3
> unlink
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/.packlis
> t
>
> Uninstall is unsafe and deprecated, the uninstallation was not performed.
> Please check the list above carefully, there may be errors.
> Remove the appropriate files manually.
> Sorry for the inconvenience.
>
> # 14:18:23 Fri 120518 0j 3 56426638 /usr/local/src/perl/alt/DBD-Oracle-1.44
> # ourdbserver02 root #
>
> --
> The host that contained the good build tree ( containing Makefile, the
> module source etc ), had a 32 bit client installed. 'ourdbserver02'
> just has the 64 bit server w/o any 32 bit client (lib32) directories.
>
> --
> log of the install:
>
> # 13:54:18 Fri 120518 0j 3 56426638 /usr/local/src/perl/alt/DBD-Oracle-1.44
> # ourdbserver02 root # ( source setup-build-env ; make install )
> Files found in blib/arch: installing files in blib/lib into architecture
> dependent library tree
> Installing
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.b
> s
> Installing
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.h
> Installing
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.s
> o
> Installing
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/dbdimp.h
> Installing
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/mk.pm
> Installing
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/ocitrace
> .h
> Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/Oraperl.pm
> Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/oraperl.ph
> Installing
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle.pm
> Installing
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/GetInfo.pm
> Installing
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Object.pm
> Installing
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Troubleshooti
> ng.pm
> Installing /usr/opt/perl5/man/man3/DBD::Oracle.3
> Installing /usr/opt/perl5/man/man3/DBD::Oracle::GetInfo.3
> Installing /usr/opt/perl5/man/man3/DBD::Oracle::Object.3
> Installing /usr/opt/perl5/man/man3/DBD::Oracle::Troubleshooting.3
> Installing /usr/opt/perl5/man/man3/DBD::Oraperl.3
> Appending installation info to
> /usr/opt/perl5/lib/5.8.8/aix-thread-multi/perllocal.pod
>
> --snip
> # 18:32:46 Sun 120520 0j 0 38469768 ~
> # ourdbserver02 txr6 $ tail -25
> /usr/opt/perl5/lib/5.8.8/aix-thread-multi/perllocal.pod
>
> =back
>
> =head2 Fri May 18 13:55:02 2012: C<Module> L<DBD::Oracle|DBD::Oracle>
>
> =over 4
>
> =item *
>
> C<installed into: /usr/opt/perl5/lib/site_perl/5.8.8>
>
> =item *
>
> C<LINKTYPE: dynamic>
>
> =item *
>
> C<VERSION: 1.44>
>
> =item *
>
> C<EXE_FILES: >
>
> =back
>
> # 18:32:59 Sun 120520 0j 0 38469768 ~
> # ourdbserver02 txr6 $
Define "Fails to work". Logs? Error messages? Test scripts? How does
it fail (can't connect, hangs, seg faults, tells you to sod off)?
--
DeeDee, don't press that button! DeeDee! NO! Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]
------------------------------
Date: Mon, 21 May 2012 00:38:40 +0100
From: Ben Morrow <ben@morrow.me.uk>
Subject: Re: 'make uninstall' - manual uninstall DBD::Oracle; fix perllocal.pod
Message-Id: <0tbo89-mqs.ln1@anubis.morrow.me.uk>
Quoth Am Nym <xtdkmqc@gmail.com>:
>
> To save a build, I tarred the *good* (pre-install) build area
> for DBD-Oracle on one host, then untarred it on 'ourdbserver02',
> and ran a 'make install' which ran cleanly; but the
> module fails to work.
You should at least have run 'make test' before 'make install'. What
were you trying to do?
> GOAL: uninstall DBD::Oracle safely/cleanly on 'ourdbserver02'.
>
> What is wrong w/deleting the list of files given by
> 'make uninstall' ( and deleting resulting empty dirs )?
>
> Additionally I would manually edit:
>
> /usr/opt/perl5/lib/5.8.8/aix-thread-multi/perllocal.pod
>
> Am I missing anything?
I don't think so.
> --
> The host that contained the good build tree ( containing Makefile, the
> module source etc ), had a 32 bit client installed. 'ourdbserver02'
> just has the 64 bit server w/o any 32 bit client (lib32) directories.
...well then that will be why it doesn't work. If you run 'ldd' (or
whatever the AIX equivalent is) on .../auto/DBD/Oracle/Oracle.so you
will see that it is dynamically linking libraries which aren't there.
You may, in fact, be able to make it work by copying across the relevant
libraries from the other machine, but it's probably better to start
again with a supported install of the client libs.
Ben
------------------------------
Date: Sun, 20 May 2012 17:00:25 -0700 (PDT)
From: xtdkmqc@gmail.com
Subject: Re: 'make uninstall' - manual uninstall DBD::Oracle; fix perllocal.pod
Message-Id: <c74df686-c734-4534-a1b7-8a68b5bf5dda@googlegroups.com>
Thanks for your help, pls see answer below:
On Sunday, May 20, 2012 5:50:12 PM UTC-5, Michael Vilain wrote:
> In article <wro4nrao4jk.fsf@mpttdph.xen.prgmr.com>,
> Am Nym <xtdkmqc -AT- gmail =dot= com> wrote:
>
> > To save a build, I tarred the *good* (pre-install) build area
> > for DBD-Oracle on one host, then untarred it on 'ourdbserver02',
> > and ran a 'make install' which ran cleanly; but the
> > module fails to work.
> >
> > GOAL: uninstall DBD::Oracle safely/cleanly on 'ourdbserver02'.
> >
> > What is wrong w/deleting the list of files given by
> > 'make uninstall' ( and deleting resulting empty dirs )?
> >
> > Additionally I would manually edit:
> >
> > /usr/opt/perl5/lib/5.8.8/aix-thread-multi/perllocal.pod
> >
> > Am I missing anything?
> >
> > --
> > thanks/regards,
> >
> > --
> > More detail; "Uninstall is unsafe and deprecated" warning:
> >
> > --snip/find suggests what was installed last Friday:
> > # ourdbserver02 root # find /usr/opt/perl5 -ctime -1 -type f
> > /usr/opt/perl5/lib/5.8.8/aix-thread-multi/perllocal.pod
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/GetInfo.pm
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Object.pm
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Troubleshooti
> > ng.pm
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle.pm
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/Oraperl.pm
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/.packlis
> > t
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.b
> > s
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.h
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.s
> > o
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/dbdimp.h
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/mk.pm
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/ocitrace
> > .h
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/oraperl.ph
> > /usr/opt/perl5/man/man3/DBD::Oracle.3
> > /usr/opt/perl5/man/man3/DBD::Oracle::GetInfo.3
> > /usr/opt/perl5/man/man3/DBD::Oracle::Object.3
> > /usr/opt/perl5/man/man3/DBD::Oracle::Troubleshooting.3
> > /usr/opt/perl5/man/man3/DBD::Oraperl.3
> > # 14:16:37 Fri 120518 0j 3 56426638 /usr/local/src/perl/alt/DBD-Oracle-1.44
> > # ourdbserver02 root # ( source setup-build-env ; make uninstall )
> >
> > Uninstall is unsafe and deprecated, the uninstallation was not performed.
> > We will show what would have been done.
> >
> > unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle.pm
> > unlink
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/GetInfo.pm
> > unlink
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Object.pm
> > unlink
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Troubleshooti
> > ng.pm
> > unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/Oraperl.pm
> > unlink
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.b
> > s
> > unlink
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.h
> > unlink
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.s
> > o
> > unlink
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/dbdimp.h
> > unlink
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/mk.pm
> > unlink
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/ocitrace
> > .h
> > unlink /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/oraperl.ph
> > unlink /usr/opt/perl5/man/man3/DBD::Oracle.3
> > unlink /usr/opt/perl5/man/man3/DBD::Oracle::GetInfo.3
> > unlink /usr/opt/perl5/man/man3/DBD::Oracle::Object.3
> > unlink /usr/opt/perl5/man/man3/DBD::Oracle::Troubleshooting.3
> > unlink /usr/opt/perl5/man/man3/DBD::Oraperl.3
> > unlink
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/.packlis
> > t
> >
> > Uninstall is unsafe and deprecated, the uninstallation was not performed.
> > Please check the list above carefully, there may be errors.
> > Remove the appropriate files manually.
> > Sorry for the inconvenience.
> >
> > # 14:18:23 Fri 120518 0j 3 56426638 /usr/local/src/perl/alt/DBD-Oracle-1.44
> > # ourdbserver02 root #
> >
> > --
> > The host that contained the good build tree ( containing Makefile, the
> > module source etc ), had a 32 bit client installed. 'ourdbserver02'
> > just has the 64 bit server w/o any 32 bit client (lib32) directories.
> >
> > --
> > log of the install:
> >
> > # 13:54:18 Fri 120518 0j 3 56426638 /usr/local/src/perl/alt/DBD-Oracle-1.44
> > # ourdbserver02 root # ( source setup-build-env ; make install )
> > Files found in blib/arch: installing files in blib/lib into architecture
> > dependent library tree
> > Installing
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.b
> > s
> > Installing
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.h
> > Installing
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.s
> > o
> > Installing
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/dbdimp.h
> > Installing
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/mk.pm
> > Installing
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/ocitrace
> > .h
> > Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/Oraperl.pm
> > Installing /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/oraperl.ph
> > Installing
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle.pm
> > Installing
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/GetInfo.pm
> > Installing
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Object.pm
> > Installing
> > /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/DBD/Oracle/Troubleshooti
> > ng.pm
> > Installing /usr/opt/perl5/man/man3/DBD::Oracle.3
> > Installing /usr/opt/perl5/man/man3/DBD::Oracle::GetInfo.3
> > Installing /usr/opt/perl5/man/man3/DBD::Oracle::Object.3
> > Installing /usr/opt/perl5/man/man3/DBD::Oracle::Troubleshooting.3
> > Installing /usr/opt/perl5/man/man3/DBD::Oraperl.3
> > Appending installation info to
> > /usr/opt/perl5/lib/5.8.8/aix-thread-multi/perllocal.pod
> >
> > --snip
> > # 18:32:46 Sun 120520 0j 0 38469768 ~
> > # ourdbserver02 txr6 $ tail -25
> > /usr/opt/perl5/lib/5.8.8/aix-thread-multi/perllocal.pod
> >
> > =back
> >
> > =head2 Fri May 18 13:55:02 2012: C<Module> L<DBD::Oracle|DBD::Oracle>
> >
> > =over 4
> >
> > =item *
> >
> > C<installed into: /usr/opt/perl5/lib/site_perl/5.8.8>
> >
> > =item *
> >
> > C<LINKTYPE: dynamic>
> >
> > =item *
> >
> > C<VERSION: 1.44>
> >
> > =item *
> >
> > C<EXE_FILES: >
> >
> > =back
> >
> > # 18:32:59 Sun 120520 0j 0 38469768 ~
> > # ourdbserver02 txr6 $
>
> Define "Fails to work". Logs? Error messages? Test scripts? How does
> it fail (can't connect, hangs, seg faults, tells you to sod off)?
A coworker run the below test:
/home/users/jdoe> chk_db_connection.pl
install_driver(Oracle) failed: Can't load '/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: Could not load module /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.so.
Dependent module libclntsh.so could not be loaded.
Could not load module libclntsh.so.
System error: No such file or directory
Could not load module /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.so.
Dependent module /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.so could not be loaded. at /usr/opt/perl5/lib/5.8.8/aix-thread-multi/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at chk_db_connection.pl line 5
Oracle.o is in the good build tree:
# ourdbserver02 txr6 $ cd /usr/local/src/perl/alt/DBD-Oracle-1.44
# 19:46:43 Sun 120520 0j 1 39977124 /usr/local/src/perl/alt/DBD-Oracle-1.44
# ourdbserver02 txr6 $ ls -l *.o
-rw-r--r-- 1 root system 96867 May 10 09:46 Oracle.o
-rw-r--r-- 1 root system 150267 May 10 09:46 dbdimp.o
-rw-r--r-- 1 root system 147053 May 10 09:46 oci8.o
--
On the host where the build, the 'make test', the install, and the real world
use of DBD::Oracle all worked, Oracle.o is also *not* in:
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle
Take a look:
# 19:48:36 Sun 120520 0j 3 7536878 /usr/local/src/perl/DBD-Oracle-1.44
# ourappserver02 txr6 $ find /usr/opt/perl5 -name Oracle.o
/usr/opt/perl5/build/DBD-Oracle-1.44/Oracle.o
--snip
# 19:55:08 Sun 120520 0j 1 39977124 ~
# ourdbserver02 txr6 $ find /usr/opt/perl5 -name Oracle.o
# 19:55:13 Sun 120520 0j 1 39977124 ~
# ourdbserver02 txr6 $
So, at the very least ourdbserver02 is missing Oracle.o. I suppose I could
manually copy it in, but what else might be missing?
In addition, there is the 'libclntsh.so' issue..
###
Keep in mind, I what to learn how to do the uninstall, that is my goal.
------------------------------
Date: Mon, 21 May 2012 01:41:57 +0100
From: Ben Morrow <ben@morrow.me.uk>
Subject: Re: 'make uninstall' - manual uninstall DBD::Oracle; fix perllocal.pod
Message-Id: <ljfo89-r9t.ln1@anubis.morrow.me.uk>
Quoth xtdkmqc@gmail.com:
>
> /home/users/jdoe> chk_db_connection.pl
> install_driver(Oracle) failed: Can't load
> '/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.so'
> for module DBD::Oracle: Could not load module
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.so.
> Dependent module libclntsh.so could not be loaded.
> Could not load module libclntsh.so.
> System error: No such file or directory
> Could not load module
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.so.
> Dependent module
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/Oracle/Oracle.so
> could not be loaded. at
> /usr/opt/perl5/lib/5.8.8/aix-thread-multi/DynaLoader.pm line 230.
> at (eval 3) line 3
> Compilation failed in require at (eval 3) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at chk_db_connection.pl line 5
>
> Oracle.o is in the good build tree:
Oracle.o is irrelevant: it's created by the build process, but can be
deleted afterwards. The messages above refer to Oracle.so, which is
installed; they are telling you Oracle.so can't be loaded because
libclntsh.so is missing, which is presumably one of the Oracle client
libaries.
> In addition, there is the 'libclntsh.so' issue..
That is the only issue; you don't have 32bit Oracle client libs
installed on this machine.
Ben
------------------------------
Date: Sun, 20 May 2012 23:09:06 +0100
From: Ben Morrow <ben@morrow.me.uk>
Subject: Re: DBD::Oracle build on aix 6.1 ( host is a 64 bit db server )
Message-Id: <2l6o89-m2s.ln1@anubis.morrow.me.uk>
Quoth Am Nym <xtdkmqc@gmail.com>:
> Ben Morrow <ben@morrow.me.uk> writes:
> > Quoth xtdkmqc@gmail.com:
> >>
> >> $ perl -V
> >> Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
> >
> > (That's pretty old; both 5.8 and 5.10 are unsupported by the perl
> > developers at this point. You should seriously consider upgrading.)
>
> We need to plan for that.
Yes, of course.
> > but tbh it's probably easier just to install the Instant Client.
> (Unless that's
> > something you have to pay for separately?)
>
> I'm not sure. Last Friday we were thinking we would install the
> "normal" 32 bit client, that we install on other AIX hosts. Will ask
> at work about the Instant Client.
If you have a procedure for installing 32bit client libs that you know
works, that may be better than installing something you don't have
experience with. In particular, if you have successfully installed
DBD::Oracle on other machines, it's probably best to do it the same way
on this machine, and just ignore the server installation. You may need
to make sure ORACLE_HOME and/or other Oracle environment variables are
set correctly when you run Perl programs: I don't know if they are used
at runtime as well as at compile time.
Ben
------------------------------
Date: Mon, 21 May 2012 00:16:00 +0100
From: Ben Morrow <ben@morrow.me.uk>
Subject: Re: First Commercial Perl Program
Message-Id: <giao89-ils.ln1@anubis.morrow.me.uk>
Quoth "tbb!/fbr!" <ronaldljohnson@gmail.com>:
> On Thursday, May 17, 2012 12:00:15 AM UTC-7, Tim Watts wrote:
> > tbb!/fbr! wrote:
> > >
> > > It was mentioned to me that there is a couple of ways to do this. Can I
> > > get some input/help on making this piece of code a little more
> > > streamlined.
> >
<snip>
> > If either of those datasets only have one record for each unique
> > SYMBOL, it woudl be a good candidate for preloading into a hash and
> > only looping on the other dataset. If both files have multiple
> > unique SYMBOLS you could still do this, but it would be a hash of
> > arrays, so a little bit fiddlier.
>
> As I mentioned to Ben, it works 100% as is. I was just looking for a
> better way to write it. It seems to me there must be some better way
> than reading all of @lines2 for each line in @lines1. And yes, SYMBOL is
> unique.
In that case, as Tim says, you want to load the smaller file into a
hash. Assuming $file1 is the smaller:
# All these variable need better names. I can't do that for you
# since I don't know what the files contain. Perhaps file1 should
# be 'excess' and file2 'yield'?
my @fields1 = qw/ symbol company excess /;
my @fields2 = qw/
date symbol company
# as before...
/;
my @out = qw/
cap open low high ...
/;
my %file1 = do {
open my $FILE1, "<", $file1 or die ...;
map {
my %line1;
@line1{@fields1} = split /\t/, 3;
($line1{symbol} => \%line1);
} <$FILE1>;
};
open my $FILE2, "<", $file2 or die ...;
while (<$FILE2>) {
my %line2;
@line2{@fields2} = split /\t/;
if (my $line1 = $file1{$line2{symbol}}) {
my $out = join "\t",
$line2{symbol}, $line2{company},
@$line1{@out}, $line2{excess};
print $out;
print FILEOUT $out;
}
}
The basic idea here is that you run over the lines of file1 once, and
build a hash. Then you run over the lines of file2, and look up the
appropriate line directly rather than having to search the whole file
every time.
Ben
------------------------------
Date: Sat, 19 May 2012 22:45:01 -0400
From: Shmuel (Seymour J.) Metz <spamtrap@library.lspace.org.invalid>
Subject: Re: Objective C (OT)
Message-Id: <4fb85aad$23$fuzhry+tra$mr2ice@news.patriot.net>
In <slrnjrd2vm.jql.hjp-usenet2@hrunkner.hjp.at>, on 05/18/2012
at 07:50 PM, "Peter J. Holzer" <hjp-usenet2@hjp.at> said:
>I do think that C is just low-level enough that by comparing the
>C source code and the generated machine code you can get a
>"feeling" for common high-level language constructs are
>translated into machine code.
That will only give you a feel for how a particular compiler
translates C constructs into machine code. It won't give you a feel
for, e.g., the architecture, translations of constructs in other
languages, instructions generated only from assembler code.
>As an introductory language, "Processing"[1] might be a good choice.
Probably kinder than what they did to us, which was to teach us
machine language before introducing the concept of an assembler :-(
--
Shmuel (Seymour J.) Metz, SysProg and JOAT <http://patriot.net/~shmuel>
Unsolicited bulk E-mail subject to legal action. I reserve the
right to publicly post or ridicule any abusive E-mail. Reply to
domain Patriot dot net user shmuel+news to contact me. Do not
reply to spamtrap@library.lspace.org
------------------------------
Date: 6 Apr 2001 21:33:47 GMT (Last modified)
From: Perl-Users-Request@ruby.oce.orst.edu (Perl-Users-Digest Admin)
Subject: Digest Administrivia (Last modified: 6 Apr 01)
Message-Id: <null>
Administrivia:
To submit articles to comp.lang.perl.announce, send your article to
clpa@perl.com.
Back issues are available via anonymous ftp from
ftp://cil-www.oce.orst.edu/pub/perl/old-digests.
#For other requests pertaining to the digest, send mail to
#perl-users-request@ruby.oce.orst.edu. Do not waste your time or mine
#sending perl questions to the -request address, I don't have time to
#answer them even if I did know the answer.
------------------------------
End of Perl-Users Digest V11 Issue 3695
***************************************
