Hello, I am attempting to build DBD-Oracle-1.16 on HP running perl
5.8.0. The server has Oracle 10g installed and I can successfully
connect to a remote database using SQLPlus.
I have tried all the various incantations listed in the READMEs (perl
Makefile.PL -p, perl Makefile.PL -nob, and perl Makefile.PL -l) without
success. Below you'll find the output of perl -V, the environment
variables I set, the perl Makefile.PL output and the failed make.
The LD_RUN_PATH built as part of Makefile.PL and used by 'make' looks
weird to me because it contains the same path twice.
LD_RUN_PATH=/usr/oracle/rdbms/10.2/lib32:/usr/oracle/rdbms/10.2/rdbms/li
b32
Although one of the switch incantations (can't remember which) resulted
in just
LD_RUN_PATH=/usr/oracle/rdbms/10.2/lib32
but the make still failed with "No such file or directory"
BTW, I realize that the current versions on CPAN are: DBI-1.54 and
DBD-Oracle-1.19. However for consistency sake since they are not much
older, I am trying to use DBI-1.50 and DBD-Oracle1.16 because they are
the same version as we have installed on Linux.
Any assistance would be greatly appreciated.
Paula
---------------
OUTPUT perl -V
---------------
[/tmp/perlDBx] # perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 0) 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='-des -Dcc=gcc -Dcf_by=ActiveState
[EMAIL PROTECTED]
tate.com -Uinstallusrbinperl -Ud_sigsetjmp -Dusethreads -Duseithreads
-Ulocincpt
h= -Uloclibpth= -Accflags=-fPIC -Dd_attribut=undef -Dcccdlflags=-fPIC
-Darchname
=PA-RISC1.1 -Duselargefiles -Accflags=-mpa-risc-1-1 -Dprefix=/opt/perl
-Duselarg
efiles'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define
usemultiplicity=de
fine
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags ='-D_POSIX_C_SOURCE=199506L -D_REENTRANT
-D_HPUX_SOURCE -f
PIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=6
4',
optimize='-O',
cppflags='-D_HPUX_SOURCE -D_POSIX_C_SOURCE=199506L -D_REENTRANT
-D_HPUX_SOUR
CE -fPIC -mpa-risc-1-1 -fno-strict-aliasing'
ccversion='', gccversion='3.2 20020708 (experimental)',
gccosandvers='hpux11
.00'
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='gcc', ldflags =''
libpth=/lib /usr/lib /usr/ccs/lib /usr/local/lib
libs=-lnsl -lnm -lndbm -lmalloc -ldld -lm -lndir -lcrypt -lsec
-lpthread
perllibs=-lnsl -lnm -lmalloc -ldld -lm -lndir -lcrypt -lsec
-lpthread
libc=/lib/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
-Wl,-B,deferr
ed '
cccdlflags='-fPIC', lddlflags='-shared -static-libgcc -fPIC'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES
PERL_IMPLICIT_
CONTEXT
Locally applied patches:
ActivePerl Build 806
Built under hpux
Compiled at May 2 2003 21:44:05
@INC:
/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi
/opt/perl/lib/5.8.0
/opt/perl/lib/site_perl/5.8.0/PA-RISC1.1-thread-multi
/opt/perl/lib/site_perl/5.8.0
/opt/perl/lib/site_perl
.
----------------------
ENVIRONMENT VARIABLES:
----------------------
ORACLE_BASE=/usr/oracle
ORACLE_HOME=/usr/oracle/rdbms/10.2
TNS_ADMIN=/etc
TWO_TASK=mp9u
LD_LIBRARY_PATH=/usr/oracle/rdbms/10.2/lib
LD_RUN_PATH=
ORACLE_USERID=scott/tiger
PATH=/usr/oracle/rdbms/10.2/bin:/usr/local/bin:/usr/sbin:/usr/bin:/opt/a
nsic/bin
:/usr/ccs/bin:/usr/contrib/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/u
pgrade/b
in:/opt/fcms/bin:/opt/resmon/bin:/opt/pd/bin:/opt/perf/bin:/usr/contrib/
bin/X11:
/usr/bin/X11:/usr/sbin/diag/contrib:/opt/prm/bin:/opt/wlm/bin:/opt/aCC/b
in:/opt/
gnome/bin:/opt/mozilla:/opt/wbem/bin:/opt/wbem/sbin:/opt/mx/bin:/opt/per
l/bin:/o
pt/langtools/bin:/opt/ignite/bin:/opt/graphics/common/bin:/opt/imake/bin
:/opt/ss
h/bin:/opt/quest/bin:/usr/ca/tngem/bin:/usr/ca/tngem/scripts:/opt/CA/Sha
redCompo
nents/bin:/sbin:/root:/opt/OV/bin:/opt/omni/lbin:/opt/OV/telalert
-----------------------
perl Makefile.PL output
-----------------------
[/tmp/perlDBx/DBD-Oracle-1.16] # perl Makefile.PL
Using DBI 1.50 (for perl 5.008 on PA-RISC1.1-thread-multi) installed in
/opt/per
l/lib/site_perl/5.8.0/PA-RISC1.1-thread-multi/auto/DBI/
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in /usr/oracle/rdbms/10.2
DEFINE _SQLPLUS_RELEASE = "1002000200" (CHAR)
Oracle version 10.2.0.2 (10.2)
Found /usr/oracle/rdbms/10.2/rdbms/demo/demo_rdbms.mk
Using /usr/oracle/rdbms/10.2/rdbms/demo/demo_rdbms.mk
Reading /usr/oracle/rdbms/10.2/rdbms/demo/demo_rdbms.mk
Reading /usr/oracle/rdbms/10.2/rdbms/lib/env_rdbms.mk
Attempting to discover Oracle OCI build rules
gcc -O -c DBD_ORA_OBJ.c
by executing: [make -f /usr/oracle/rdbms/10.2/rdbms/demo/demo_rdbms.mk
build ECH
ODO=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
-o buil
d -L/usr/oracle/rdbms/10.2/rdbms/lib/ -L/usr/oracle/rdbms/10.2/lib/ -o
DBD_ORA_
EXE DBD_ORA_OBJ.o -lclntsh `cat /usr/oracle/rdbms/10.2/lib/ldflags`
`cat /usr/
oracle/rdbms/10.2/lib/sysliblist` -lm ]
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 /usr/oracle/rdbms/10.2/lib32/ldflags` `cat
/usr/oracle
/rdbms/10.2/lib32/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 plsql/public rdbms/public.
***
*** 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.008 hp-ux bertha b.11.00 u 9000800 136901587
unlimited-user licens
e
Compiler: gcc -O -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -
mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64
Linker: /usr/bin/ld
Sysliblist: -lrt -lpthread -l:libnss_dns.1 -lnsl
Oracle makefiles would have used these definitions but we override them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) $(OPTIMIZE) $(CDEBUG) +DA2.0W +DS2.0
-DSS_64BIT_SERVER -I/u
sr/oracle/rdbms/10.2/rdbms/demo -I/usr/oracle/rdbms/10.2/rdbms/public
-I/usr/ora
cle/rdbms/10.2/plsql/public -I/usr/oracle/rdbms/10.2/network/public
$(SPFLAGS) $
(LPFLAGS) $(SHARED_CFLAG) $(USRFLAGS)]
LDFLAGS: -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o $@ -L$(PRODLIBHOME)
-L$(LIBHOME)
[-Wl,+s -Wl,+n +DA2.0W +DS2.0 -o $@
-L/usr/oracle/rdbms/10.2/rdbms/li
b/ -L$(LIBHOME)]
Linking with OTHERLDFLAGS = +s +n
-L/usr/oracle/rdbms/10.2/rdbms/lib32/ -L/us
r/oracle/rdbms/10.2/lib32/ -lclntsh -lm [from 'build' rule]
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/usr/oracle/rdbms/10.2/lib32:/usr/oracle/rdbms/10.2/rdbms/li
b32
Using DBD::Oracle 1.16.
Using DBD::Oracle 1.16.
Using DBI 1.50 (for perl 5.008 on PA-RISC1.1-thread-multi) installed in
/opt/per
l/lib/site_perl/5.8.0/PA-RISC1.1-thread-multi/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 output
---------------
[/tmp/perlDBx/DBD-Oracle-1.16] # make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp oraperl.ph blib/lib/oraperl.ph
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g"
/opt/perl/lib/site_perl
/5.8.0/PA-RISC1.1-thread-multi/auto/DBI//Driver.xst > Oracle.xsi
/usr/bin/perl /opt/perl/lib/5.8.0/ExtUtils/xsubpp
-typemap /opt/
perl/lib/5.8.0/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc
&& mv O
racle.xsc Oracle.c
gcc -c -I/usr/oracle/rdbms/10.2/rdbms/demo
-I/usr/oracle/rdbms/1
0.2/rdbms/public -I/usr/oracle/rdbms/10.2/plsql/public
-I/usr/oracle/rdbms/10.2/
network/public -I/usr/oracle/rdbms/10.2/rdbms/demo
-I/usr/oracle/rdbms/10.2/plsq
l/public -I/usr/oracle/rdbms/10.2/rdbms/public
-I/opt/perl/lib/site_perl/5.8.0/P
A-RISC1.1-thread-multi/auto/DBI/ -D_POSIX_C_SOURCE=199506L -D_REENTRANT
-D_HPUX
_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFF
SET_BITS=64 -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC
"-I/opt/perl/l
ib/5.8.0/PA-RISC1.1-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_
OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" 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:1213: warning: 'locator' might be used uninitialized in this
function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_append':
Oracle.xs:191: warning: unused variable `startp'
Oracle.c:1284: warning: 'locator' might be used uninitialized in this
function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_read':
Oracle.c:1378: warning: 'locator' might be used uninitialized in this
function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_trim':
Oracle.c:1445: warning: 'locator' might be used uninitialized in this
function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_length':
Oracle.c:1480: warning: 'locator' might be used uninitialized in this
function
gcc -c -I/usr/oracle/rdbms/10.2/rdbms/demo
-I/usr/oracle/rdbms/1
0.2/rdbms/public -I/usr/oracle/rdbms/10.2/plsql/public
-I/usr/oracle/rdbms/10.2/
network/public -I/usr/oracle/rdbms/10.2/rdbms/demo
-I/usr/oracle/rdbms/10.2/plsq
l/public -I/usr/oracle/rdbms/10.2/rdbms/public
-I/opt/perl/lib/site_perl/5.8.0/P
A-RISC1.1-thread-multi/auto/DBI/ -D_POSIX_C_SOURCE=199506L -D_REENTRANT
-D_HPUX
_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFF
SET_BITS=64 -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC
"-I/opt/perl/l
ib/5.8.0/PA-RISC1.1-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_
OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" 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: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/usr/oracle/rdbms/10.2/rdbms/demo
-I/usr/oracle/rdbms/1
0.2/rdbms/public -I/usr/oracle/rdbms/10.2/plsql/public
-I/usr/oracle/rdbms/10.2/
network/public -I/usr/oracle/rdbms/10.2/rdbms/demo
-I/usr/oracle/rdbms/10.2/plsq
l/public -I/usr/oracle/rdbms/10.2/rdbms/public
-I/opt/perl/lib/site_perl/5.8.0/P
A-RISC1.1-thread-multi/auto/DBI/ -D_POSIX_C_SOURCE=199506L -D_REENTRANT
-D_HPUX
_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFF
SET_BITS=64 -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC
"-I/opt/perl/l
ib/5.8.0/PA-RISC1.1-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_
OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" 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
"/usr/oracle/rdbms/10.2/lib32:/usr/oracle/rdbms/10.2/rdbms
/lib32" -shared -static-libgcc -fPIC Oracle.o dbdimp.o oci8.o +s +n
-L/usr
/oracle/rdbms/10.2/rdbms/lib32/ -L/usr/oracle/rdbms/10.2/lib32/
-lclntsh -l
m -o blib/arch/auto/DBD/Oracle/Oracle.sl
gcc: +b: No such file or directory
gcc: /usr/oracle/rdbms/10.2/lib32:/usr/oracle/rdbms/10.2/rdbms/lib32: No
such fi
le or directory
gcc: +s: No such file or directory
gcc: +n: No such file or directory
*** Error exit code 1
