'make uninstall' - manual uninstall DBD::Oracle; fix perllocal.pod

A

Am Nym

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

Michael Vilain

Am Nym said:
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)?
 
X

xtdkmqc

Thanks for your help, pls see answer below:

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

Hans Mulder

Quoth (e-mail address removed):

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.

I have no experience with AIX, but I've done something similar on
Linux onec. If I remember correctly, libclntsh.so it the only .so
file you need, but you also need a number of data files. Without
the data files, you'll get a crypric error code (which means that
it can't find your character encoding), followed by another cryptic
error code (which means that it can't find the error messages either).

If AIX has something like strace or truss, you can use that to
find out which files it is trying to open, and copy those.
That is the only issue; you don't have 32bit Oracle client libs
installed on this machine.

Last time I looked, the Instant Client could be downloaded for free
from Oracle.com.

Hope this helps,

-- HansM
 
A

Am Nym

Ben Morrow said:
Quoth xtdkmqc-at-gmail-dot-com:

Oracle.o is irrelevant: it's created by the build process, but can be
deleted afterwards.

Sorry, I mis-read Oracle.so as Oracle.o!
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.


That is the only issue; you don't have 32bit Oracle client libs
installed on this machine.

thanks much Ben.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,733
Messages
2,569,440
Members
44,831
Latest member
HealthSmartketoReviews

Latest Threads

Top