Installing DBD::Oracle issues.

[Jamie Desjardins]

Hello,

Hopefully someone can point me in the right direction in terms of installing DBD:Oracle.

We are running HP-UX 11.11 (11i) with:
Depots Installed:
gcc 3.4.2
zlib 1.2.2
perl 5.8.2 - osname=hpux, osvers=11.11, archname=PA-RISC2.0-thread-multi-LP64

DBI v1.46 has installed with no issues
and was also able to install DBD::mysql v2.9004 correctly.

However when I try to do a make on DBD::Oracle I get the following Error:

gcc64 +b "/u00/app/oracle/iASEE/10222/lib:/u00/app/oracle/iASEE/10222/rd
bms/lib" -shared -static-libgcc -fPIC -L/lib/pa20_64 Oracle.o dbdimp.o oci8.o
+s +n -L/u00/app/oracle/iASEE/10222/lib/ -L/u00/app/oracle/iASEE/10222/rdbms/
lib/ /u00/app/oracle/iASEE/10222/rdbms/lib/kpudfo.o /u00/app/oracle/iASEE/1022
2/lib/nautab.o /u00/app/oracle/iASEE/10222/lib/naeet.o /u00/app/oracle/iASEE/102
22/lib/naect.o /u00/app/oracle/iASEE/10222/lib/naedhs.o -lclntsh /u00/app/oracle
/iASEE/10222/rdbms/lib/kpuadef.o `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10
222/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u0
0/app/oracle/iASEE/10222/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8
-lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8
-lnls8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/lib/ldflags` -lnsg
r8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/l
ib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -
lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -
lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lm -l
pls8 -lsql8 -lqsmashr -o blib/arch/auto/DBD/Oracle/Oracle.sl

gcc64: +b: No such file or directory
gcc64: /u00/app/oracle/iASEE/10222/lib:/u00/app/oracle/iASEE/10222/rdbms/lib: No
such file or directory
gcc64: +s: No such file or directory
gcc64: +n: No such file or directory
*** Error exit code 1


If you need more information please let me know, I've tried other ideas posted on the forum to no success.

Thank you,
Jamie

[Xavier Gutierrez_2]

Hi, Jamie.

Obviously you have a syntax problem.

I've been taking a look at the GNU documentation for GCC and I cannot see any of those options that fail for the gcc64 invocation (i.e. +b +s +n) nor any option starting with the + symbol...

Where did you get that command line invocation of gcc64 from?


Cheers,
Javier.

[Jamie Desjardins]

Hello,

Thanks for your response.

I ran the following did no changes to the Makefile this time (hence it ran gcc instead of gcc64 but does produce the same output):

# /opt/perl_64/bin/perl Makefile.PL
Using DBI 1.46 (for perl 5.008002 on PA-RISC2.0-thread-multi-LP64) installed in /opt/perl_64/lib/site_perl/5.8.2/PA-RISC2.0-thread-multi-LP64/auto/DBI/

Configuring DBD::Oracle ...

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

Using Oracle in /u00/app/oracle/iASEE/10222
DEFINE _SQLPLUS_RELEASE = "801070000" (CHAR)
Oracle version 8.1.7.0 (8.1)

You don't seem to have many Oracle libraries installed. If the
build fails you probably need to install more Oracle software.

Found /u00/app/oracle/iASEE/10222/rdbms/demo/demo_rdbms.mk
Found /u00/app/oracle/iASEE/10222/otrace/demo/atmoci.mk
Found /u00/app/oracle/iASEE/10222/precomp/demo/proc/demo_proc.mk
Using /u00/app/oracle/iASEE/10222/rdbms/demo/demo_rdbms.mk
Reading /u00/app/oracle/iASEE/10222/rdbms/demo/demo_rdbms.mk
Reading /u00/app/oracle/iASEE/10222/rdbms/lib/env_rdbms.mk

Attempting to discover Oracle OCI build64 rules
gcc -c -I/u00/app/oracle/iASEE/10222/rdbms/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/opt/perl_64/lib/site_perl/5.8.2/PA-RISC2.0-thread-multi-LP64/auto/DBI/ -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -DNO_HASH_SEED -mpa-risc-2-0 -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl_64/lib/5.8.2/PA-RISC2.0-thread-multi-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" DBD_ORA_OBJ.c
by executing: [make -f /u00/app/oracle/iASEE/10222/rdbms/demo/demo_rdbms.mk build64 ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=true OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
Oracle oci build command:
[ true -Wl,+s -Wl,+n +DA2.0W +DS2.0 -L/u00/app/oracle/iASEE/10222/lib64/ -L/u00/app/oracle/iASEE/10222/rdbms/lib64/ -o DBD_ORA_EXE DBD_ORA_OBJ.o /u00/app/oracle/iASEE/10222/rdbms/lib64/kpudfo.o /u00/app/oracle/iASEE/10222/lib64/nautab.o /u00/app/oracle/iASEE/10222/lib64/naeet.o /u00/app/oracle/iASEE/10222/lib64/naect.o /u00/app/oracle/iASEE/10222/lib64/naedhs.o -lclntsh /u00/app/oracle/iASEE/10222/rdbms/lib64/kpuadef.o `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `cat /u00/app/oracle/iASEE/10222/lib/sysliblist` -lm -lpls8 -lsql8 ]

Warning: Oracle is built with multi-threading libraries
You will most likely need to rebuild perl from sources
with the following libraries: -lcl -lpthread
Warning: Stripping `cat /u00/app/oracle/iASEE/10222/lib64/sysliblist`
from link command, because it contains libraries not
compiled with +z or +Z (PIC) causing link to fail.
Furthermore, we should have already grabbed these libraries
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
*** Warning: If you have trouble, try perl Makefile.PL -l
***

Checking for functioning wait.ph


System: perl5.008002 hp-ux euro b.11.11 u 9000800 882377461 unlimited-user license
Compiler: gcc -O -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -DNO_HASH_SEED -mpa-risc-2-0 -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/bin/ld
Sysliblist: -lrt -lpthread -l:libnss_dns.1
Oracle makefiles would have used these definitions but we override them:
CC: cc

CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/u00/app/oracle/iASEE/10222/rdbms/public -I/u00/app/oracle/iASEE/10222/plsql/public -I/u00/app/oracle/iASEE/10222/network/public $(SPFLAGS) $(LPFLAGS) $(SHARED_CFLAG) $(USRFLAGS)]

LDFLAGS: -Wl,+s -Wl,+n -L$(LIBHOME) -L$(RDBMSLIB)
[-Wl,+s -Wl,+n -L$(LIBHOME) -L/u00/app/oracle/iASEE/10222/rdbms/lib/]


Linking with OTHERLDFLAGS = +s +n -L/u00/app/oracle/iASEE/10222/lib64/ -L/u00/app/oracle/iASEE/10222/rdbms/lib64/ /u00/app/oracle/iASEE/10222/rdbms/lib64/kpudfo.o /u00/app/oracle/iASEE/10222/lib64/nautab.o /u00/app/oracle/iASEE/10222/lib64/naeet.o /u00/app/oracle/iASEE/10222/lib64/naect.o /u00/app/oracle/iASEE/10222/lib64/naedhs.o -lclntsh /u00/app/oracle/iASEE/10222/rdbms/lib64/kpuadef.o `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lm -lpls8 -lsql8 [from 'build64' rule]


LD_RUN_PATH=/u00/app/oracle/iASEE/10222/lib64:/u00/app/oracle/iASEE/10222/rdbms/lib64
Using DBD::Oracle 1.16.
Using DBD::Oracle 1.16.
Using DBI 1.46 (for perl 5.008002 on PA-RISC2.0-thread-multi-LP64) installed in /opt/perl_64/lib/site_perl/5.8.2/PA-RISC2.0-thread-multi-LP64/auto/DBI/
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)
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
gcc -c -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/u00/app/oracle/iASEE/10222/rdbms/public -I/u00/app/oracle/iASEE/10222/plsql/public -I/u00/app/oracle/iASEE/10222/network/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/u00/app/oracle/iASEE/10222/rdbms/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/opt/perl_64/lib/site_perl/5.8.2/PA-RISC2.0-thread-multi-LP64/auto/DBI/ -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -DNO_HASH_SEED -mpa-risc-2-0 -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl_64/lib/5.8.2/PA-RISC2.0-thread-multi-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" Oracle.c
Oracle.c: In function `XS_DBD__Oracle_constant':
Oracle.c:24: warning: 'RETVAL' might be used uninitialized in this function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_write':
Oracle.c:1197: warning: 'locator' might be used uninitialized in this function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_append':
Oracle.c:1268: warning: 'locator' might be used uninitialized in this function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_read':
Oracle.c:1362: warning: 'locator' might be used uninitialized in this function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_trim':
Oracle.c:1429: warning: 'locator' might be used uninitialized in this function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_length':
Oracle.c:1464: warning: 'locator' might be used uninitialized in this function
gcc -c -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/u00/app/oracle/iASEE/10222/rdbms/public -I/u00/app/oracle/iASEE/10222/plsql/public -I/u00/app/oracle/iASEE/10222/network/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/u00/app/oracle/iASEE/10222/rdbms/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/opt/perl_64/lib/site_perl/5.8.2/PA-RISC2.0-thread-multi-LP64/auto/DBI/ -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -DNO_HASH_SEED -mpa-risc-2-0 -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl_64/lib/5.8.2/PA-RISC2.0-thread-multi-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" dbdimp.c
dbdimp.c: In function `dbd_discon_all':
dbdimp.c:121: warning: unused variable `Perl___notused'
dbdimp.c: In function `ora_db_login6':
dbdimp.c:282: warning: unused variable `o'
dbdimp.c:283: warning: unused variable `l'
dbdimp.c:385: warning: unused variable `rsize'
dbdimp.c:239: warning: unused variable `Perl___notused'
dbdimp.c: In function `ora_db_disconnect':
dbdimp.c:689: warning: unused variable `Perl___notused'
dbdimp.c: In function `ora_db_destroy':
dbdimp.c:726: warning: unused variable `my_perl'
dbdimp.c: In function `pp_exec_rset':
dbdimp.c:1228: warning: unused variable `Perl___notused'
dbdimp.c: In function `ora_st_execute':
dbdimp.c:1600: warning: unused variable `Perl___notused'
dbdimp.c: In function `ora_st_finish':
dbdimp.c:1798: warning: unused variable `Perl___notused'
dbdimp.c: In function `ora_st_destroy':
dbdimp.c:1885: warning: unused variable `my_perl'
gcc -c -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/u00/app/oracle/iASEE/10222/rdbms/public -I/u00/app/oracle/iASEE/10222/plsql/public -I/u00/app/oracle/iASEE/10222/network/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/u00/app/oracle/iASEE/10222/rdbms/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/opt/perl_64/lib/site_perl/5.8.2/PA-RISC2.0-thread-multi-LP64/auto/DBI/ -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -DNO_HASH_SEED -mpa-risc-2-0 -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl_64/lib/5.8.2/PA-RISC2.0-thread-multi-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" oci8.c
oci8.c: In function `ora_st_fetch':
oci8.c:1382: warning: unused variable `Perl___notused'
oci8.c:1389: warning: unused variable `Perl___notused'
oci8.c: At top level:
oci8.c:566: warning: 'fetch_func_nty' defined but not used
oci8.c:1012: warning: 'fbh_setup_getrefpv' defined but not used
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
gcc +b "/u00/app/oracle/iASEE/10222/lib64:/u00/app/oracle/iASEE/10222/rdbms/lib64" -shared -static-libgcc -fPIC -L/lib/pa20_64 Oracle.o dbdimp.o oci8.o +s +n -L/u00/app/oracle/iASEE/10222/lib64/ -L/u00/app/oracle/iASEE/10222/rdbms/lib64/ /u00/app/oracle/iASEE/10222/rdbms/lib64/kpudfo.o /u00/app/oracle/iASEE/10222/lib64/nautab.o /u00/app/oracle/iASEE/10222/lib64/naeet.o /u00/app/oracle/iASEE/10222/lib64/naect.o /u00/app/oracle/iASEE/10222/lib64/naedhs.o -lclntsh /u00/app/oracle/iASEE/10222/rdbms/lib64/kpuadef.o `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lm -lpls8 -lsql8 -o blib/arch/auto/DBD/Oracle/Oracle.sl
gcc: +b: No such file or directory
gcc: /u00/app/oracle/iASEE/10222/lib64:/u00/app/oracle/iASEE/10222/rdbms/lib64: No such file or directory
gcc: +s: No such file or directory
gcc: +n: No such file or directory
gcc: /u00/app/oracle/iASEE/10222/rdbms/lib64/kpudfo.o: No such file or directory
gcc: /u00/app/oracle/iASEE/10222/lib64/nautab.o: No such file or directory
gcc: /u00/app/oracle/iASEE/10222/lib64/naeet.o: No such file or directory
gcc: /u00/app/oracle/iASEE/10222/lib64/naect.o: No such file or directory
gcc: /u00/app/oracle/iASEE/10222/lib64/naedhs.o: No such file or directory
gcc: /u00/app/oracle/iASEE/10222/rdbms/lib64/kpuadef.o: No such file or directory
*** Error exit code 1

Stop.



######################################
Here is the information from Perl -V
######################################

# /opt/perl_64/bin/perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 2) configuration:
Platform:
osname=hpux, osvers=11.11, archname=PA-RISC2.0-thread-multi-LP64
uname='hp-ux euro b.11.11 u 9000800 882377461 unlimited-user license '
config_args='-ders -Dcc=gcc -Accflags=-DNO_HASH_SEED -Dusethreads -Duseithreads -Ud_sigsetjmp -Uinstallusrbinperl -Ulocincpth= -Uloclibpth= -Dd_attribut=undef -Darchname=PA-RISC2.0 -Accflags=-mpa-risc-2-0 -Duselargefiles -Dinc_version_list=5.8.1/ 5.8.1 5.8.0/ 5.8.0 -Duseshrplib -Dprefix=/opt/perl_64 -Dcf_by=ActiveState -Dcf_email=support@ActiveState.com'
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=define use64bitall=define uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags ='-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -DNO_HASH_SEED -mpa-risc-2-0 -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O',
cppflags='-D_HPUX_SOURCE -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -DNO_HASH_SEED -mpa-risc-2-0 -fno-strict-aliasing'
ccversion='', gccversion='3.3.2', gccosandvers='hpux11.11'
intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=87654321
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, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/lib/pa20_64'
libpth=/lib/pa20_64 /lib /usr/lib /usr/ccs/lib /usr/local/lib
libs=-lnsl -lnm -ldl -ldld -lm -lsec -lpthread
perllibs=-lnsl -lnm -ldl -ldld -lm -lsec -lpthread
libc=/lib/pa20_64/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef, ccdlflags='-Wl,-E '
cccdlflags='-fPIC', lddlflags='-shared -static-libgcc -fPIC -L/lib/pa20_64'


Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY USE_ITHREADS USE_64_BIT_INT USE_64_BIT_ALL 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 15:28:40
@INC:
/opt/perl_64/lib/5.8.2/PA-RISC2.0-thread-multi-LP64
/opt/perl_64/lib/5.8.2
/opt/perl_64/lib/site_perl/5.8.2/PA-RISC2.0-thread-multi-LP64
/opt/perl_64/lib/site_perl/5.8.2
/opt/perl_64/lib/site_perl
.

[H.Merijn Brand (procura · Accepted solution]

You will not be able to build DBD::Oracle with that perl :(

The libs are in thje wrong position, and the suggestion in the error message to rebuild perl without threads and with those two libs *in front* is a true message.

Why not just fetch my un-threaded perl-5.8.5 or 5.8.6 from my site and have three advantages to give you a head start:

1. It has a very recent DBI build bundled
2. It was built with gcc, so the options are now correct
3. It is prepared for DBD::Oracle builds: the libs are in the correct order

It's no depot, and installs in /opt/perl64. Installation instructions on the site too

My HP ITRC site pages can be found at (please use LA as primary choice):

USA Los Angeles http://mirrors.develooper.com/hpux/
SGP Singapore https://www.beepz.com/personal/merijn/
USA Chicago http://ww.hpux.ws/
NL Hoofddorp http://www.cmve.net/~merijn/

Enjoy, have FUN! H.Merijn

[Jamie Desjardins]

Hi H.Merijn,

Thanks for your input, had your version already installed yesterday (followed another posting you made elsewhere in the forum) and here is what I am getting when trying to compile with your version of perl:

(note: DBD::mysql complained about -lz with (but took the -lz out of the LDLOADLIBS and it installed fine in case anyone has an issue with DBD::mysql :) )


DBD:Oracle Compile Report:

# /opt/perl64/bin/perl Makefile.PL
Using DBI 1.43 (for perl 5.008005 on PA-RISC2.0-LP64) installed in /opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI

Configuring DBD::Oracle ...

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

Using Oracle in /u00/app/oracle/iASEE/10222
DEFINE _SQLPLUS_RELEASE = "801070000" (CHAR)
Oracle version 8.1.7.0 (8.1)

You don't seem to have many Oracle libraries installed. If the
build fails you probably need to install more Oracle software.

Found /u00/app/oracle/iASEE/10222/rdbms/demo/demo_rdbms.mk
Found /u00/app/oracle/iASEE/10222/otrace/demo/atmoci.mk
Found /u00/app/oracle/iASEE/10222/precomp/demo/proc/demo_proc.mk
Using /u00/app/oracle/iASEE/10222/rdbms/demo/demo_rdbms.mk
Reading /u00/app/oracle/iASEE/10222/rdbms/demo/demo_rdbms.mk
Reading /u00/app/oracle/iASEE/10222//rdbms/lib/env_rdbms.mk

Attempting to discover Oracle OCI build64 rules
gcc64 -c -I/u00/app/oracle/iASEE/10222//rdbms/demo -I/u00/app/oracle/iASEE/10222//rdbms/public -I/u00/app/oracle/iASEE/10222//plsql/public -I/u00/app/oracle/iASEE/10222//network/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/u00/app/oracle/iASEE/10222/rdbms/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl64/lib/5.8.5/PA-RISC2.0-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" DBD_ORA_OBJ.c
by executing: [make -f /u00/app/oracle/iASEE/10222/rdbms/demo/demo_rdbms.mk build64 ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=true OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
Oracle oci build command:
[ true -Wl,+s -Wl,+n +DA2.0W +DS2.0 -L/u00/app/oracle/iASEE/10222//lib64/ -L/u00/app/oracle/iASEE/10222//rdbms/lib64/ -o DBD_ORA_EXE DBD_ORA_OBJ.o /u00/app/oracle/iASEE/10222//rdbms/lib64/kpudfo.o /u00/app/oracle/iASEE/10222//lib64/nautab.o /u00/app/oracle/iASEE/10222//lib64/naeet.o /u00/app/oracle/iASEE/10222//lib64/naect.o /u00/app/oracle/iASEE/10222//lib64/naedhs.o -lclntsh /u00/app/oracle/iASEE/10222//rdbms/lib64/kpuadef.o `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `cat /u00/app/oracle/iASEE/10222//lib/sysliblist` -lm -lpls8 -lsql8 ]

Warning: Stripping `cat /u00/app/oracle/iASEE/10222//lib64/sysliblist`
from link command, because it contains libraries not
compiled with +z or +Z (PIC) causing link to fail.
Furthermore, we should have already grabbed these libraries
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
*** Warning: If you have trouble, try perl Makefile.PL -l
***

Checking for functioning wait.ph


System: perl5.008005 hp-ux r3 b.11.11 u 9000800 1909236376 unlimited-user license
Compiler: gcc64 -g -O -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/bin/ld
Sysliblist: -lrt -lpthread -l:libnss_dns.1
Oracle makefiles would have used these definitions but we override them:
CC: cc

CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) -I/u00/app/oracle/iASEE/10222//rdbms/demo -I/u00/app/oracle/iASEE/10222//rdbms/public -I/u00/app/oracle/iASEE/10222//plsql/public -I/u00/app/oracle/iASEE/10222//network/public $(SPFLAGS) $(LPFLAGS) $(SHARED_CFLAG) $(USRFLAGS)]

LDFLAGS: -Wl,+s -Wl,+n -L$(LIBHOME) -L$(RDBMSLIB)
[-Wl,+s -Wl,+n -L$(LIBHOME) -L/u00/app/oracle/iASEE/10222//rdbms/lib/]


Linking with OTHERLDFLAGS = +s +n -L/u00/app/oracle/iASEE/10222//lib64/ -L/u00/app/oracle/iASEE/10222//rdbms/lib64/ /u00/app/oracle/iASEE/10222//rdbms/lib64/kpudfo.o /u00/app/oracle/iASEE/10222//lib64/nautab.o /u00/app/oracle/iASEE/10222//lib64/naeet.o /u00/app/oracle/iASEE/10222//lib64/naect.o /u00/app/oracle/iASEE/10222//lib64/naedhs.o -lclntsh /u00/app/oracle/iASEE/10222//rdbms/lib64/kpuadef.o `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lm -lpls8 -lsql8 [from 'build64' rule]


Warning: If you have problems you may need to rebuild perl with threading enabled.

LD_RUN_PATH=/u00/app/oracle/iASEE/10222/lib64:/u00/app/oracle/iASEE/10222/rdbms/lib64
Using DBD::Oracle 1.16.
Using DBD::Oracle 1.16.
Using DBI 1.43 (for perl 5.008005 on PA-RISC2.0-LP64) installed in /opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI
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
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
gcc64 -c -I/u00/app/oracle/iASEE/10222//rdbms/demo -I/u00/app/oracle/iASEE/10222//rdbms/public -I/u00/app/oracle/iASEE/10222//plsql/public -I/u00/app/oracle/iASEE/10222//network/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/u00/app/oracle/iASEE/10222/rdbms/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl64/lib/5.8.5/PA-RISC2.0-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" Oracle.c
gcc64 -c -I/u00/app/oracle/iASEE/10222//rdbms/demo -I/u00/app/oracle/iASEE/10222//rdbms/public -I/u00/app/oracle/iASEE/10222//plsql/public -I/u00/app/oracle/iASEE/10222//network/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/u00/app/oracle/iASEE/10222/rdbms/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl64/lib/5.8.5/PA-RISC2.0-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" dbdimp.c
dbdimp.c: In function `ora_db_login6':
dbdimp.c:385: warning: unused variable `rsize'
gcc64 -c -I/u00/app/oracle/iASEE/10222//rdbms/demo -I/u00/app/oracle/iASEE/10222//rdbms/public -I/u00/app/oracle/iASEE/10222//plsql/public -I/u00/app/oracle/iASEE/10222//network/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/u00/app/oracle/iASEE/10222/rdbms/public -I/u00/app/oracle/iASEE/10222/rdbms/demo -I/opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl64/lib/5.8.5/PA-RISC2.0-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" oci8.c
oci8.c: In function `ora_blob_read_mb_piece':
oci8.c:695: warning: comparison is always false due to limited range of data type
oci8.c: In function `ora_describe':
oci8.c:1088: warning: comparison is always false due to limited range of data type
oci8.c: At top level:
oci8.c:566: warning: 'fetch_func_nty' defined but not used
oci8.c:1012: warning: 'fbh_setup_getrefpv' defined but not used
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
/usr/bin/ld +b "/u00/app/oracle/iASEE/10222/lib64:/u00/app/oracle/iASEE/10222/rdbms/lib64" -b -L/usr/local/pa20_64/lib -L/lib/pa20_64 Oracle.o dbdimp.o oci8.o +s +n -L/u00/app/oracle/iASEE/10222//lib64/ -L/u00/app/oracle/iASEE/10222//rdbms/lib64/ /u00/app/oracle/iASEE/10222//rdbms/lib64/kpudfo.o /u00/app/oracle/iASEE/10222//lib64/nautab.o /u00/app/oracle/iASEE/10222//lib64/naeet.o /u00/app/oracle/iASEE/10222//lib64/naect.o /u00/app/oracle/iASEE/10222//lib64/naedhs.o -lclntsh /u00/app/oracle/iASEE/10222//rdbms/lib64/kpuadef.o `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lm -lpls8 -lsql8 -o blib/arch/auto/DBD/Oracle/Oracle.sl
ld: Can't find library for -lclntsh
Fatal error.
*** Error exit code 1

Stop.



# /opt/perl64/bin/perl -V
Summary of my perl5 (revision 5 version 8 subversion 5) configuration:
Platform:
osname=hpux, osvers=11.11, archname=PA-RISC2.0-LP64
uname='hp-ux r3 b.11.11 u 9000800 1909236376 unlimited-user license '
config_args='-Dusedevel -Dcc=gcc64 -Duse64bitall -des'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=define use64bitall=define uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc64', ccflags ='-mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-g -O',
cppflags='-mpa-risc-2-0 -D_HPUX_SOURCE -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include'
ccversion='', gccversion='3.4.1', gccosandvers='hpux11.11'
intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=87654321
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, prototype=define
Linker and Libraries:
ld='/usr/bin/ld', ldflags =' -L/usr/local/pa20_64/lib -L/lib/pa20_64'
libpth=/usr/local/pa20_64/lib /lib/pa20_64 /lib /usr/lib /usr/ccs/lib /usr/local/lib
libs=-lcl -lpthread -lnsl -lnm -lgdbm -ldb -ldl -ldld -lm -lsec -lc
perllibs=-lcl -lpthread -lnsl -lnm -ldl -ldld -lm -lsec -lc
libc=/lib/pa20_64/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef, ccdlflags='-Wl,-E '
cccdlflags='-fPIC', lddlflags='-b -L/usr/local/pa20_64/lib -L/lib/pa20_64'


Characteristics of this binary (from libperl):
Compile-time options: DEBUGGING USE_64_BIT_INT USE_64_BIT_ALL USE_LARGE_FILES
Locally applied patches:
Built under hpux
Compiled at Jul 24 2004 22:05:26
@INC:
/opt/perl64/lib/5.8.5/PA-RISC2.0-LP64
/opt/perl64/lib/5.8.5
/opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64
/opt/perl64/lib/site_perl/5.8.5
/opt/perl64/lib/site_perl
.

[Jamie Desjardins]

Got it running!
lclntsh.sl.10.1 was there not lclntsh.sl so made a symbolic link to it and DBD compiled.

Thanks for the awesome help!
Jamie

[H.Merijn Brand (procura]

/usr/bin/ld +b "/u00/app/oracle/iASEE/10222/lib64:/u00/app/oracle/iASEE/10222/rdbms/lib64" -b -L/usr/local/pa20_64/lib -L/lib/pa20_64 Oracle.o dbdimp.o oci8.o +s +n -L/u00/app/oracle/iASEE/10222//lib64/ -L/u00/app/oracle/iASEE/10222//rdbms/lib64/ /u00/app/oracle/iASEE/10222//rdbms/lib64/kpudfo.o /u00/app/oracle/iASEE/10222//lib64/nautab.o /u00/app/oracle/iASEE/10222//lib64/naeet.o /u00/app/oracle/iASEE/10222//lib64/naect.o /u00/app/oracle/iASEE/10222//lib64/naedhs.o -lclntsh /u00/app/oracle/iASEE/10222//rdbms/lib64/kpuadef.o `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /u00/app/oracle/iASEE/10222//lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lm -lpls8 -lsql8 -o blib/arch/auto/DBD/Oracle/Oracle.sl
ld: Can't find library for -lclntsh
Fatal error.
*** Error exit code 1

You ar e building a 64bit DBD::Oracle, and you are not finding the correct libs. It looks like you dis specify the correct path's (or Makefile.PL did)

# find /u00/app/oracle/iASEE/10222 | grep clntsh

Maybe you only have a libclntsh.1 in lib64. In that case, just

# ln -s libclntsh.1 libclntsh.sl

should do it for you

Enjoy, Have FUN! H.Merijn

[George Smithson]

+b is a command-line option for the HP native linker 'ld'. It is not a command-line option for GCC. I encountered this problem on HP-UX when building Subversion: the libtool script passes '+b $lib' to GCC. Instead, it should pass '-Wl,+b -Wl,$lib' to GCC. That will in turn cause GCC to pass '+b$lib' to the linker ld when GCC runs ld.

The other options '+s', '+n' etc look like they need the same treatment: they need to be +s if they're passed to ld directly, but if they're passed to GCC as they are in your case, they need to be '-Wl,+s', '-Wl,+n', etc.

HTH