DBD::Oracle 1.26 does not install with CentOS/RHEL 5.5 and OIC 11.2

Alexander Farber <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase.devel
Message-ID <[email protected]>
Hello,

I have installed the following packages:

  oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm
  oracle-instantclient11.2-devel-11.2.0.2.0.x86_64.rpm
  oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm

on my CentOS 5.5 Linux / 64 bit with perl 5.8.8
and have set the following env. variables:

  export TNS_ADMIN=/etc
  export ORACLE_HOME=/usr/lib/oracle/11.2
  export LD_LIBRARY_PATH=$ORACLE_HOME/client64/lib
  PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/client64/bin

After that I'm able to access the remote Oracle database
through sqlplus shell and PHP (with: extension=oci8.so)

Installing DBD::Oracle through CPAN shell fails however
(installing other Perl modules previously has worked well):

#  sudo -E perl -MCPAN -e shell

cpan shell -- CPAN exploration and modules installation (v1.9402)
Enter 'h' for help.

cpan[1]> install DBD::Oracle
CPAN: Storable loaded ok (v2.15)
Going to read '/home/afarber/.cpan/Metadata'
  Database was generated on Mon, 06 Dec 2010 04:30:56 GMT
Running install for module 'DBD::Oracle'
Running make for T/TI/TIMB/DBD-Oracle-1.26.tar.gz
CPAN: Digest::SHA loaded ok (v5.48)
CPAN: Compress::Zlib loaded ok (v2.03)
Checksum for /home/afarber/.cpan/sources/authors/id/T/TI/TIMB/DBD-Oracle-1.26.tar.gz
ok
Scanning cache /home/afarber/.cpan/build for sizes
.....................................---------------------------------------DONE
DEL(1/22): /home/afarber/.cpan/build/Bundle-CPAN-1.858
DEL(2/22): /home/afarber/.cpan/build/DBD-Oracle-1.26
DEL(3/22): /home/afarber/.cpan/build/Test-Simple-0.96
DEL(4/22): /home/afarber/.cpan/build/FCGI-0.71
DEL(5/22): /home/afarber/.cpan/build/CGI.pm-3.50
DEL(6/22): /home/afarber/.cpan/build/CGI-Session-4.42
DEL(7/22): /home/afarber/.cpan/build/Sub-Uplevel-0.22
DEL(8/22): /home/afarber/.cpan/build/Test-Exception-0.31
DEL(9/22): /home/afarber/.cpan/build/Test-Tester-0.107
DEL(10/22): /home/afarber/.cpan/build/Test-NoWarnings-1.02
DEL(11/22): /home/afarber/.cpan/build/Test-Deep-0.108
DEL(12/22): /home/afarber/.cpan/build/Apache-Session-1.89
DEL(13/22): /home/afarber/.cpan/build/Test-Harness-3.22
DEL(14/22): /home/afarber/.cpan/build/ExtUtils-CBuilder-0.2703
DEL(15/22): /home/afarber/.cpan/build/ExtUtils-MakeMaker-6.56
DEL(16/22): /home/afarber/.cpan/build/PathTools-3.33
DEL(17/22): /home/afarber/.cpan/build/File-Temp-0.22
DEL(18/22): /home/afarber/.cpan/build/Scalar-List-Utils-1.23
DEL(19/22): /home/afarber/.cpan/build/Data-Dumper-2.128
DEL(20/22): /home/afarber/.cpan/build/Digest-SHA-5.48
DEL(21/22): /home/afarber/.cpan/build/Compress-Raw-Bzip2-2.031
DEL(22/22): /home/afarber/.cpan/build/Compress-Raw-Zlib-2.030
CPAN: Archive::Tar loaded ok (v1.72)
DBD-Oracle-1.26/
DBD-Oracle-1.26/Changes
DBD-Oracle-1.26/dbdimp.c
DBD-Oracle-1.26/dbdimp.h
DBD-Oracle-1.26/dbivport.h
DBD-Oracle-1.26/hints/
DBD-Oracle-1.26/lib/
DBD-Oracle-1.26/Makefile.PL
DBD-Oracle-1.26/MANIFEST
DBD-Oracle-1.26/META.yml
DBD-Oracle-1.26/mkta.pl
DBD-Oracle-1.26/oci.def
DBD-Oracle-1.26/oci8.c
DBD-Oracle-1.26/ocitrace.h
DBD-Oracle-1.26/ora_explain.PL
DBD-Oracle-1.26/Oracle.ex/
DBD-Oracle-1.26/Oracle.h
DBD-Oracle-1.26/Oracle.pm
DBD-Oracle-1.26/Oracle.xs
DBD-Oracle-1.26/oraperl.ph
DBD-Oracle-1.26/Oraperl.pm
DBD-Oracle-1.26/README
DBD-Oracle-1.26/README-files/
DBD-Oracle-1.26/README.64bit.txt
DBD-Oracle-1.26/README.aix.txt
DBD-Oracle-1.26/README.clients.txt
DBD-Oracle-1.26/README.explain.txt
DBD-Oracle-1.26/README.help.txt
DBD-Oracle-1.26/README.hpux.txt
DBD-Oracle-1.26/README.java.txt
DBD-Oracle-1.26/README.linux.txt
DBD-Oracle-1.26/README.login.txt
DBD-Oracle-1.26/README.longs.txt
DBD-Oracle-1.26/README.macosx.txt
DBD-Oracle-1.26/README.sec.txt
DBD-Oracle-1.26/README.sun.txt
DBD-Oracle-1.26/README.vms.txt
DBD-Oracle-1.26/README.win32.txt
DBD-Oracle-1.26/README.win64.txt
DBD-Oracle-1.26/README.wingcc.txt
DBD-Oracle-1.26/t/
DBD-Oracle-1.26/test.pl
DBD-Oracle-1.26/Todo
DBD-Oracle-1.26/typemap
DBD-Oracle-1.26/t/01base.t
DBD-Oracle-1.26/t/10general.t
DBD-Oracle-1.26/t/12impdata.t
DBD-Oracle-1.26/t/14threads.t
DBD-Oracle-1.26/t/15nls.t
DBD-Oracle-1.26/t/20select.t
DBD-Oracle-1.26/t/21nchar.t
DBD-Oracle-1.26/t/22nchar_al32utf8.t
DBD-Oracle-1.26/t/22nchar_utf8.t
DBD-Oracle-1.26/t/23wide_db.t
DBD-Oracle-1.26/t/23wide_db_8bit.t
DBD-Oracle-1.26/t/23wide_db_al32utf8.t
DBD-Oracle-1.26/t/24implicit_utf8.t
DBD-Oracle-1.26/t/25plsql.t
DBD-Oracle-1.26/t/26exe_array.t
DBD-Oracle-1.26/t/28array_bind.t
DBD-Oracle-1.26/t/30long.t
DBD-Oracle-1.26/t/31lob.t
DBD-Oracle-1.26/t/31lob_extended.t
DBD-Oracle-1.26/t/32xmltype.t
DBD-Oracle-1.26/t/34pres_lobs.t
DBD-Oracle-1.26/t/40ph_type.t
DBD-Oracle-1.26/t/50cursor.t
DBD-Oracle-1.26/t/51scroll.t
DBD-Oracle-1.26/t/55nested.t
DBD-Oracle-1.26/t/56embbeded.t
DBD-Oracle-1.26/t/58object.t
DBD-Oracle-1.26/t/60reauth.t
DBD-Oracle-1.26/t/70meta.t
DBD-Oracle-1.26/t/80ora_charset.t
DBD-Oracle-1.26/t/nchar_test_lib.pl
DBD-Oracle-1.26/README-files/hpux/
DBD-Oracle-1.26/README-files/hpux/Conf-Lincoln-1.06
DBD-Oracle-1.26/README-files/hpux/Conf-Lincoln-1.07
DBD-Oracle-1.26/README-files/hpux/Conf-Merijn-580-10.20-cc
DBD-Oracle-1.26/README-files/hpux/Conf-Merijn-585-11.00-cc
DBD-Oracle-1.26/README-files/hpux/Conf-Merijn-585-11.11-cc
DBD-Oracle-1.26/README-files/hpux/Conf-Merijn-587-11.23-cc
DBD-Oracle-1.26/README-files/hpux/Conf-Merijn-588-10.20-gcc
DBD-Oracle-1.26/README-files/hpux/Conf-Merijn-588-11.00-gcc32
DBD-Oracle-1.26/README-files/hpux/Conf-Merijn-588-11.00-gcc64
DBD-Oracle-1.26/README-files/hpux/Conf-Merijn-588-11.11-gcc32
DBD-Oracle-1.26/README-files/hpux/Conf-Merijn-588-11.11-gcc64
DBD-Oracle-1.26/README-files/hpux/Conf-Merijn-588-11.23-gcc64
DBD-Oracle-1.26/README-files/hpux/Conf-Mike
DBD-Oracle-1.26/README-files/hpux/Conf-Roger
DBD-Oracle-1.26/README-files/hpux/libjava.eml
DBD-Oracle-1.26/README-files/hpux/Makefile-Lincoln
DBD-Oracle-1.26/Oracle.ex/bind.pl
DBD-Oracle-1.26/Oracle.ex/commit.pl
DBD-Oracle-1.26/Oracle.ex/curref.pl
DBD-Oracle-1.26/Oracle.ex/ex.pl
DBD-Oracle-1.26/Oracle.ex/japh
DBD-Oracle-1.26/Oracle.ex/mktable.pl
DBD-Oracle-1.26/Oracle.ex/oradump.pl
DBD-Oracle-1.26/Oracle.ex/proc.pl
DBD-Oracle-1.26/Oracle.ex/README
DBD-Oracle-1.26/Oracle.ex/sql
DBD-Oracle-1.26/Oracle.ex/tabinfo.pl
DBD-Oracle-1.26/lib/DBD/
DBD-Oracle-1.26/lib/DBD/Oracle/
DBD-Oracle-1.26/lib/DBD/Oracle/GetInfo.pm
DBD-Oracle-1.26/lib/DBD/Oracle/Object.pm
DBD-Oracle-1.26/hints/dgux.pl
DBD-Oracle-1.26/hints/macos_bundle.syms
DBD-Oracle-1.26/hints/macos_lib.syms
DBD-Oracle-1.26/hints/macos_syms.pl
DBD-Oracle-1.26/hints/svr4.pl
CPAN: File::Temp loaded ok (v0.22)
CPAN: YAML loaded ok (v0.72)

  CPAN.pm: Going to build T/TI/TIMB/DBD-Oracle-1.26.tar.gz

Using DBI 1.52 (for perl 5.008008 on x86_64-linux-thread-multi)
installed in /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/

Configuring DBD::Oracle for perl 5.008008 on linux (x86_64-linux-thread-multi)

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

  The ORACLE_HOME environment variable value (/usr/lib/oracle/11.2) is
not valid.
  It must be set to hold the path to an Oracle installation directory
  on this machine (or a machine with a compatible architecture).
  For an Instant Client install, the directory should include an sdk
subdirectory.
  See the appropriate README file for your OS for more information.
  ABORTED!
Warning: No success on command[/usr/bin/perl Makefile.PL]
  TIMB/DBD-Oracle-1.26.tar.gz
  /usr/bin/perl Makefile.PL -- NOT OK
Running make test
  Make had some problems, won't test
Running make install
  Make had some problems, won't install
Failed during this command:
 TIMB/DBD-Oracle-1.26.tar.gz                  : writemakefile NO
'/usr/bin/perl Makefile.PL' returned status 512


The "sdk" subdir mentioned above doesn't really exist in the rpm:

  # rpm -ql oracle-instantclient11.2-devel | grep -i sdk
  #

Thank you
Alex

#  perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
  Platform:
    osname=linux, osvers=2.6.18-53.el5, archname=x86_64-linux-thread-multi
    uname='linux builder10.centos.org 2.6.18-53.el5 #1 smp mon nov 12
02:14:55 est 2007 x86_64 x86_64 x86_64 gnulinux '
    config_args='-des -Doptimize=-O2 -g -pipe -Wall
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector
--param=ssp-buffer-size=4 -m64 -mtune=generic -Dversion=5.8.8
-Dmyhostname=localhost -Dperladmin=root@localhost -Dcc=gcc -Dcf_by=Red
Hat, Inc. -Dinstallprefix=/usr -Dprefix=/usr -Dlibpth=/usr/local/lib64
/lib64 /usr/lib64 -Dprivlib=/usr/lib/perl5/5.8.8
-Dsitelib=/usr/lib/perl5/site_perl/5.8.8
-Dvendorlib=/usr/lib/perl5/vendor_perl/5.8.8
-Darchlib=/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi
-Dsitearch=/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi
-Dvendorarch=/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
-Darchname=x86_64-linux-thread-multi -Dvendorprefix=/usr
-Dsiteprefix=/usr -Duseshrplib -Dusethreads -Duseithreads
-Duselargefiles -Dd_dosuid -Dd_semctl_semun -Di_db -Ui_ndbm -Di_gdbm
-Di_shadow -Di_syslog -Dman3ext=3pm -Duseperlio -Dinstallusrbinperl=n
-Ubincompat5005 -Uversiononly -Dpager=/usr/bin/less -isr
-Dd_gethostent_r_proto -Ud_endhostent_r_proto -Ud_sethostent_r_proto
-Ud_endprotoent_r_proto -Ud_setprotoent_r_proto -Ud_endservent_r_proto
-Ud_setservent_r_proto -Dinc_version_list=5.8.7 5.8.6 5.8.5
-Dscriptdir=/usr/bin'
    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=define uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE
-fno-strict-aliasing -pipe -Wdeclaration-after-statement
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-I/usr/include/gdbm',
    optimize='-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
-fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic',
    cppflags='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include
-I/usr/include/gdbm'
    ccversion='', gccversion='4.1.2 20080704 (Red Hat 4.1.2-48)',
gccosandvers=''
    intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
    ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='gcc', ldflags =''
    libpth=/usr/local/lib64 /lib64 /usr/lib64
    libs=-lresolv -lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc
    perllibs=-lresolv -lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
    libc=, so=so, useshrplib=true, libperl=libperl.so
    gnulibc_version='2.5'
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E
-Wl,-rpath,/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE'
    cccdlflags='-fPIC', lddlflags='-shared -O2 -g -pipe -Wall
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector
--param=ssp-buffer-size=4 -m64 -mtune=generic'


Characteristics of this binary (from libperl):
  Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
                        PERL_MALLOC_WRAP USE_64_BIT_ALL USE_64_BIT_INT
                        USE_ITHREADS USE_LARGE_FILES USE_PERLIO
                        USE_REENTRANT_API
  Built under linux
  Compiled at Sep 28 2010 08:50:01
  @INC:
    /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi
    /usr/lib/perl5/site_perl/5.8.8
    /usr/lib/perl5/site_perl
    /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
    /usr/lib/perl5/vendor_perl/5.8.8
    /usr/lib/perl5/vendor_perl
    /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi
    /usr/lib/perl5/5.8.8
    .
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.