Install DBD for Oracle

[Elif Gius]

Hi all,

I know, you will say, "why don't you read all the other threads regarding this problem".
So I read many threads. And could solve some problems. But some still remains.
So my question is: can anyone help me.

I already installed Perl D.5.8.2.B; gcc 3.3.3, DBI-1.43.

But when I try to install DBD I have some problems.
++++++++++++++++++++
# /opt/perl/bin/perl Makefile.PL -l
Using DBI 1.43 (for perl 5.008002 on PA-RISC1.1-thread-multi) installed in /opt/perl/lib/site_perl/5.8.2/PA-RISC1.1-thread-multiI

Configuring DBD::Oracle ...

>>> Remember to actually *READ* the README file!
Especially if you have any problems.

Using Oracle in /ORACLE/u01/app/oracle/product/9.2.0.5.0
Oracle version 9.2.0.0.0 (9.200)

Found direct-link candidates: libclntsh.sl
Oracle sysliblist: -lrt -lpthread -l:libnss_dns.1 -ldld
Found header files in rdbms/public rdbms/demo.
***
*** Warning: If you have trouble, see README.hpux...
you may have to build your own perl, or go hunting for libraries
***

Checking for functioning wait.ph


System: perl5.008002 hp-ux bertha b.11.00 u 9000800 136901587 unlimited-user license
Compiler: cc -fast +Onolimit +Opromote_indirect_calls +DAportable +DS2.0 -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_S
Linker: /usr/bin/ld
Sysliblist: -lrt -lpthread -l:libnss_dns.1 -ldld

Linking with -lclntsh.


Note (probably harmless): No library found for -l:libnss_dns.1
LD_RUN_PATH=/ORACLE/u01/app/oracle/product/9.2.0.5.0/lib32
Using DBD::Oracle 1.15.
Using DBD::Oracle 1.15.
Using DBI 1.43 (for perl 5.008002 on PA-RISC1.1-thread-multi) installed in /opt/perl/lib/site_perl/5.8.2/PA-RISC1.1-thread-multiI
Writing Makefile for DBD::Oracle

*** If you have problems...
read all the log printed above, and the README and README.help files.
(Of course, you have read README by now anyway, haven't you?)

++++++++++++++++++++

# make
Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged)
cc -c -I/ORACLE/u01/app/oracle/product/9.2.0.5.0/rdbms/public -I/ORACLE/u01/app/oracle/product/9.2.0.5.0/rdbms/demo -I/c
cc: warning 487: Possibly incorrect message catalog.
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of "sendfile" with a different storage class specifier: "s.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of "sendpath" with a different storage class specifier: "s.
cc -c -I/ORACLE/u01/app/oracle/product/9.2.0.5.0/rdbms/public -I/ORACLE/u01/app/oracle/product/9.2.0.5.0/rdbms/demo -I/c
cc: warning 487: Possibly incorrect message catalog.
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of "sendfile" with a different storage class specifier: "s.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of "sendpath" with a different storage class specifier: "s.
cc -c -I/ORACLE/u01/app/oracle/product/9.2.0.5.0/rdbms/public -I/ORACLE/u01/app/oracle/product/9.2.0.5.0/rdbms/demo -I/c
cc: warning 487: Possibly incorrect message catalog.
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of "sendfile" with a different storage class specifier: "s.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of "sendpath" with a different storage class specifier: "s.
cc -c -I/ORACLE/u01/app/oracle/product/9.2.0.5.0/rdbms/public -I/ORACLE/u01/app/oracle/product/9.2.0.5.0/rdbms/demo -I/c
cc: warning 487: Possibly incorrect message catalog.
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of "sendfile" with a different storage class specifier: "s.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of "sendpath" with a different storage class specifier: "s.
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
LD_RUN_PATH="/ORACLE/u01/app/oracle/product/9.2.0.5.0/lib32" /usr/bin/ld -b +vnocompatwarnings Oracle.o dbdimp.o oci7
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.sl
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
cp ora_explain blib/script/ora_explain
/opt/perl/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oracle.3
Manifying blib/man3/DBD::Oraperl.3

++++++++++++++++++++
make test
PERL_DL_NONLAZY=1 /opt/perl/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/base......./usr/lib/dld.sl: Can't shl_load() a library containing Thread Local Storage: /usr/lib/libcl.2
/usr/lib/dld.sl: Exec format error
Failed to load Oracle extension and/or shared libraries:
install_driver(Oracle) failed: Can't load '/opt/perl/DBD-Oracle-1.15/blib/arch/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle.
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.

++++++++++++++++++++
# /opt/perl/bin/perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 2) configuration:
Platform:
osname=hpux, osvers=11.00, archname=PA-RISC1.1-thread-multi
uname='hp-ux bertha b.11.00 u 9000800 136901587 unlimited-user license '
config_args='-ders -Dcc=cc -Accflags=-DNO_HASH_SEED -Dusethreads -Duseithreads -Ud_sigsetjmp -Uinstallusrbinperl -Ulocincpth'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags =' -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -DNO_HASH_SEED -D_LARGE,
optimize='-fast +Onolimit +Opromote_indirect_calls +DAportable +DS2.0',
cppflags='-Aa -D__STDC_EXT__ -D_HPUX_SOURCE -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings'
ccversion='B.11.11.29484.GP', gccversion='', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='/usr/bin/ld', ldflags =''
libpth=/lib /usr/lib /usr/ccs/lib /usr/local/lib
libs=-lcres -lnsl -lnm -lndbm -lmalloc -ldld -lm -lcrypt -lsec -lpthread -lc
perllibs=-lcres -lnsl -lnm -lmalloc -ldld -lm -lcrypt -lsec -lpthread -lc
libc=/lib/libc.sl, so=sl, useshrplib=true, libperl=libperl.sl
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,-B,deferred '
cccdlflags='+Z', lddlflags='-b +vnocompatwarnings'


Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES PERL_IMPLICIT_CONTEXT
Locally applied patches:
ActivePerl Build 808
21739 [perl #24493] install.html not working
21737 Ooops. left an XXX comment in, and worse still it's a // comment
21735 utf8 keys now work for tied hashes
21734 Accessing unicode keys in tie hashes via hv_exists was broken
21733 ext/threads/t/problem.t
21732 Config::myconfig() fails under ithreads
21728 Update perlhist with 5.6.2
21723 Include 'SCCS' in the list of dir names ignored by installperl
21718 Empty subroutine as object method segfaults in 5.8.2 (sometimes)
21714 Fix bug #24380: assigning list with duplicated keys to a hash
21706 [perl #24460] [DOC PATCH] the begincheck program
21694 sprintf() painfully slow
21693 must copy changes from win32/makeifle.mk to wince/makefile.ce
21691 Update the list of pumpkings in perlhist.pod
21687 [PATCH 5.6.2-RC1 pod/perlhist.pod] Updated
21677 OS/2 docu
21676 Bug #24407: key for shared hash got stringified into wrong pool
21673 Be sure to use -fPIC not -fpic on Linux/SPARC
21672 extending the hash attack test
21671 Benchmark.pm cmpthese segfault
21662 'make minitest' fails for op/cproto and op/pat
21586 Comment that this 'optimisation' is actually a necessary fixup
21548 Sync with Pod::Perldoc 3.12
21540 Fix backward-compatibility issues in if.pm
Built under hpux
Compiled at Dec 7 2003 13:25:38
@INC:
/opt/perl/lib/5.8.2/PA-RISC1.1-thread-multi
/opt/perl/lib/5.8.2
/opt/perl/lib/site_perl/5.8.2/PA-RISC1.1-thread-multi
/opt/perl/lib/site_perl/5.8.2
/opt/perl/lib/site_perl

[Steve Steel]

Hi

From LD man

LD_LIBRARY_PATH, SHLIB_PATH, and LD_PRELOAD
Specifies, at runtime, directories to search for library files.
See the +s option, dld.sl(5), and the +help option for the Online
HP-UX Linker and Libraries User's Guide for more information.



You need to use LD_PRELOAD variable. It may mean loading latest patch

Definition
The LD_PRELOAD environment variable allows you to load additional
shared libraries at program startup. LD_PRELOAD provides a colon-
separated or space-separated list of shared libraries that the dynamic
loader can interpret. The dynamic loader, dld.sl, loads the specified
shared liraries as if the program had been linked explicitly with the
shared libraries in LD_PRELOAD before any other dependents of the
program.


Steve Steel