I think you have to install the perl-devel package
> Hello everybody.
>
> I'm trying to get the DBD::Oracle 1.19 Perl module working fine under SuSE
> Linux Enterprise Server 10 (IBM Power 64bit).
>
> The version of SLES is 10.0 (no SP1 applied yet) and the version of Perl
> I'm
> using is:
>
> === cut here == 8< ==
>
> Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
> Platform:
> osname=linux, osvers=2.6.16, archname=ppc-linux-thread-multi-64int
> uname='linux pear 2.6.16 #1 smp mon may 22 14:37:02 utc 2006 ppc ppc
> ppc
> gnulinux '
> config_args='-ds -e -Dprefix=/usr -Dvendorprefix=/usr
> -Dinstallusrbinperl
> -Dusethreads -Di_db -Di_dbm -Di_ndbm -Di_gdbm -Duseshrplib=true
> -Doptimize=-O2
> -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2 -g -Wall -pipe -Duse64bitint'
> hint=recommended, useposix=true, d_sigaction=define
> usethreads=define use5005threads=undef useithreads=define
> usemultiplicity=define
> useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
> use64bitint=define use64bitall=undef uselongdouble=undef
> usemymalloc=n, bincompat5005=undef
> Compiler:
> cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
> -DDEBUGGING -fno-strict-aliasing -pipe -Wdeclaration-after-statement
> -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
> optimize='-O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2 -g -Wall
> -pipe',
> cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
> -fno-strict-aliasing -pipe -Wdeclaration-after-statement'
> ccversion='', gccversion='4.1.0 (SUSE Linux)', gccosandvers=''
> intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=87654321
> d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
> ivtype='long long', ivsize=8, nvtype='double', nvsize=8,
> Off_t='off_t',
> lseeksize=8
> alignbytes=8, prototype=define
> Linker and Libraries:
> ld='cc', ldflags =''
> libpth=/lib /usr/lib /lib64 /usr/lib64 /usr/local/lib
> libs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
> perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
> libc=/lib/libc-2.4.so, so=so, useshrplib=true, libperl=libperl.so
> gnulibc_version='2.4'
> Dynamic Linking:
> dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E
> -Wl,-rpath,/usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/CORE'
> cccdlflags='-fPIC', lddlflags='-shared'
>
>
> Characteristics of this binary (from libperl):
> Compile-time options: DEBUGGING MULTIPLICITY PERL_IMPLICIT_CONTEXT
> PERL_MALLOC_WRAP THREADS_HAVE_PIDS USE_64_BIT_INT
> USE_ITHREADS USE_LARGE_FILES USE_PERLIO
> USE_REENTRANT_API
> Built under linux
> Compiled at Jun 16 2006 12:27:43
> @INC:
> /usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int
> /usr/lib/perl5/5.8.8
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int
> /usr/lib/perl5/site_perl/5.8.8
> /usr/lib/perl5/site_perl
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int
> /usr/lib/perl5/vendor_perl/5.8.8
> /usr/lib/perl5/vendor_perl
>
> === cut here == 8< ==
>
> GCC is version 4.1.0 (SUSE Linux).
>
> I installed version 10.2.0.2 of the InstanClient Oracle Client for Linux
> (Power) both 32bit and 64bit.
>
> When trying to compile with the 32bit module, I have a "Segmentation
> Fault"
> when using a Perl test script (during the DBI->connect phase) where when
> using
> the 64bit version the linker "skips" over the Oracle provided
> libclntsh.so.10.1 (it's incompatible but to me it seems fine).
>
> Anyway, here's what I did:
>
> ####################
> ## 32 bit version ##
> ####################
>
> . Downloaded:
>
> instantclient-basic-linuxppc32-10.2.0.2-20060327.zip
> instantclient-sqlplus-linuxppc32-10.2.0.2-20060327.zip
> instantclient-sdk-linuxppc32-10.2.0.2-20060327.zip
>
> . Checked their checksums against the ones reported on Oracle's website
> (and
> they do match)
>
> . Used the sqlplus to connect to an existing Oracle database (and it
> works fine). Eg:
>
> === cut here == 8< ==
>
> ORACLE_HOME=/opt/product/instantclient_10_2
> LD_LIBRARY_PATH=/opt/product/instantclient_10_2
>
> export ORACLE_HOME LD_LIBRARY_PATH
>
> cd $LD_LIBRARY_PATH
> ./sqlplus bdn_test@'(DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL =
> TCP)(HOST = 192.168.230.102)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME =
> BDNDR)))'
>
> === cut here == 8< ==
>
> I'm prompted with the bdn_test password which, once given, get me to the
> prompt.
>
> . Expanded the above files under /opt/product/instantclient_10_2
>
> . Downloaded the DBD-Oracle-1.19 package
>
> . The version of the DBI package is perl-DBI-1.50-13.2
>
> . Extracted the DBD-Oracle-1.19 package
>
> . export ORACLE_HOME=/opt/product/instantclient_10_2
> . export LD_LIBRARY_PATH=/opt/product/instantclient_10_2
>
> . perl Makefile.PL reports the following:
>
> === cut here == 8< ==
>
> Multiple copies of Driver.xst found in:
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/ at
> Makefile.PL line 35
> Using DBI 1.50 (for perl 5.008008 on ppc-linux-thread-multi-64int)
> installed
> in /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/
>
> Configuring DBD::Oracle for perl 5.008008 on linux
> (ppc-linux-thread-multi-64int)
>
> Remember to actually *READ* the README file! Especially if you have any
> problems.
>
> Using Oracle in /opt/product/instantclient_10_2
> DEFINE _SQLPLUS_RELEASE = "1002000200" (CHAR)
> Oracle version 10.2.0.2 (10.2)
> Looks like an Instant Client installation, okay
> Your LD_LIBRARY_PATH env var is set to '/opt/product/instantclient_10_2'
> Oracle sysliblist:
> Found header files in /opt/product/instantclient_10_2/sdk/include.
>
> Checking for functioning wait.ph
> Constant subroutine __USE_POSIX undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 8.
> Constant subroutine __USE_POSIX2 undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 9.
> Constant subroutine __USE_POSIX199309 undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 10.
> Constant subroutine __USE_POSIX199506 undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 11.
> Constant subroutine __USE_XOPEN undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 12.
> Constant subroutine __USE_XOPEN_EXTENDED undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 13.
> Constant subroutine __USE_UNIX98 undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 14.
> Constant subroutine __USE_LARGEFILE undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 16.
> Constant subroutine __USE_LARGEFILE64 undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 17.
> Constant subroutine __USE_FILE_OFFSET64 undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 18.
> Constant subroutine __USE_BSD undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 19.
> Constant subroutine __USE_SVID undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 20.
> Constant subroutine __USE_MISC undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 21.
> Constant subroutine __USE_GNU undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 23.
> Constant subroutine __USE_REENTRANT undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 24.
> Constant subroutine _POSIX_SOURCE undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 49.
> Constant subroutine _POSIX_C_SOURCE undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 51.
> Constant subroutine _XOPEN_SOURCE undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 53.
> Constant subroutine _XOPEN_SOURCE_EXTENDED undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 55.
> Constant subroutine _LARGEFILE64_SOURCE undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 57.
> Constant subroutine _LARGEFILE_SOURCE undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line
> 104.
> Constant subroutine __GNU_LIBRARY__ undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line
> 156.
>
>
> System: perl5.008008 linux pear 2.6.16 #1 smp mon may 22 14:37:02 utc 2006
> ppc
> ppc ppc gnulinux
> Compiler: cc -O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2 -g -Wall
> -pipe
> -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
> -fno-strict-aliasing -pipe -Wdeclaration-after-statement
> -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64
> Linker: /usr/bin/ld
> Sysliblist:
> Linking with -lclntsh.
>
> Checking if your kit is complete...
> Looks good
> LD_RUN_PATH=/opt/product/instantclient_10_2
> Using DBD::Oracle 1.19.
> Using DBD::Oracle 1.19.
> Multiple copies of Driver.xst found in:
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/ at
> Makefile.PL line 1635
> Using DBI 1.50 (for perl 5.008008 on ppc-linux-thread-multi-64int)
> installed
> in /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/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?)
>
> === cut here == 8< ==
>
> As you can see, there are some undefined but the Makefile gets completed.
>
> . make
>
> === cut here == 8< ==
>
> cp Oracle.pm blib/lib/DBD/Oracle.pm
> cp mkta.pl blib/lib/DBD/mkta.pl
> cp oraperl.ph blib/lib/oraperl.ph
> cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
> cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
> cp Oraperl.pm blib/lib/Oraperl.pm
> cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
> cp 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"
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI//Driver.xst
>> Oracle.xsi
> /usr/bin/perl /usr/lib/perl5/5.8.8/ExtUtils/xsubpp -typemap
> /usr/lib/perl5/5.8.8/ExtUtils/typemap -typemap typemap Oracle.xs >
> Oracle.xsc
> && mv Oracle.xsc Oracle.c
> cc -c -I/opt/product/instantclient_10_2/sdk/include
> -I/usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/
> -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
> -fno-strict-aliasing -pipe -Wdeclaration-after-statement
> -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2 -g
> -Wall -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC
> "-I/usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/CORE" -Wall
> -Wno-comment
> -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" Oracle.c
> In file included from
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/DBIXS.h:31,
> from Oracle.h:13,
> from Oracle.xs:1:
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/dbipport.h:227:1:
> warning: "PERL_UNUSED_DECL" redefined
> In file included from
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/DBIXS.h:19,
> from Oracle.h:13,
> from Oracle.xs:1:
> /usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/CORE/perl.h:163:1:
> warning:
> this is the location of the previous definition
> cc -c -I/opt/product/instantclient_10_2/sdk/include
> -I/usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/
> -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
> -fno-strict-aliasing -pipe -Wdeclaration-after-statement
> -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2 -g
> -Wall -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC
> "-I/usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/CORE" -Wall
> -Wno-comment
> -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" dbdimp.c
> In file included from
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/DBIXS.h:31,
> from Oracle.h:13,
> from dbdimp.c:20:
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/dbipport.h:227:1:
> warning: "PERL_UNUSED_DECL" redefined
> In file included from
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/DBIXS.h:19,
> from Oracle.h:13,
> from dbdimp.c:20:
> /usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/CORE/perl.h:163:1:
> warning:
> this is the location of the previous definition
> dbdimp.c: In function dbd_discon_all:
> dbdimp.c:190: warning: unused variable Perl___notused
> dbdimp.c: In function ora_db_login6:
> dbdimp.c:385: warning: cast to pointer from integer of different size
> dbdimp.c:399: warning: cast to pointer from integer of different size
> dbdimp.c:409: warning: cast to pointer from integer of different size
> dbdimp.c:413: warning: cast to pointer from integer of different size
> dbdimp.c:700: warning: value computed is not used
> dbdimp.c:312: warning: unused variable Perl___notused
> dbdimp.c: In function ora_db_disconnect:
> dbdimp.c:760: warning: unused variable Perl___notused
> dbdimp.c: In function ora_db_destroy:
> dbdimp.c:797: warning: unused variable my_perl
> dbdimp.c: In function dbd_rebind_ph_char:
> dbdimp.c:1110: warning: value computed is not used
> dbdimp.c:1169: warning: cast from pointer to integer of different size
> dbdimp.c: In function pp_exec_rset:
> dbdimp.c:1254: warning: unused variable my_perl
> dbdimp.c:1269: warning: unused variable my_perl
> dbdimp.c:1276: warning: unused variable Perl___notused
> dbdimp.c: In function ora_st_execute:
> dbdimp.c:1655: warning: unused variable Perl___notused
> dbdimp.c: In function ora_st_execute_array:
> dbdimp.c:1985: warning: value computed is not used
> dbdimp.c:1859: warning: unused variable Perl___notused
> dbdimp.c: In function ora_st_finish:
> dbdimp.c:2144: warning: unused variable Perl___notused
> dbdimp.c: In function ora_st_destroy:
> dbdimp.c:2237: warning: unused variable my_perl
> cc -c -I/opt/product/instantclient_10_2/sdk/include
> -I/usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/
> -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
> -fno-strict-aliasing -pipe -Wdeclaration-after-statement
> -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2 -g
> -Wall -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC
> "-I/usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/CORE" -Wall
> -Wno-comment
> -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" oci8.c
> In file included from
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/DBIXS.h:31,
> from Oracle.h:13,
> from oci8.c:11:
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/dbipport.h:227:1:
> warning: "PERL_UNUSED_DECL" redefined
> In file included from
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/DBIXS.h:19,
> from Oracle.h:13,
> from oci8.c:11:
> /usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/CORE/perl.h:163:1:
> warning:
> this is the location of the previous definition
> oci8.c: In function fetch_cleanup_rset:
> oci8.c:608: warning: unused variable Perl___notused
> oci8.c: In function fetch_func_rset:
> oci8.c:644: warning: unused variable my_perl
> oci8.c:652: warning: value computed is not used
> oci8.c:655: warning: unused variable my_perl
> oci8.c:632: warning: unused variable Perl___notused
> oci8.c: In function dbd_rebind_ph_lob:
> oci8.c:748: warning: value computed is not used
> oci8.c:779: warning: value computed is not used
> oci8.c: In function ora_st_fetch:
> oci8.c:1673: warning: unused variable Perl___notused
> oci8.c:1680: warning: unused variable Perl___notused
> oci8.c: In function post_execute_lobs:
> oci8.c:2246: warning: value computed is not used
> Running Mkbootstrap for DBD::Oracle ()
> chmod 644 Oracle.bs
> rm -f blib/arch/auto/DBD/Oracle/Oracle.so
> LD_RUN_PATH="/opt/product/instantclient_10_2" cc -shared Oracle.o
> dbdimp.o
> oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so \
> -L/opt/product/instantclient_10_2 -lclntsh \
>
> chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
> cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
> chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
> /usr/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
> Extracted ora_explain from ora_explain.PL with variable substitutions.
> cp ora_explain blib/script/ora_explain
> /usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
> blib/script/ora_explain
> Manifying blib/man1/ora_explain.1
> Manifying blib/man3/DBD::Oracle.3pm
> Manifying blib/man3/DBD::Oraperl.3pm
>
> === cut here == 8< ==
>
> Lots of warnings but the files get compiled
>
> . make install
>
> === cut here == 8< ==
>
> Installing
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBD/Oracle/dbdimp.h
> Installing
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBD/Oracle/mk.pm
> Installing
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBD/Oracle/Oracle.h
> Installing
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBD/Oracle/Oracle.bs
> Installing
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBD/Oracle/Oracle.so
> Installing
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBD/Oracle/ocitrace.h
> Files found in blib/arch: installing files in blib/lib into architecture
> dependent library tree
> Installing
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/Oraperl.pm
> Installing
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/oraperl.ph
> Installing
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/DBD/mkta.pl
> Installing
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/DBD/Oracle.pm
> Installing
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/DBD/Oracle/GetInfo.pm
> Installing /usr/share/man/man1/ora_explain.1
> Installing /usr/share/man/man3/DBD::Oraperl.3pm
> Installing /usr/share/man/man3/DBD::Oracle.3pm
> Installing /usr/bin/ora_explain
> Writing
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBD/Oracle/.packlist
> Appending installation info to
> /usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/perllocal.po
>
> === cut here == 8< ==
>
> . Tried to execute that simple script:
>
> === cut here == 8< ==
>
> #!/usr/bin/perl
> use DBI;
> use DBD::Oracle qw(:ora_types);
> use CGI qw/:standard/;
>
> $dbi_stringa_connessione = 'dbi:Oracle:(DESCRIPTION = (ADDRESS_LIST
> =(ADDRESS
> (PROTOCOL = TCP)(HOST = 192.168.230.102)(PORT =
> 1521)))(CONNECT_DATA=(SERVICE_NAME = BDNDR)))';
>
> $dbi_username = 'bdn_test'; $dbi_password = 'bdn_test';
>
> print "Before connect\n";
> $dbh = DBI->connect($dbi_stringa_connessione,$dbi_username,$dbi_password);
> print "After connect\n";
>
> === cut here == 8< ==
>
> . The script bombs out with a "Segmentation fault"
>
> I tried by removing the DBD::Oracle module with a manual unlinking of the
> required files and compiling again both with the "-p" and "-nob" option
> but
> things did not change.
>
> I also tried by using version 10.2.0.1 of required Oracle packages but
> unsuccessfully.
>
> I also specified the "-m32" option of GCC as to force 32 binaries but
> again no
> dice.
>
> ####################
> ## 64 bit version ##
> ####################
>
> . Downloaded the required file from Oracle's website:
>
> instantclient-basic-linuxppc-10.2.0.2-20060327.zip
> instantclient-sqlplus-linuxppc-10.2.0.2-20060327.zip
> instantclient-sdk-linuxppc-10.2.0.2-20060327.zip
>
> . Checked the "sqlplus" package with the very same script reported above
> (and the connection does work)
>
> . export LD_LIBRARY_PATH=/opt/product/oraclient64/instantclient_10_2
> . export ORACLE_HOME=/opt/product/oraclient64/instantclient_10_2
>
> . Remove the DBD::Oracle package
>
> . make realclean
>
> . perl Makefile.PL
>
> === cut here == 8< ==
>
> Multiple copies of Driver.xst found in:
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/ at
> Makefile.PL line 35
> Using DBI 1.50 (for perl 5.008008 on ppc-linux-thread-multi-64int)
> installed
> in /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/
>
> Configuring DBD::Oracle for perl 5.008008 on linux
> (ppc-linux-thread-multi-64int)
>
> Remember to actually *READ* the README file! Especially if you have any
> problems.
>
> Using Oracle in /opt/product/oraclient64/instantclient_10_2
> DEFINE _SQLPLUS_RELEASE = "1002000200" (CHAR)
> Oracle version 10.2.0.2 (10.2)
> Looks like an Instant Client installation, okay
> Your LD_LIBRARY_PATH env var is set to
> '/opt/product/oraclient64/instantclient_10_2'
> Oracle sysliblist:
> Found header files in
> /opt/product/oraclient64/instantclient_10_2/sdk/include.
>
> Checking for functioning wait.ph
> Constant subroutine __USE_POSIX undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 8.
> Constant subroutine __USE_POSIX2 undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 9.
> Constant subroutine __USE_POSIX199309 undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 10.
> Constant subroutine __USE_POSIX199506 undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 11.
> Constant subroutine __USE_XOPEN undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 12.
> Constant subroutine __USE_XOPEN_EXTENDED undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 13.
> Constant subroutine __USE_UNIX98 undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 14.
> Constant subroutine __USE_LARGEFILE undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 16.
> Constant subroutine __USE_LARGEFILE64 undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 17.
> Constant subroutine __USE_FILE_OFFSET64 undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 18.
> Constant subroutine __USE_BSD undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 19.
> Constant subroutine __USE_SVID undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 20.
> Constant subroutine __USE_MISC undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 21.
> Constant subroutine __USE_GNU undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 23.
> Constant subroutine __USE_REENTRANT undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 24.
> Constant subroutine _POSIX_SOURCE undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 49.
> Constant subroutine _POSIX_C_SOURCE undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 51.
> Constant subroutine _XOPEN_SOURCE undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 53.
> Constant subroutine _XOPEN_SOURCE_EXTENDED undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 55.
> Constant subroutine _LARGEFILE64_SOURCE undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line 57.
> Constant subroutine _LARGEFILE_SOURCE undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line
> 104.
> Constant subroutine __GNU_LIBRARY__ undefined at
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/features.ph
> line
> 156.
>
>
> System: perl5.008008 linux pear 2.6.16 #1 smp mon may 22 14:37:02 utc 2006
> ppc
> ppc ppc gnulinux
> Compiler: cc -O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2 -g -Wall
> -pipe
> -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
> -fno-strict-aliasing -pipe -Wdeclaration-after-statement
> -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64
> Linker: /usr/bin/ld
> Sysliblist:
> Linking with -lclntsh.
>
> LD_RUN_PATH=/opt/product/oraclient64/instantclient_10_2
> Using DBD::Oracle 1.19.
> Using DBD::Oracle 1.19.
> Multiple copies of Driver.xst found in:
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/
> /usr/lib/perl5/vendor_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/ at
> Makefile.PL line 1635
> Using DBI 1.50 (for perl 5.008008 on ppc-linux-thread-multi-64int)
> installed
> in /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/
> Writing Makefile for DBD::Oracle
>
> === cut here == 8< ==
>
> . make
>
> === cut here == 8< ==
>
> Skip blib/lib/DBD/Oracle.pm (unchanged)
> Skip blib/lib/DBD/mkta.pl (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)
> cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
> Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
> cc -c -I/opt/product/oraclient64/instantclient_10_2/sdk/include
> -I/usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/
> -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
> -fno-strict-aliasing -pipe -Wdeclaration-after-statement
> -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2 -g
> -Wall -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC
> "-I/usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/CORE" -Wall
> -Wno-comment
> -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" Oracle.c
> In file included from
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/DBIXS.h:31,
> from Oracle.h:13,
> from Oracle.xs:1:
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/dbipport.h:227:1:
> warning: "PERL_UNUSED_DECL" redefined
> In file included from
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/DBIXS.h:19,
> from Oracle.h:13,
> from Oracle.xs:1:
> /usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/CORE/perl.h:163:1:
> warning:
> this is the location of the previous definition
> cc -c -I/opt/product/oraclient64/instantclient_10_2/sdk/include
> -I/usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/
> -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
> -fno-strict-aliasing -pipe -Wdeclaration-after-statement
> -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2 -g
> -Wall -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC
> "-I/usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/CORE" -Wall
> -Wno-comment
> -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" dbdimp.c
> In file included from
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/DBIXS.h:31,
> from Oracle.h:13,
> from dbdimp.c:20:
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/dbipport.h:227:1:
> warning: "PERL_UNUSED_DECL" redefined
> In file included from
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/DBIXS.h:19,
> from Oracle.h:13,
> from dbdimp.c:20:
> /usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/CORE/perl.h:163:1:
> warning:
> this is the location of the previous definition
> dbdimp.c: In function dbd_discon_all:
> dbdimp.c:190: warning: unused variable Perl___notused
> dbdimp.c: In function ora_db_login6:
> dbdimp.c:385: warning: cast to pointer from integer of different size
> dbdimp.c:399: warning: cast to pointer from integer of different size
> dbdimp.c:409: warning: cast to pointer from integer of different size
> dbdimp.c:413: warning: cast to pointer from integer of different size
> dbdimp.c:700: warning: value computed is not used
> dbdimp.c:312: warning: unused variable Perl___notused
> dbdimp.c: In function ora_db_disconnect:
> dbdimp.c:760: warning: unused variable Perl___notused
> dbdimp.c: In function ora_db_destroy:
> dbdimp.c:797: warning: unused variable my_perl
> dbdimp.c: In function dbd_rebind_ph_char:
> dbdimp.c:1110: warning: value computed is not used
> dbdimp.c:1169: warning: cast from pointer to integer of different size
> dbdimp.c: In function pp_exec_rset:
> dbdimp.c:1254: warning: unused variable my_perl
> dbdimp.c:1269: warning: unused variable my_perl
> dbdimp.c:1276: warning: unused variable Perl___notused
> dbdimp.c: In function ora_st_execute:
> dbdimp.c:1655: warning: unused variable Perl___notused
> dbdimp.c: In function ora_st_execute_array:
> dbdimp.c:1985: warning: value computed is not used
> dbdimp.c:1859: warning: unused variable Perl___notused
> dbdimp.c: In function ora_st_finish:
> dbdimp.c:2144: warning: unused variable Perl___notused
> dbdimp.c: In function ora_st_destroy:
> dbdimp.c:2237: warning: unused variable my_perl
> cc -c -I/opt/product/oraclient64/instantclient_10_2/sdk/include
> -I/usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/
> -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
> -fno-strict-aliasing -pipe -Wdeclaration-after-statement
> -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -O2 -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2 -g
> -Wall -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC
> "-I/usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/CORE" -Wall
> -Wno-comment
> -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" oci8.c
> In file included from
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/DBIXS.h:31,
> from Oracle.h:13,
> from oci8.c:11:
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/dbipport.h:227:1:
> warning: "PERL_UNUSED_DECL" redefined
> In file included from
> /usr/lib/perl5/site_perl/5.8.8/ppc-linux-thread-multi-64int/auto/DBI/DBIXS.h:19,
> from Oracle.h:13,
> from oci8.c:11:
> /usr/lib/perl5/5.8.8/ppc-linux-thread-multi-64int/CORE/perl.h:163:1:
> warning:
> this is the location of the previous definition
> oci8.c: In function fetch_cleanup_rset:
> oci8.c:608: warning: unused variable Perl___notused
> oci8.c: In function fetch_func_rset:
> oci8.c:644: warning: unused variable my_perl
> oci8.c:652: warning: value computed is not used
> oci8.c:655: warning: unused variable my_perl
> oci8.c:632: warning: unused variable Perl___notused
> oci8.c: In function dbd_rebind_ph_lob:
> oci8.c:748: warning: value computed is not used
> oci8.c:779: warning: value computed is not used
> oci8.c: In function ora_st_fetch:
> oci8.c:1673: warning: unused variable Perl___notused
> oci8.c:1680: warning: unused variable Perl___notused
> oci8.c: In function post_execute_lobs:
> oci8.c:2246: warning: value computed is not used
> Running Mkbootstrap for DBD::Oracle ()
> chmod 644 Oracle.bs
> rm -f blib/arch/auto/DBD/Oracle/Oracle.so
> LD_RUN_PATH="/opt/product/oraclient64/instantclient_10_2" cc -shared
> Oracle.o
> dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so \
> -L/opt/product/oraclient64/instantclient_10_2 -lclntsh \
>
> /usr/bin/ld: skipping incompatible
> /opt/product/oraclient64/instantclient_10_2/libclntsh.so when searching
> for
> -lclntsh
> /usr/bin/ld: cannot find -lclntsh
> collect2: ld returned 1 exit status
> make: *** [blib/arch/auto/DBD/Oracle/Oracle.so] Error 1
>
> === cut here == 8< ==
>
> As you might notice, the
> /opt/product/oraclient64/instantclient_10_2/libclntsh.so has been skipped
> by
> "ld" since it's not compatible. Here's the output from the "file" command
> when
> executed against that file:
>
> ELF 64-bit MSB shared object, cisco 7500, version 1 (SYSV), not stripped
>
> I also tried by compiling a "static" version of the library but
> unsuccessfully.
>
> I'm not a great Oracle/Perl expert but with an Intel 32bit system the
> above
> module does run fine.
>
> Thanks for your help!
>
> Best,
> Roberto
>
> --
> ---------------------------------------------------------------------
> Roberto Zini - Tech. Support Manager - email: [EMAIL PROTECTED]
> Strhold evolution division - Via Cipriani 2 - 42100 Reggio Emilia(IT)
> Tel:+39 0522 380411 - Fax:+39 0522 307846 - Cell: 335 7700259
> ---------------------------------------------------------------------
>
