Problems building DBD-Oracle-1.16 on HP
Problems building DBD-Oracle-1.16 on HP
am 05.03.2007 20:55:48 von pcapacio
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. =20
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. =20
LD_RUN_PATH=3D/usr/oracle/rdbms/10.2/lib32:/usr/oracle/rdbms /10.2/rdbms/l=
i
b32
Although one of the switch incantations (can't remember which) resulted
in just=20
LD_RUN_PATH=3D/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 =20
---------------
OUTPUT perl -V
---------------
[/tmp/perlDBx] # perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
Platform:
osname=3Dhpux, osvers=3D11.00, archname=3DPA-RISC1.1-thread-multi
uname=3D'hp-ux bertha b.11.00 u 9000800 136901587 unlimited-user
license '
config_args=3D'-des -Dcc=3Dgcc -Dcf_by=3DActiveState
-Dcf_email=3DActivePerl@ActiveS
tate.com -Uinstallusrbinperl -Ud_sigsetjmp -Dusethreads -Duseithreads
-Ulocincpt
h=3D -Uloclibpth=3D -Accflags=3D-fPIC -Dd_attribut=3Dundef =
-Dcccdlflags=3D-fPIC
-Darchname
=3DPA-RISC1.1 -Duselargefiles -Accflags=3D-mpa-risc-1-1 =
-Dprefix=3D/opt/perl
-Duselarg
efiles'
hint=3Drecommended, useposix=3Dtrue, d_sigaction=3Ddefine
usethreads=3Ddefine use5005threads=3Dundef useithreads=3Ddefine
usemultiplicity=3Dde
fine
useperlio=3Ddefine d_sfio=3Dundef uselargefiles=3Ddefine =
usesocks=3Dundef
use64bitint=3Dundef use64bitall=3Dundef uselongdouble=3Dundef
usemymalloc=3Dn, bincompat5005=3Dundef
Compiler:
cc=3D'gcc', ccflags =3D'-D_POSIX_C_SOURCE=3D199506L -D_REENTRANT
-D_HPUX_SOURCE -f
PIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D6
4',
optimize=3D'-O',
cppflags=3D'-D_HPUX_SOURCE -D_POSIX_C_SOURCE=3D199506L -D_REENTRANT
-D_HPUX_SOUR
CE -fPIC -mpa-risc-1-1 -fno-strict-aliasing'
ccversion=3D'', gccversion=3D'3.2 20020708 (experimental)',
gccosandvers=3D'hpux11
..00'
intsize=3D4, longsize=3D4, ptrsize=3D4, doublesize=3D8, =
byteorder=3D4321
d_longlong=3Ddefine, longlongsize=3D8, d_longdbl=3Ddefine, =
longdblsize=3D16
ivtype=3D'long', ivsize=3D4, nvtype=3D'double', nvsize=3D8, =
Off_t=3D'off_t',
lseeksize
=3D8
alignbytes=3D8, prototype=3Ddefine
Linker and Libraries:
ld=3D'gcc', ldflags =3D''
libpth=3D/lib /usr/lib /usr/ccs/lib /usr/local/lib
libs=3D-lnsl -lnm -lndbm -lmalloc -ldld -lm -lndir -lcrypt -lsec
-lpthread
perllibs=3D-lnsl -lnm -lmalloc -ldld -lm -lndir -lcrypt -lsec
-lpthread
libc=3D/lib/libc.sl, so=3Dsl, useshrplib=3Dfalse, =
libperl=3Dlibperl.a
gnulibc_version=3D''
Dynamic Linking:
dlsrc=3Ddl_hpux.xs, dlext=3Dsl, d_dlsymun=3Dundef, =
ccdlflags=3D'-Wl,-E
-Wl,-B,deferr
ed '
cccdlflags=3D'-fPIC', lddlflags=3D'-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=3D/usr/oracle
ORACLE_HOME=3D/usr/oracle/rdbms/10.2
TNS_ADMIN=3D/etc
TWO_TASK=3Dmp9u
LD_LIBRARY_PATH=3D/usr/oracle/rdbms/10.2/lib
LD_RUN_PATH=3D
ORACLE_USERID=3Dscott/tiger
PATH=3D/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/nettlad m/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/bi n:/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:/o pt/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/tel alert
-----------------------
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 =3D "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=3Decho ECHO=3Decho GENCLNTSH=3D'echo genclntsh' CC=3Dtrue =
OPTIMIZE=3D CCFLAGS=3D
EXE=3DDBD
_ORA_EXE OBJS=3DDBD_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=3D199506L -D_REENTRANT =
-D_HPUX_SOURCE
-fPIC -
mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D64
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 =3D +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=3D/usr/oracle/rdbms/10.2/lib32:/usr/oracle/rdbms /10.2/rdbms/l=
i
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=3D199506L =
-D_REENTRANT
-D_HPUX
_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFF
SET_BITS=3D64 -O -DVERSION=3D\"1.16\" -DXS_VERSION=3D\"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=3D\"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=3D199506L =
-D_REENTRANT
-D_HPUX
_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFF
SET_BITS=3D64 -O -DVERSION=3D\"1.16\" -DXS_VERSION=3D\"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=3D\"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=3D199506L =
-D_REENTRANT
-D_HPUX
_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFF
SET_BITS=3D64 -O -DVERSION=3D\"1.16\" -DXS_VERSION=3D\"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=3D\"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/li b32: No
such fi
le or directory
gcc: +s: No such file or directory
gcc: +n: No such file or directory
*** Error exit code 1
AW: Problems building DBD-Oracle-1.16 on HP
am 06.03.2007 13:39:53 von Johannes.Gritsch
Looks as if gcc gets some parameters it does not understand. Is +b a para=
meter for the native C-Compiler
for HPUX? This would mean that somewhere the system still tries to use
HPUX cc and not gcc. Maybe your path variable leads to this (wrong)
conclusion. It still contains /opt/ansic/bin and /usr/ccs/bin before
/usr/contrib/bin (the path where gcc usually resides).=20
Just a blind guess.
Hannes
----- Originalnachricht -----
Von: "Capacio, Paula J"=20
Gesendet: Mon, 5.3.2007 20:56
An: dbi-users@perl.org
Betreff: Problems building DBD-Oracle-1.16 on HP
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=3D/usr/oracle/rdbms/10.2/lib32:/usr/oracle/rdbms /10.2/rdbms/l=
i
b32
Although one of the switch incantations (can't remember which) resulted
in just=20
LD_RUN_PATH=3D/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 =20
---------------
OUTPUT perl -V
---------------
[/tmp/perlDBx] # perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
Platform:
osname=3Dhpux, osvers=3D11.00, archname=3DPA-RISC1.1-thread-m=
ulti
uname=3D'hp-ux bertha b.11.00 u 9000800 136901587 unlimited-u=
ser
license '
config_args=3D'-des -Dcc=3Dgcc -Dcf_by=3DActiveState
-Dcf_email=3DActivePerl@ActiveS
tate.com -Uinstallusrbinperl -Ud_sigsetjmp -Dusethreads -Duseithreads
-Ulocincpt
h=3D -Uloclibpth=3D -Accflags=3D-fPIC -Dd_attribut=3Dundef -Dcccdlflags=3D=
-fPIC
-Darchname
=3DPA-RISC1.1 -Duselargefiles -Accflags=3D-mpa-risc-1-1 -Dprefix=3D/opt/p=
erl
-Duselarg
efiles'
hint=3Drecommended, useposix=3Dtrue, d_sigaction=3Ddefine
usethreads=3Ddefine use5005threads=3Dundef useithreads=3Ddefi=
ne
usemultiplicity=3Dde
fine
useperlio=3Ddefine d_sfio=3Dundef uselargefiles=3Ddefine uses=
ocks=3Dundef
use64bitint=3Dundef use64bitall=3Dundef uselongdouble=3Dundef=
usemymalloc=3Dn, bincompat5005=3Dundef
Compiler:
cc=3D'gcc', ccflags =3D'-D_POSIX_C_SOURCE=3D199506L -D_REENTR=
ANT
-D_HPUX_SOURCE -f
PIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D6
4',
optimize=3D'-O',
cppflags=3D'-D_HPUX_SOURCE -D_POSIX_C_SOURCE=3D199506L -D_REE=
NTRANT
-D_HPUX_SOUR
CE -fPIC -mpa-risc-1-1 -fno-strict-aliasing'
ccversion=3D'', gccversion=3D'3.2 20020708 (experimental)',
gccosandvers=3D'hpux11
00'
intsize=3D4, longsize=3D4, ptrsize=3D4, doublesize=3D8, byteo=
rder=3D4321
d_longlong=3Ddefine, longlongsize=3D8, d_longdbl=3Ddefine, lo=
ngdblsize=3D16
ivtype=3D'long', ivsize=3D4, nvtype=3D'double', nvsize=3D8, O=
ff_t=3D'off_t',
lseeksize
=3D8
alignbytes=3D8, prototype=3Ddefine
Linker and Libraries:
ld=3D'gcc', ldflags =3D''
libpth=3D/lib /usr/lib /usr/ccs/lib /usr/local/lib
libs=3D-lnsl -lnm -lndbm -lmalloc -ldld -lm -lndir -lcrypt -l=
sec
-lpthread
perllibs=3D-lnsl -lnm -lmalloc -ldld -lm -lndir -lcrypt -lsec=
-lpthread
libc=3D/lib/libc.sl, so=3Dsl, useshrplib=3Dfalse, libperl=3Dl=
ibperl.a
gnulibc_version=3D''
Dynamic Linking:
dlsrc=3Ddl_hpux.xs, dlext=3Dsl, d_dlsymun=3Dundef, ccdlflags=3D=
'-Wl,-E
-Wl,-B,deferr
ed '
cccdlflags=3D'-fPIC', lddlflags=3D'-shared -static-libgcc -fP=
IC'
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=3D/usr/oracle
ORACLE_HOME=3D/usr/oracle/rdbms/10.2
TNS_ADMIN=3D/etc
TWO_TASK=3Dmp9u
LD_LIBRARY_PATH=3D/usr/oracle/rdbms/10.2/lib
LD_RUN_PATH=3D
ORACLE_USERID=3Dscott/tiger
PATH=3D/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/nettlad m/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/bi n:/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:/o pt/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/tel alert
-----------------------
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 RE=
ADME file!
Especially if you have any pro=
blems.
Using Oracle in /usr/oracle/rdbms/10.2
DEFINE _SQLPLUS_RELEASE =3D "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=3Decho ECHO=3Decho GENCLNTSH=3D'echo genclntsh' CC=3Dtrue OPTIMIZE=3D=
CCFLAGS=3D
EXE=3DDBD
_ORA_EXE OBJS=3DDBD_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 s=
ources
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 fai=
l.
Furthermore, we should have already grabbed thes=
e 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 librar=
ies
*** 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=3D199506L -D_REENTRANT -D_HPUX_S=
OURCE
-fPIC -
mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D64
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 +D=
S2.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 =3D +s +n
-L/usr/oracle/rdbms/10.2/rdbms/lib32/ -L/us
r/oracle/rdbms/10.2/lib32/ -lclntsh -lm [from 'bui=
ld' rule]
Checking if your kit is complete...
Looks good
LD_RUN_PATH=3D/usr/oracle/rdbms/10.2/lib32:/usr/oracle/rdbms /10.2/rdbms/l=
i
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.he=
lp
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/rdbm=
s/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=3D19 9506L -D_REEN=
TRANT
-D_HPUX
_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFF
SET_BITS=3D64 -O -DVERSION=3D\"1.16\" -DXS_VERSION=3D\"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=3D\"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/rdbm=
s/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=3D19 9506L -D_REEN=
TRANT
-D_HPUX
_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFF
SET_BITS=3D64 -O -DVERSION=3D\"1.16\" -DXS_VERSION=3D\"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=3D\"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/rdbm=
s/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=3D19 9506L -D_REEN=
TRANT
-D_HPUX
_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFF
SET_BITS=3D64 -O -DVERSION=3D\"1.16\" -DXS_VERSION=3D\"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=3D\"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/Oracl=
e/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 oci=
8.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/li b32: No
such fi
le or directory
gcc: +s: No such file or directory
gcc: +n: No such file or directory
*** Error exit code 1
RE: Problems building DBD-Oracle-1.16 on HP
am 06.03.2007 14:55:24 von pcapacio
>Johannes Gritsch wrote:=20
>Sent: Tuesday, March 06, 2007 6:40 AM
>Looks as if gcc gets some parameters it does not understand.=20
>Is +b a parameter for the native C-Compiler for HPUX?=20
>This would mean that somewhere the system still tries to use
>HPUX cc and not gcc.=20
>Maybe your path variable leads to this (wrong)
which gcc results in:=20
/usr/local/bin/gcc
which cc results in:=20
/usr/bin/cc
The path shows gcc as the second directory and cc as the fourth:
/usr/oracle/rdbms/10.2/bin:/usr/local/bin:/usr/sbin:/usr/bin :/opt/ansic/b=
in:/usr
/ccs/bin:/usr/contrib/bin:/opt/hparray/bin:/opt/nettladm/bin :/opt/upgrade=
/bin:/o
pt/fcms/bin:/opt/resmon/bin:/opt/pd/bin:/opt/perf/bin:/usr/c ontrib/bin/X1=
1:/usr/
bin/X11:/usr/sbin/diag/contrib:/opt/prm/bin:/opt/wlm/bin:/op t/aCC/bin:/op=
t/gnome
/bin:/opt/mozilla:/opt/wbem/bin:/opt/wbem/sbin:/opt/mx/bin:/ opt/perl/bin:=
/opt/la
ngtools/bin:/opt/ignite/bin:/opt/graphics/common/bin:/opt/im ake/bin:/opt/=
ssh/bin
:/opt/quest/bin:/usr/ca/tngem/bin:/usr/ca/tngem/scripts:/opt /CA/SharedCom=
ponents
/bin:/sbin:/root:/opt/OV/bin:/opt/omni/lbin:/opt/OV/telalert =20
>conclusion. It still contains /opt/ansic/bin and /usr/ccs/bin before
>/usr/contrib/bin (the path where gcc usually resides).
gcc was installed by the unix team to support this build process; =
perhaps
it's not done properly? =20
gcc -v shows:
Reading specs from /usr/local/lib/gcc/hppa2.0w-hp-hpux11.11/3.4.2/specs
Configured with: ./configure : (reconfigured) ./configure : =
(reconfigured) ./c
onfigure : (reconfigured) ./configure : (reconfigured) : =
(reconfigured) ./con
figure : (reconfigured) ./configure : (reconfigured) ./configure : =
(reconfigu
red) ./configure : (reconfigured) ./configure : (reconfigured) =
../configure :
(reconfigured) ./configure : (reconfigured) ./configure : =
(reconfigured) ./con
figure : (reconfigured) ./configure : (reconfigured) ./configure : =
(reconfigu
red) ./configure : (reconfigured) ./configure : (reconfigured) =
../configure :
(reconfigured) ./configure : (reconfigured) ./configure : =
(reconfigured) ./con
figure : (reconfigured) ./configure : (reconfigured) ./configure : =
(reconfigu
red) ./configure : (reconfigured) ./configure : (reconfigured) =
../configure :
(reconfigured) ./configure : (reconfigured) ./configure : =
(reconfigured) ./con
figure : (reconfigured) ./configure : (reconfigured) ./configure : =
(reconfigu
red) ./configure : (reconfigured) ./configure : (reconfigured) =
../configure :
(reconfigured) ./configure : (reconfigured) ./configure : =
(reconfigured) ./con
figure : (reconfigured) ./configure : (reconfigured) ./configure : =
(reconfigu
red) ./configure : (reconfigured) ./configure : (reconfigured) =
../configure :
(reconfigured) ./configure : (reconfigured) ./configure : =
(reconfigured) ./con
figure : (reconfigured) ./configure : (reconfigured) ./configure : =
(reconfigu
red) ./configure
Thread model: single
gcc version 3.4.2
Is that normal?
I should qualify that I'm just a perl pgmr with no 'c' experience.
I'm not a unix admin or a dba and all help is appreciated!!
Thanks in advance,=20
Paula =20
=20
----- Originalnachricht -----
Von: "Capacio, Paula J"=20
Gesendet: Mon, 5.3.2007 20:56
An: dbi-users@perl.org
Betreff: Problems building DBD-Oracle-1.16 on HP
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=3D/usr/oracle/rdbms/10.2/lib32:/usr/oracle/rdbms /10.2/rdbms/l=
i
b32
Although one of the switch incantations (can't remember which) resulted
in just=20
LD_RUN_PATH=3D/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 =20
---------------
OUTPUT perl -V
---------------
[/tmp/perlDBx] # perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
Platform:
osname=3Dhpux, osvers=3D11.00, =
archname=3DPA-RISC1.1-thread-multi
uname=3D'hp-ux bertha b.11.00 u 9000800 136901587 =
unlimited-user
license '
config_args=3D'-des -Dcc=3Dgcc -Dcf_by=3DActiveState
-Dcf_email=3DActivePerl@ActiveS
tate.com -Uinstallusrbinperl -Ud_sigsetjmp -Dusethreads -Duseithreads
-Ulocincpt
h=3D -Uloclibpth=3D -Accflags=3D-fPIC -Dd_attribut=3Dundef =
-Dcccdlflags=3D-fPIC
-Darchname
=3DPA-RISC1.1 -Duselargefiles -Accflags=3D-mpa-risc-1-1 =
-Dprefix=3D/opt/perl
-Duselarg
efiles'
hint=3Drecommended, useposix=3Dtrue, d_sigaction=3Ddefine
usethreads=3Ddefine use5005threads=3Dundef =
useithreads=3Ddefine
usemultiplicity=3Dde
fine
useperlio=3Ddefine d_sfio=3Dundef uselargefiles=3Ddefine =
usesocks=3Dundef
use64bitint=3Dundef use64bitall=3Dundef =
uselongdouble=3Dundef
usemymalloc=3Dn, bincompat5005=3Dundef
Compiler:
cc=3D'gcc', ccflags =3D'-D_POSIX_C_SOURCE=3D199506L =
-D_REENTRANT
-D_HPUX_SOURCE -f
PIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D6
4',
optimize=3D'-O',
cppflags=3D'-D_HPUX_SOURCE -D_POSIX_C_SOURCE=3D199506L =
-D_REENTRANT
-D_HPUX_SOUR
CE -fPIC -mpa-risc-1-1 -fno-strict-aliasing'
ccversion=3D'', gccversion=3D'3.2 20020708 (experimental)',
gccosandvers=3D'hpux11
..00'
intsize=3D4, longsize=3D4, ptrsize=3D4, doublesize=3D8, =
byteorder=3D4321
d_longlong=3Ddefine, longlongsize=3D8, d_longdbl=3Ddefine, =
longdblsize=3D16
ivtype=3D'long', ivsize=3D4, nvtype=3D'double', nvsize=3D8, =
Off_t=3D'off_t',
lseeksize
=3D8
alignbytes=3D8, prototype=3Ddefine
Linker and Libraries:
ld=3D'gcc', ldflags =3D''
libpth=3D/lib /usr/lib /usr/ccs/lib /usr/local/lib
libs=3D-lnsl -lnm -lndbm -lmalloc -ldld -lm -lndir -lcrypt =
-lsec
-lpthread
perllibs=3D-lnsl -lnm -lmalloc -ldld -lm -lndir -lcrypt =
-lsec
-lpthread
libc=3D/lib/libc.sl, so=3Dsl, useshrplib=3Dfalse, =
libperl=3Dlibperl.a
gnulibc_version=3D''
Dynamic Linking:
dlsrc=3Ddl_hpux.xs, dlext=3Dsl, d_dlsymun=3Dundef, =
ccdlflags=3D'-Wl,-E
-Wl,-B,deferr
ed '
cccdlflags=3D'-fPIC', lddlflags=3D'-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=3D/usr/oracle
ORACLE_HOME=3D/usr/oracle/rdbms/10.2
TNS_ADMIN=3D/etc
TWO_TASK=3Dmp9u
LD_LIBRARY_PATH=3D/usr/oracle/rdbms/10.2/lib
LD_RUN_PATH=3D
ORACLE_USERID=3Dscott/tiger
PATH=3D/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/nettlad m/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/bi n:/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:/o pt/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/tel alert
-----------------------
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 =3D "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=3Decho ECHO=3Decho GENCLNTSH=3D'echo genclntsh' CC=3Dtrue =
OPTIMIZE=3D CCFLAGS=3D
EXE=3DDBD
_ORA_EXE OBJS=3DDBD_ORA_OBJ.o]
Oracle oci build command:
=
[ =A0=A 0 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=3D199506L -D_REENTRANT =
-D_HPUX_SOURCE
-fPIC -
mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D64
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 =3D +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=3D/usr/oracle/rdbms/10.2/lib32:/usr/oracle/rdbms /10.2/rdbms/l=
i
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=3D19 9506L =
-D_REENTRANT
-D_HPUX
_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFF
SET_BITS=3D64 =
-O -DVERSION=3D\"1.16\" -DXS_VERSION=3D\"1.1 6\" -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=3D\"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=3D19 9506L =
-D_REENTRANT
-D_HPUX
_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFF
SET_BITS=3D64 =
-O -DVERSION=3D\"1.16\" -DXS_VERSION=3D\"1.1 6\" -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=3D\"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=3D19 9506L =
-D_REENTRANT
-D_HPUX
_SOURCE -fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFF
SET_BITS=3D64 =
-O -DVERSION=3D\"1.16\" -DXS_VERSION=3D\"1.1 6\" -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=3D\"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/li b32: No
such fi
le or directory
gcc: +s: No such file or directory
gcc: +n: No such file or directory
*** Error exit code 1
Re: Problems building DBD-Oracle-1.16 on HP
am 07.03.2007 10:59:52 von hjp
--CblX+4bnyfN0pR09
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
On 2007-03-06 13:39:53 +0100, Johannes Gritsch wrote:
> Looks as if gcc gets some parameters it does not understand. Is +b a para=
meter for the native C-Compiler
> for HPUX?
Its an option for the HP-UX linker:
+b path_list Specify a colon-separated list of directories
(embedded path) to be searched at program run-time
to locate shared libraries needed by the
executable output file that were specified with
either the -l or -l: option.
> This would mean that somewhere the system still tries to use
> HPUX cc and not gcc.
Maybe the Makefiles supplied by Oracle. I notice other HP-UX cc specific
options in other parts which look like the come from Oracle, too (I have
to admit that I didn't really try to check which part of Paula's output
comes from which part of the build system).
I have only ever built DBD::Oracle with HP's ANSI C compiler. If that is
available, I suggest compiling a recent version of perl with that from
scratch and then use that. (And read the README file! You to configure
perl in a non-standard way on HP-UX to get DBD::Oracle working ).
hp
--=20
_ | Peter J. Holzer | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR | I'd be programming in Java.
| | | hjp@wsr.ac.at | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users
--CblX+4bnyfN0pR09
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFF7o0YMdFfQa64PCwRAqyMAJsFgET6RfjnebrnSjhxlVBdtJCS/wCf b5wX
nRo23kfaar9/vKzjaZ0NycY=
=ydGy
-----END PGP SIGNATURE-----
--CblX+4bnyfN0pR09--
RE: Problems building DBD-Oracle-1.16 on HP
am 08.03.2007 16:23:48 von pcapacio
Update:=20
I had our unix server tech open an issue with HP on this since we
have a maintenance contract. I attempted to use gcc because the=20
perl version installed was compiled with gcc. HP will help if we
follow the instructions here:
http://h21007.www2.hp.com/dspp/tech/tech_TechDocumentDetailP age_IDX/1,17
01,5672,00.html
Basically upgrading to a perl version compiled with the HP compiler
and building DBD-Oracle using that compiler as well. That is our
current plan.
Thanks to both Peter and Johannes for attempting to help. You were=20
absolutely correct in that my compile environment was a mix of gcc and
HP C.
Paula=20
--------------------------
On 2007-03-06 13:39:53 +0100, Johannes Gritsch wrote:
>> Looks as if gcc gets some parameters it does not understand. Is +b a
parameter for the native=20
>>C-Compiler
>> for HPUX?
On Wednesday, March 07, 2007 4:00 AM, Peter J. Holzer wrote:
>Its an option for the HP-UX linker:
>
> +b path_list Specify a colon-separated list of directories
> (embedded path) to be searched at program run-time
> to locate shared libraries needed by the
> executable output file that were specified with
> either the -l or -l: option.
>> This would mean that somewhere the system still tries to use
>> HPUX cc and not gcc.
>Maybe the Makefiles supplied by Oracle. I notice other HP-UX cc
specific
>options in other parts which look like the come from Oracle, too (I
have
>to admit that I didn't really try to check which part of Paula's output
>comes from which part of the build system).
>I have only ever built DBD::Oracle with HP's ANSI C compiler. If that
is
>available, I suggest compiling a recent version of perl with that from
>scratch and then use that. (And read the README file! You to configure
>perl in a non-standard way on HP-UX to get DBD::Oracle working ).