AW: Problems building DBD-Oracle-1.16 on HP

Looks as if gcc gets some parameters it does not understand. Is +b a parameter 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).



Just a blind guess.



Hannes


----- Originalnachricht -----
Von: "Capacio, Paula J"
Gesendet: Mon, 5.3.2007 20:56
An: dbi-users@xxxxxxxx
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=/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
-Dcf_email=ActivePerl@ActiveS
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

.

Relevant Pages