Thunder - one of my team members had access to another Oracle instance that
WAS in the tnsnames.ora file on my box. We ran the 'test_connect_pgm' and
got the SAME ERROR as the *.t test modules experienced during the 'make
test' runs. The test_connect_pgm" does a [$dbh =
DBI->connect("DBI:Oracle:$sid", "userid", "password")
|| die "Couldn't connect to database $sid: ";]. Here is the error
text:
****************************************************************************
****
Failed to load Oracle extension and/or shared libraries:
install_driver(Oracle) failed: Can't load
'/home/nbdipy2/perllib/site/site_perl/auto/DBD/Oracle/Oracle.so' for module
DBD::Oracle: dlopen: Cannot
map library libclntsh.so.9.0 at
/usr/lib/perl-5.6.0/lib/5.6.0/alpha-dec_osf/DynaLoader.pm line 200.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
****************************************************************************
****
/home/nbdipy2/perllib/lib/site_perl/5.6.0/alpha-dec_osf/auto/DBD/Oracle/Orac
le.so DOES exist.
I am not sure what the LIBCLNTSH option did on my 'perl Makefile.pl'
statement. The READNE.help file says to "let him know if it helps".
Tim - any hints as to what to do from here? Is there anything I can provide
further? I have attached a copy of my 'perl -V' output.
Please let me know, and thanks.
-----Original Message-----
From: Rose, Bill
Sent: Tuesday, November 05, 2002 3:05 PM
To: Lee, William
Cc: 'PARLEY,JON (HP-MountainView,ex1)'
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
William - my most recent 'make', 'test', and 'install' seems to have passed
the testing and installation successfully.
Thunder - it was the perl Makefile.PL -n LIBCLNTSH that did it.
William - here is my 'connect_test_pgm' output:
Attempting to connect to database PIIDEV.
DBI->connect(PIIDEV) failed: ORA-12154: TNS:could not resolve service name
(DBD ERROR: OCIServerAttach) at test_dbi_connect.pl line 17
Couldn't connect to database PIIDEV: ORA-12154: TNS:could not resolve
service name (DBD ERROR: OCIServerAttach) at test_dbi_connect.pl line 17.
Here is some UNIX output for that error...
DRVACTDMT/home/nbdipy2>> oerr ora 12154
12154, 00000, "TNS:could not resolve service name"
// *Cause: The service name specified is not defined correctly in the
// TNSNAMES.ORA file.
// *Action: Make the following checks and correct the error:
// - Verify that a TNSNAMES.ORA file exists and is in the proper
// place and accessible. See the operating system specific
manual
// for details on the required name and location.
// - Check to see that the service name exists in one of the
// TNSNAMES.ORA files and add it if necessary.
// - Make sure there are no syntax errors anywhere in the file.
// Particularly look for unmatched parentheses or stray
characters.
// Any error in a TNSNAMES.ORA file makes it unusable. See
// Chapter 4 in the SQL*Net V2 Administrator's Guide. If
// possible, regenerate the configuration files using the Oracle
// Network Manager.
DRVACTDMT/home/nbdipy2>> find / -name tnsnames.ora -print 2>/dev/null
/st0501/app/oracle/product/8.1.7/network/admin/samples/tnsnames.ora
/st0501/app/oracle/product/8.1.7/network/admin/tnsnames.ora
/st0501/app/oracle/product/8.1.7/hs/admin/tnsnames.ora
/st0501/app/oracle/product/9.0.1/network/admin/samples/tnsnames.ora
/st0501/app/oracle/product/9.0.1/network/admin/tnsnames.ora
/st0501/app/oracle/product/old_8.1.6/network/admin/samples/tnsnames.ora
/st0501/app/oracle/product/old_8.1.6/network/admin/tnsnames.ora
/st0514/app/oracle/product/8.1.7/network/admin/samples/tnsnames.ora
/st0514/app/oracle/product/8.1.7/network/admin/tnsnames.ora
/st0514/app/oracle/product/8.1.7/hs/admin/tnsnames.ora
/st0514/app/oracle/product/8.1.6/network/admin/samples/tnsnames.ora
/st0514/app/oracle/product/8.1.6/network/admin/tnsnames.ora
What do I do to fix this? I am so excited that things could work,... I
can't even think straight. Let me know.
-----Original Message-----
From: PARLEY,JON (HP-MountainView,ex1) [mailto:jon_parley@;hp.com]
Sent: Tuesday, November 05, 2002 2:20 PM
To: Rose, Bill
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
Hi again Bill,
I'm in Pacific Time Zone (West Coast). I went back and reexamined your 'perl
-V'... [This is from README]
Try each of these in turn (follow each with a make && make test):
perl Makefile.PL -nob
perl Makefile.PL -c
perl Makefile.PL -l
perl Makefile.PL -n LIBCLNTSH
let me know if any of these help.
----------------------------------------------------------------------------
---
Some runtime problems might be related to perl's malloc. (You are not using
this! My working install is.)
This is a long shot. If all else fails and perl -V:usemymalloc says
usemymalloc='y' then try rebuilding perl using Configure -Uusemymalloc.
If this does fix it for you then please let me know.
Let me know if any progress,
--Thunder
-----Original Message-----
From: Rose, Bill [mailto:Bill.Rose@;bankofamerica.com]
Sent: Monday, November 04, 2002 8:50 PM
To: 'PARLEY,JON (HP-MountainView,ex1)'
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
Thunder -
1) I want to install the binaries under my 'PERL5LIB'. Since I am not a Sys
Admin, I have to install the binaries that I create - in a private folder.
That's where my DBI build went. PERL5LIB gets set in my .profile, and then
I use the parm 'PREFIX=/home/nbdipy2/perllib' on the 'perl Makefile.PL'
statement, to tell the 'make' where to install the binary, as I understand
it.
2) My answer in #1 should cover this.
3) -- -- --
4) The 5.6.0 perl came with my machine as part of the std build. I
installed 5.8.0 perl in my own private libs,... built DBI & DBD, and came up
with the SAME error. So, I deleted the 5.8.0, and went back to the std
build, since it didn't make any difference (encountered the same error).
I came from an area (prior job) that used HP/UX 11.0 and, after trial and
error, we found that we had to do a static build, and it worked after that.
This Compaq Tru64 machine is different, and a tough nut to crack.
I did notice that there was an issue regarding Oracle 9i using 64 bit
library modules (your last note mentions 32-bit libs), but I thought I would
wait to address until I started using DBI with Oracle and see if I got any
errors re: 'wrong ELF clss'. I might want to try compiling & linking with
the 32-bit libs in the paths at THIS point. Take a look at this link...
http://xmlproj.com/fom-serve/cache/122.html
Getting tired. Talk to you tomorrow. What timezone are you in, and would it
be beneficial to call you tomorrow?
Thanks, Thunder.
-----Original Message-----
From: PARLEY,JON (HP-MountainView,ex1) [mailto:jon_parley@;hp.com]
Sent: Monday, November 04, 2002 9:07 PM
To: Rose, Bill
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
Hi Bill,
Interesting...
1. Verify that /usr/lib/perl-5.6.0/lib/5.6.0/alpha-dec_osf/ is the perl for
which you want to install DBD. (I assume DBI installed ok).
2. Longshot... try unsetting this variable
PERL5LIB="/home/nbdipy2/perllib/lib/site_perl" (Is this where things should
not be located)? I do not have this variable in any of my DBD envs.
3. Let me know what you come up with. I'm going to do another fresh DBI/DBD
install tommorrow on a nonDBI machine and see if I can't try to replicate
your issues.
*4. Were the link variables set BEFORE you built perl 5.6.0 (I suggest 5.6.1
anyways)?
EXAMPLE (Bill, yours are surely different, but notice how SHLIB_PATH uses
..../lib32 instead of lib [may not be relevant on your machine]):
## Environment variables to check beforehand
LD_LIBRARY_PATH=/u01/app/oracle/product/9.0.1/lib:/usr/lib/pa20_64:/usr/lib/
Motif1.2:/u01/app/oracle/product/9.0.1/jdbc/lib:/usr/lib
SHLIB_PATH=/u01/app/oracle/product/9.0.1/lib32:/usr/lib/pa20_64:/usr/lib/Mot
if1.2:/u01/app/oracle/product/9.0.1/jdbc/lib:/usr/lib
--Thunder
-----Original Message-----
From: Rose, Bill [mailto:Bill.Rose@;bankofamerica.com]
Sent: Monday, November 04, 2002 4:58 PM
To: 'PARLEY,JON (HP-MountainView,ex1)'
Cc: Casas, Juan R
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
Thunder - when my Systems Admin (Juan Casas) did the DBI & DBD install from
root, he got the same error. Exactly. I have been running under my own ID,
and installing to my own perllib, using the PREFIX command on the 'perl
Makefile.PL' statement. So, I would be governed by 'other' in UNIX
permission settings, except where the group is 'pii' or 'dba'. In those
cases, I would be governed by group.
OK,... here are the permission settings you requested...
-rwxrwxrwx 1 nbdipy2 pii 188448 Nov 2 21:45
blib/arch/auto/DBD/Oracle/Oracle.so
lrwxrwxrwx 1 oracle dba 16 Oct 25 11:01 libclntsh.so ->
libclntsh.so.9.0 BUT...
-rw-r--r-- 1 oracle dba 13773120 Oct 25 11:01 libclntsh.so.9.0
-r--r-xr-- 1 bin dba 27563 Oct 30 2000
/usr/lib/perl-5.6.0/lib/5.6.0/alpha-dec_osf/DynaLoader.pm
OK. Regarding the three above: one is no prob. Two could be; I'll have
the DBA change the permissions for libclntsh.so.9.0. Three, my ID is in
Group=DBA, so I have read & execute on that one. Do I need write
permissions? What troubles me is the sys admin got the same error using
root. I will try changing the permissions and rerunning, having the sys
admin try installing again, and then try static linking again, if the first
two fail.
Will keep you posted. Thanks for the help, Thunder!
-----Original Message-----
From: PARLEY,JON (HP-MountainView,ex1) [mailto:jon_parley@;hp.com]
Sent: Monday, November 04, 2002 6:05 PM
To: Rose, Bill
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
Hi Bill,
It's possible that the link is failing due to a permissions issue. It is
possible that no write priviledges are failing to allow make to write/update
the linking file. Have you tried logging in as the owner that the DB runs as
or as root?
Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so ' [What are your user
permissions for this file for nbdyip2?]
[for module DBD::Oracle: dlopen: Cannot map library libclntsh.so.9.0 [What
are your user permissions for this file for nbdyip2?] at
/usr/lib/perl-5.6.0/lib/5.6.0/alpha-dec_osf/DynaLoader.pm [What are your
user permissions for this file for nbdyip2?]
--Thunder
-----Original Message-----
From: Rose, Bill [mailto:Bill.Rose@;bankofamerica.com]
Sent: Monday, November 04, 2002 2:54 PM
To: 'PARLEY,JON (HP-MountainView,ex1)'
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
Thunder - did the LD_RUN_PATH="/st0501/app/oracle/product/9.0.1/lib" -- same
results.
Attached is a file showing my ENV.
I have tried doing a static link as well in the past, but it failed during
the 'make perl' saying it couldn't find libperl.a. I will try it again
tonight, and let you see the results tomorrow.
Thanks again for all of your help.
-----Original Message-----
From: PARLEY,JON (HP-MountainView,ex1) [mailto:jon_parley@;hp.com]
Sent: Monday, November 04, 2002 5:41 PM
To: Rose, Bill
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
Hi Bill,
I'm running out of ideas... try setting:
LD_RUN_PATH="/st0501/app/oracle/product/9.0.1/lib"
Bill, I'm almost sure that this is a linking problem. You may also want to
look at using LINKTYPE=static when you do the make (it's in the README with
DBD).
Could you send me the output of the 'env' command in the environment that
you are attempting to do this in (may help)?
--Thunder
-----Original Message-----
From: Rose, Bill [mailto:Bill.Rose@;bankofamerica.com]
Sent: Monday, November 04, 2002 11:57 AM
To: 'PARLEY,JON (HP-MountainView,ex1)'
Cc: '[EMAIL PROTECTED]'
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
Thunder - I remember seeing the LD_LIBRARY_PATH in past messages.
I set it as you suggested, reran, and got the same results.
In the pgm '/home/nbdipy2/install/DBD-Oracle-1.12/t/base.t', line 19 = $drh
= DBI->install_driver('Oracle'); This looks like the problem stmt in my
error output. "Failed to load Oracle extension and/or shared libraries:"
could mean that it failed to load the Oracle extension. What is that?
-----Original Message-----
From: PARLEY,JON (HP-MountainView,ex1) [mailto:jon_parley@;hp.com]
Sent: Monday, November 04, 2002 12:47 PM
To: Rose, Bill
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
Hi Bill,
Call me whatever. Jon is my middle name. Thunder is my first name.
Try setting $LD_LIBRARY_PATH=$ORACLE_HOME/lib . I'm not sure but maybe Tru64
doesnt recognize SHLIB (I know hpux does).
--Thunder
-----Original Message-----
From: Rose, Bill [mailto:Bill.Rose@;bankofamerica.com]
Sent: Monday, November 04, 2002 9:21 AM
To: 'PARLEY,JON (HP-MountainView,ex1)'
Cc: '[EMAIL PROTECTED]'
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
Jon (or should I call you Thunder): I actually set the $SHLIB_PATH to
contain both $ORACLE_HOME/lib AND bin, where $ORACLE_HOME is as you say
('/st0501/app/oracle/product/9.0.1'). I tried setting it to just "lib" but
it did the same thing. Any other ideas? I was hoping that there was a
binary module available for DBD::Oracle on this machine so I didn't have to
compile the source (which doesn't seem to want to compile). I've been at
this for a while now. I appreciate your help.
-----Original Message-----
From: PARLEY,JON (HP-MountainView,ex1) [mailto:jon_parley@;hp.com]
Sent: Monday, November 04, 2002 11:21 AM
To: Rose, Bill
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
Hi Bill,
Sorry for the typo. I meant $SHLIB_PATH should contain $ORACLE_HOME/lib (I
assume that $ORACLE_HOME is set in your environment. It should be
'/st0501/app/oracle/product/9.0.1' I think).
--Thunder
[EMAIL PROTECTED]
-----Original Message-----
From: Rose, Bill [mailto:Bill.Rose@;bankofamerica.com]
Sent: Sunday, November 03, 2002 8:12 PM
To: 'PARLEY,JON (HP-MountainView,ex1)'
Cc: '[EMAIL PROTECTED]'
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
Jon - thank you for your response. My $SHLIB_PATH was not set. I set it to
$ORACLE_HOME/bin as you suggested, but the results were the same. Jon - do
you know if binary versions of DBD::Oracle are available for my machine?
-----Original Message-----
From: PARLEY,JON (HP-MountainView,ex1) [mailto:jon_parley@;hp.com]
Sent: Sunday, November 03, 2002 9:33 PM
To: Rose, Bill
Subject: RE: :Oracle install snag on Compaq Tru64 (9i)
Hi Bill,
Check your $SHLIB_PATH variable. It should include $ORACLE_HOME/bin. Hope
this helps.
_/ Thunder Jon Parley
_/ Software Engineer
_/_/_/ _/_/_/ HPS - Software Mastering
_/ _/ _/_/_/
_/ _/ _/
i n v e n t [EMAIL PROTECTED]
-----Original Message-----
From: Rose, Bill [mailto:Bill.Rose@;bankofamerica.com]
Sent: Saturday, November 02, 2002 9:34 PM
To: '[EMAIL PROTECTED]'
Subject: DBD::Oracle install snag on Compaq Tru64 (9i)
Hello Tim and all:
My DBI installed fine.
My DBD install is snagged at 'make test'.
Perl -V output is attached to this e-mail.
*************************** DBD install error msg
**********************************
t/base..............Failed to load Oracle extension and/or shared libraries:
install_driver(Oracle) failed: Can't load
'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: dlopen: Cannot
map library libclntsh.so.9.0 at
/usr/lib/perl-5.6.0/lib/5.6.0/alpha-dec_osf/DynaLoader.pm line 200.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/base.t line 19
The remaining tests will probably also fail with the same error.
****************************************************************************
*********
Oracle.so is in
/home/nbdipy2/install/DBD-Oracle-1.12/blib/arch/auto/DBD/Oracle. I am
assuming that 'blib/arch/auto/DBD/Oracle/Oracle.so' is just an abbreviated
path.
Assuming that, move to the library mapping of libclntsh.so.9.0: This lib is
in $ORACLE_HOME/lib, however, there is a link. Here is what it looks like:
************************************** On UNIX:
**********************************
/home/nbdipy2/install/DBD-Oracle-1.12/blib/arch/auto/DBD/Oracle>> echo
$ORACLE_HOME
/st0501/app/oracle/product/9.0.1
/home/nbdipy2/install/DBD-Oracle-1.12/blib/arch/auto/DBD/Oracle>> ls -altr
/st0501/app/oracle/product/9.0.1/lib/libclntsh.so
lrwxrwxrwx 1 oracle dba 16 Oct 25 11:01
/st0501/app/oracle/product/9.0.1/lib/libclntsh.so -> libclntsh.so.9.0
****************************************************************************
*********
Suggestions on where I go from here?
Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration:
Platform:
osname=dec_osf, osvers=5.1, archname=alpha-dec_osf
uname='osf1 himalaya x5.1 987 alpha '
config_args='-des -Dlibpth=/usr/shlib /usr/lib /usr/ccs/lib -Dusemymalloc=no
-Dprefix=/usr/lib/perl-5.6.0 -Dman1dir=/usr/share/doclib/annex/man/man1
-Dman3dir=/usr/share/doclib/annex/man/man3 -Dccflags=-fprm d -ieee -Doptimize=-O4
-Dhostcat=cat /etc/hosts -Dmyhostname=localhost -Umydomain= -Dcf_by=perlhelp
-Dcf_email=root@localhost'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define
use64bitint=define use64bitall=define uselongdouble=undef usesocks=undef
Compiler:
cc='cc', optimize='-O4', gccversion=
cppflags='-ieee -std -DLANGUAGE_C'
ccflags ='-fprm d -ieee -std -DLANGUAGE_C'
stdchar='unsigned char', d_stdstdio=define, usevfork=false
intsize=4, longsize=8, ptrsize=8, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=8, usemymalloc=n, prototype=define
Linker and Libraries:
ld='ld', ldflags =''
libpth=/usr/shlib /usr/lib /usr/ccs/lib
libs=-ldbm -ldb -lm -liconv
libc=/usr/shlib/libc.so, so=so, useshrplib=true, libperl=libperl.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='
-Wl,-rpath,/usr/lib/perl-5.6.0/lib/5.6.0/alpha-dec_osf/CORE'
cccdlflags=' ', lddlflags='-shared -expect_unresolved "*" -O4 -msym -std -s'
Characteristics of this binary (from libperl):
Compile-time options: USE_64_BIT_INT USE_64_BIT_ALL USE_LARGE_FILES
Built under dec_osf
Compiled at Oct 31 2000 12:57:11
%ENV:
PERL5LIB="/home/nbdipy2/perllib/lib/site_perl"
@INC:
/home/nbdipy2/perllib/lib/site_perl/5.6.0/alpha-dec_osf
/home/nbdipy2/perllib/lib/site_perl/5.6.0
/home/nbdipy2/perllib/lib/site_perl
/usr/lib/perl-5.6.0/lib/5.6.0/alpha-dec_osf
/usr/lib/perl-5.6.0/lib/5.6.0
/usr/lib/perl-5.6.0/lib/site_perl/5.6.0/alpha-dec_osf
/usr/lib/perl-5.6.0/lib/site_perl/5.6.0
/usr/lib/perl-5.6.0/lib/site_perl
.
