installing DBD--Oracle-1.15

[itai weisman]

Hi ppl,
I'm trying to install perl DBD--Oracle-1.15 on a HPUX 11.11 machine (PA-Risc2).
my perl version is 5.8.6.
I have installed DBI 1.42 succesfully.
I have configured all enviorment variables as described in the README file.
for some reason, the build phase does not work.
after issuing a make command, the error I receive is:
pe
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
LD_RUN_PATH="/OracleTools/8.0.6/lib" /usr/bin/ld -b -L/usr/local/lib -L
/opt/local/lib Oracle.o dbdimp.o oci7.o oci8.o /OracleTools/8.0.6/rdbms/lib/s
sdbaed.o /OracleTools/8.0.6/rdbms/lib/defopt.o /OracleTools/8.0.6/lib/nautab.o /
OracleTools/8.0.6/lib/naeet.o /OracleTools/8.0.6/lib/naect.o /OracleTools/8.0.6/
lib/naedhs.o -lclntsh -o blib/arch/auto/DBD/Oracle/Oracle.sl -L/OracleTools/8
.0.6/lib/ -lclntsh -lnetv2 -lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lc
lient -lvsn -lcommon -lgeneric -lmm -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl
3 -lnetv2 -lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lclient -lvsn -lcom
mon -lgeneric -lepc -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lvsn
-lcommon -lgeneric -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lrt -lpthread
-ldld -lm -lclntsh
ld: Can't find library or mismatched ABI for -lclntsh
Fatal error.
*** Error exit code 1

anyone any idea?
thanks
itai

[Steven E. Protter]

SHLIB_PATH must be set to the location of the libary.

This is the most common cause of the error messsage you recieved.

SEP

[H.Merijn Brand (procura]

32/64 bit issue.

What perl did you install? 32 or 64bit
What Oracle do you have 32 or 64bit?
Does the Oracle you use support the bitness of your perl version?

This is your hint:
ld: Can't find library or mismatched ABI for -lclntsh

so find your libclntsh.sl and see what type it is with the 'file' command

DBI-1.42 is already rather old. 1.48 is current: http://search.cpan.org/~timb/DBI-1.48/
DBD-Oracle-1.15 is old, 1.16 is current: http://search.cpan.org/~timb/DBD-Oracle-1.16/

Enjoy, Have FUN! H.Merijn

[itai weisman]

hi and thanks for the quick respone.
i have add $ORACLE_HOME/lib to SHLIB_PATH.
i'm using oracle 32 bit, (8.0.6) and the perl is 64bit, i guess (it sais nothing about it on perl -v or perl -V)

[H.Merijn Brand (procura]

If Oracle is 32bit, you need a 32bit Perl. That's just how things stand on PA-RISC.

perl -v should say so, as does perl -V

32bit:

r3:/u/usr/merijn 101 > perl5.8.3 -v

This is perl, v5.8.3 built for PA-RISC2.0
(with 1 registered patch, see perl -V for more detail)

Copyright 1987-2003, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'. If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.

r3:/u/usr/merijn 102 > perl5.8.3 -V | grep 64
use64bitint=undef use64bitall=undef uselongdouble=undef
cc='cc', ccflags =' -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -I/pro/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 ',
r3:/u/usr/merijn 103 >


64bit:

r3:/u/usr/merijn 103 > perl -v

This is perl, v5.8.5 built for PA-RISC2.0-LP64
(with 2 registered patches, see perl -V for more detail)

Copyright 1987-2004, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'. If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.

r3:/u/usr/merijn 104 > perl -V | grep 64
osname=hpux, osvers=11.11, archname=PA-RISC2.0-LP64
config_args='-Dusedevel -Duse64bitall -des'
use64bitint=define use64bitall=define uselongdouble=undef
cc='cc', ccflags =' -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +DD64 -I/pro/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 ',
cppflags='-Aa -D__STDC_EXT__ -D_HPUX_SOURCE -D_HPUX_SOURCE -Wl,+vnocompatwarnings +DD64 -I/pro/local/include'
ld='/usr/bin/ld', ldflags ='+DD64 -L/lib/pa20_64 -L/usr/local/pa20_64/lib -L/pro/local/lib'
libpth=/pro/local/lib /lib/pa20_64 /lib /usr/lib /usr/ccs/lib /usr/local/lib
libc=/lib/pa20_64/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
cccdlflags='+Z', lddlflags='-b +vnocompatwarnings -L/lib/pa20_64 -L/usr/local/pa20_64/lib -L/pro/local/lib'
Compile-time options: USE_64_BIT_INT USE_64_BIT_ALL USE_LARGE_FILES
/pro/lib/perl5/5.8.5/PA-RISC2.0-LP64
/pro/lib/perl5/site_perl/5.8.5/PA-RISC2.0-LP64
r3:/u/usr/merijn 105 >

Enjoy, Have FUN! H.Merijn

[itai weisman]

now i installed DBI 1.48 as well, and i recieve the exact same problem again.

[itai weisman]

libclntsh.sl exists and in the SHLIB_PATH:
SHLIB_PATH is /OracleTools/8.0.6/lib
root@aux1>ll /OracleTools/8.0.6/lib/libclntsh.sl
lrwxr-xr-x 1 root sys 16 Apr 24 2002 /OracleTools/8.0.6/lib
/libclntsh.sl -> libclntsh.sl.1.0
ll /OracleTools/8.0.6/lib/libclntsh.sl.1.0
-rwxr-xr-x 1 oracle dba 7053312 Jan 2 2001 /OracleTools/8.0.6/lib
/libclntsh.sl.1.0
root@aux1>
root@aux1> file /OracleTools/8.0.6/lib/libclntsh.sl.1.0
/OracleTools/8.0.6/lib/libclntsh.sl.1.0: PA-RISC1.1 shared library -not s
tripped
root@aux1>

anyone?

[itai weisman]

according to that i have perl 64bit.

[H.Merijn Brand (procura]

Get rid of it, and install perl 32bit.
Sorry, there is no other option to get a working DBD-Oracle!

FWIW perl 32bit and perl 64bit live happily side by side if you want it to

I you use my distributions, the 32bit perl is installed in /opt/perl (/opt/perl/bin/perl) and the 64bit in /opt/perl64 (/opt/perl64/bin/perl). So having you $PATH set up correctly will use the right environment.
My most recent build already includes DBI-1.48

Enjoy, Have FUN! H.Merijn

[itai weisman]

where can i get it?
i want the exact version you were able to install DBD oracle with