Compiling DBI:oracle and DBD:Oracle

[MariusIversen]

So, i finaly got the DBI:oracle all working, but it seems like the Makefile that is generated on
"perl Makefile.PL" generates some parameters the compilers don't like, and i wonder if you people can help me, here is all the output, just mention if you need any more information from me.

root@hpdb6:/usr/local/src/DBD-Oracle-1.26# perl Makefile.PL
Set up gcc environment - 4.2.3
Using DBI 1.615 (for perl 5.008008 on IA64.ARCHREV_0-thread-multi) installed in /opt/perl_32/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi/auto/DBI/

Configuring DBD::Oracle for perl 5.008008 on hpux (IA64.ARCHREV_0-thread-multi)

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

Installing on a hpux, Ver#11.22
Using Oracle in /app/oracle/product/10.2.0.4
DEFINE _SQLPLUS_RELEASE = "1002000400" (CHAR)
Oracle version 10.2.0.4 (10.2)
Found /app/oracle/product/10.2.0.4/rdbms/demo/demo_rdbms32.mk
Reading /app/oracle/product/10.2.0.4/rdbms/lib/env_rdbms.mk

Attempting to discover Oracle OCI build rules
gcc -c -I/app/oracle/product/10.2.0.4/rdbms/public -I/app/oracle/product/10.2.0.4/rdbms/demo -I/app/oracle/product/10.2.0.4/rdbms/public -I/app/oracle/product/10.2.0.4/plsql/public -I/app/oracle/product/10.2.0.4/network/public -I/opt/perl_32/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE +DSitanium2 -fPIC -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fno-strict-aliasing -pipe -DVERSION=\"1.26\" -DXS_VERSION=\"1.26\" -fPIC "-I/opt/perl_32/lib/5.8.8/IA64.ARCHREV_0-thread-multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.4\" -DORA_OCI_102 DBD_ORA_OBJ.c
gcc: +DSitanium2: No such file or directory
*** Error exit code 1

Stop.
by executing: [make -f /app/oracle/product/10.2.0.4/rdbms/demo/demo_rdbms32.mk build 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 +DD32 -L/app/oracle/product/10.2.0.4/lib32/ -L/app/oracle/product/10.2.0.4/rdbms//lib32/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat /app/oracle/product/10.2.0.4/lib32/sysliblist` -lm -lpthread -lpthread]

WARNING: Stripped `cat /app/oracle/product/10.2.0.4/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 /app/oracle/product/10.2.0.4/rdbms/public.

client_version=10.2


DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.4\" -DORA_OCI_102

WARNING: If you have trouble, see README.hpux.txt...
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.008008 hp-ux bigsur03 b.11.22 u ia64 1800516905 unlimited-user license
Compiler: gcc -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE +DSitanium2 -fPIC -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fno-strict-aliasing -pipe
Linker: /usr/bin/ld
Sysliblist: -l:librt.so -l:libnss_dns.so.1 -l:libdld.so -lm -lpthread -lunwind -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) -Ae -z +Olibmerrno +Z -DHPUX -DORAIA64 -DHPUX_IA64 +DD64 -DSS_64BIT_SERVER -DHPPA64 -DSLS8NATIVE -DSLU8NATIVE +DD64 -D_LARGEFILE64_SOURCE -D_REENTRANT -DHPUX_KTHREAD -DSLXMX_ENABLE -DSLTS_ENABLE -D_REENTRANT -I/app/oracle/product/10.2.0.4/rdbms/demo -I/app/oracle/product/10.2.0.4/rdbms/public -I/app/oracle/product/10.2.0.4/plsql/public -I/app/oracle/product/10.2.0.4/network/public -DHPUX -D_REENTRANT -DHPUX_KTHREAD -DSLXMX_ENABLE -DSLTS_ENABLE -DSS_64BIT_SERVER -DBIT64 -DMACHINE64 -DORAIA64 -DHPUX_IA64 $(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -Wl,+s -Wl,+n $(LDARCH_FLAGS) -o $@ -L$(PRODLIBHOME) -L$(LIBHOME)
[-Wl,+s -Wl,+n +DD64 -o $@ -L/app/oracle/product/10.2.0.4/rdbms/lib32/ -L$(LIBHOME)]
Linking with OTHERLDFLAGS = +s +n +DD32 -L/app/oracle/product/10.2.0.4/lib32/ -L/app/oracle/product/10.2.0.4/rdbms//lib32/ -lclntsh -lm -lpthread -lpthread [from 'build' rule]

WARNING: META_MERGE is not a known parameter.
'META_MERGE' is not a known MakeMaker parameter name.
LD_RUN_PATH=/app/oracle/product/10.2.0.4/lib32:/app/oracle/product/10.2.0.4/rdbms/lib32
Using DBD::Oracle 1.26.
Using DBD::Oracle 1.26.
Using DBI 1.615 (for perl 5.008008 on IA64.ARCHREV_0-thread-multi) installed in /opt/perl_32/lib/site_perl/5.8.8/IA64.ARCHREV_0-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.txt files.
(Of course, you have read README by now anyway, haven't you?)

---

The i run make:

root@hpdb6:/usr/local/src/DBD-Oracle-1.26# 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/Object.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged)
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
gcc -c -I/app/oracle/product/10.2.0.4/rdbms/public -I/app/oracle/product/10.2.0.4/rdbms/demo -I/app/oracle/product/10.2.0.4/rdbms/public -I/app/oracle/product/10.2.0.4/plsql/public -I/app/oracle/product/10.2.0.4/network/public -I/opt/perl_32/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE +DSitanium2 -fPIC -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fno-strict-aliasing -pipe -DVERSION=\"1.26\" -DXS_VERSION=\"1.26\" -fPIC "-I/opt/perl_32/lib/5.8.8/IA64.ARCHREV_0-thread-multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"10.2.0.4\" -DORA_OCI_102 Oracle.c
gcc: +DSitanium2: No such file or directory
Oracle.c: In function 'XS_DBD__Oracle_constant':
Oracle.c:26: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle_ORA_OCI':
Oracle.c:61: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle_ora_env_var':
Oracle.c:85: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__dr_dbixs_revision':
Oracle.c:141: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db__login':
Oracle.c:236: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_selectall_arrayref':
Oracle.c:279: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_selectrow_arrayref':
Oracle.c:346: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_commit':
Oracle.c:510: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_rollback':
Oracle.c:534: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_disconnect':
Oracle.c:558: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_STORE':
Oracle.c:593: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_FETCH':
Oracle.c:622: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_DESTROY':
Oracle.c:648: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st__prepare':
Oracle.c:800: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_rows':
Oracle.c:840: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_bind_param_inout':
Oracle.c:973: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_execute':
Oracle.c:1028: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_fetchrow_arrayref':
Oracle.c:1102: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_fetchrow_array':
Oracle.c:1128: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_fetchall_arrayref':
Oracle.c:1164: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_finish':
Oracle.c:1206: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_blob_read':
Oracle.c:1243: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_STORE':
Oracle.c:1288: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_FETCH_attrib':
Oracle.c:1317: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_DESTROY':
Oracle.c:1346: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_ora_stmt_type':
Oracle.c:1403: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_ora_stmt_type_name':
Oracle.c:1429: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_ora_scroll_position':
Oracle.c:1457: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_ora_fetch_scroll':
Oracle.c:1483: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_ora_bind_param_inout_array':
Oracle.c:1515: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_ora_fetch':
Oracle.c:1562: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_ora_execute_array':
Oracle.c:1622: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__st_cancel':
Oracle.c:1670: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_ora_ping':
Oracle.c:1692: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_reauthenticate':
Oracle.c:1736: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_ora_lob_write':
Oracle.c:1760: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_ora_lob_append':
Oracle.c:1839: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_ora_lob_read':
Oracle.c:1918: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_ora_lob_trim':
Oracle.c:1993: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_ora_lob_is_init':
Oracle.c:2036: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_ora_lob_length':
Oracle.c:2079: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__db_ora_lob_chunk_size':
Oracle.c:2122: warning: unused variable 'Perl___notused'
Oracle.c: In function 'XS_DBD__Oracle__dr_init_oci':
Oracle.c:2165: warning: unused variable 'Perl___notused'
Oracle.c: In function 'boot_DBD__Oracle':
Oracle.c:2190: warning: unused variable 'Perl___notused'
*** Error exit code 1

Stop.
root@hpdb6:/usr/local/src/DBD-Oracle-1.26#

----

Then for some strange reason, i am told i can run make more than once, giving me different output, running make 3 times, will give me:

root@hpdb6:/usr/local/src/DBD-Oracle-1.26# make
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/app/oracle/product/10.2.0.4/lib32:/app/oracle/product/10.2.0.4/rdbms/lib32" gcc -shared -static-libgcc -fPIC -L/usr/lib/hpux32 Oracle.o dbdimp.o oci8.o +s +n +DD32 -L/app/oracle/product/10.2.0.4/lib32/ -L/app/oracle/product/10.2.0.4/rdbms//lib32/ -lclntsh -lm -lpthread -lpthread -o blib/arch/auto/DBD/Oracle/Oracle.so \
\

gcc: +s: No such file or directory
gcc: +n: No such file or directory
gcc: +DD32: No such file or directory
*** Error exit code 1

Stop.

----

And here im stuck, any advice, tests or more output that will be helpful?

[MariusIversen]

Hmm, no edit button, well i figured i add in perl -V output as well.

--


root@hpdb6:/usr/local/src/DBD-Oracle-1.26# perl -V
uname='hp-ux bigsur03 b.11.22 u ia64 1800516905 unlimited-user license '
config_args='-ders -Dcc=cc -Dusethreads -Duseithreads -Ud_sigsetjmp -Uinstallusrbinperl -Ulocincpth= -Uloclibpth= -Dsh=/usr/bin/sh -Dd_attribut=undef -Dd_attribute_warn_unused_result=undef -Dd_u32align=define -Aprepend:libswanted=cl -Dvendorprefix=/opt/perl_32 -Accflags=+DSitanium2 -Doptimize=-fast +Ofltacc=strict -Accflags=+Z -Accflags=-DUSE_SITECUSTOMIZE -Duselargefiles -Accflags=-DNO_HASH_SEED -Dprefix=/opt/perl_32 -Dinc_version_list=5.8.7/$archname 5.8.7 5.8.6/$archname 5.8.6 5.8.4/$archname 5.8.4 5.8.3/$archname 5.8.3 5.8.2/$archname 5.8.2 5.8.1/$archname 5.8.1 5.8.0/$archname 5.8.0 -Dsed=/usr/bin/sed -Duseshrplib -Dconfig_heavy=Config_dynamic.pl -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=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags =' -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE +DSitanium2 -fPIC -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fno-strict-aliasing -pipe',
optimize='',
cppflags='-D__STDC_EXT__ -D_HPUX_SOURCE -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -fno-strict-aliasing -pipe'
ccversion='', gccversion='4.2.3', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/lib/hpux32'
libpth=/usr/lib/hpux32 /lib /usr/lib /usr/ccs/lib /usr/local/lib
libs=-lcl -lnsl -lnm -lndbm -ldl -ldld -lm -lsec -lpthread -lc
perllibs=-lcl -lnsl -lnm -ldl -ldld -lm -lsec -lpthread -lc
libc=/usr/lib/hpux32/libc.so, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,-B,deferred '
cccdlflags='-fPIC', lddlflags='-shared -static-libgcc -fPIC -L/usr/lib/hpux32'


Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
PERL_MALLOC_WRAP USE_ITHREADS USE_LARGE_FILES
USE_PERLIO USE_REENTRANT_API USE_SITECUSTOMIZE
Locally applied patches:
ActivePerl Build 822.2 [283084]
Iin_load_module moved for compatibility with build 806
Avoid signal flag SA_RESTART for older versions of HP-UX
PerlEx support in CGI::Carp
Less verbose ExtUtils::Install and Pod::Find
Patch for CAN-2005-0448 from Debian with modifications
Rearrange @INC so that 'site' is searched before 'perl'
Partly reverted 24733 to preserve binary compatibility
32228,32231 Fix encoding problems in regex engine
MAINT31223 plus additional changes
31324 Fix DynaLoader::dl_findfile() to locate .so files again
26970 Make Passive mode the default for Net::FTP
24699 ICMP_UNREACHABLE handling in Net::Ping
Built under hpux
Compiled at Nov 16 2007 05:16:40
@INC:
/opt/perl_32/lib/5.8.8/IA64.ARCHREV_0-thread-multi
/opt/perl_32/lib/5.8.8
/opt/perl_32/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi
/opt/perl_32/lib/site_perl/5.8.8
/opt/perl_32/lib/site_perl
/opt/perl_32/lib/vendor_perl/5.8.8/IA64.ARCHREV_0-thread-multi
/opt/perl_32/lib/vendor_perl/5.8.8
/opt/perl_32/lib/vendor_perl
.

[Matti_Kurkela]

> Installing on a hpux, Ver#11.22

> System: perl5.008008 hp-ux bigsur03 b.11.22 u ia64 1800516905 unlimited-user license

Are you really running HP-UX 11.22? You're aware that it was a short-lived Itanium-only release that has not been sold by HP since April 2004, right? You should have transitioned to 11.23 long ago.

Is Oracle 10.2.0.4 even supported on HP-UX 11.22?

> gcc: +DSitanium2: No such file or directory

> gcc: +s: No such file or directory
> gcc: +n: No such file or directory
> gcc: +DD32: No such file or directory


The "+DSitanium2" option is valid for HP ANSI C compiler, but not for gcc. Something apparently assumes you're using HP's compiler and is producing option strings tailored for it instead of gcc.

I understand modern versions of DBD-Oracle have been getting better at detecting the compiler type, but the Oracle's OCI build rules may still blindly assume HP ANSI C when running on HP-UX. Since DBD-Oracle seems to get some compile options from the OCI rules, you may have to override some of them.

I think the README files inclued with the DBD-Oracle package contain some advice for compiling it with gcc on HP-UX.

> Then for some strange reason, i am told i can run make more than once, giving me different output[...]

If the last compile command of the first run created _any result at all_, make may continue from the next step of the build process when you run it again. But if the first run ended with the creation of an incomplete object file, you've only postponed the problem: the final linking steps will fail if all the necessary code is not in the object files.

Have you read the README files suggested in the Makefile.PL and make messages?

MK

[MariusIversen]

Yeah i noticed that now, but all our HP-UX are upgraded to 11.31, most of them also up to date on patch bundles as well, so they are as new as you get them, maybe the error is that some kind of the information somewhere is old and not up to date?

[James R. Ferguson]

Hi:

> Yeah i noticed that now, but all our HP-UX are upgraded to 11.31, most of them also up to date on patch bundles as well...

If I recall corrrectly, HP's Perl 5.8.8 depot was compiled on an 11.22 Itanium ('hp-ux bigsur03 b.11.22 u ia64') .

> so they are as new as you get them, maybe the error is that some kind of the information somewhere is old and not up to date?

Before the next installation attempt, do:

# make clean

(or 'clean' if you are using the CPAN module to install).

Regards!

...JRF...

[James R. Ferguson]

Hi (again):

Another comment.

Your Perl bitness and your Oracle bitness must match. If you are using a 64-bit Oracle then you will need a 64-bit Perl. By default HP installs Perl's 32-bit version.

To change to 64-bit Perl do:

# rm /opt/perl #...a symlink
# ln -s /opt/perl_64 /opt/perl /opt/perl64/bin/perl

You will also need a 'gcc64' compiler. You can simply symlink 'gcc' to 'gcc64' if necessary.

Regards!

...JRF...

[Dennis Handly]

>JRF: You will also need a 'gcc64' compiler.

The Integrity gcc compiler can compile both 32 and 64 bit. -mlp64