develooper Front page | perl.dbi.dev | Postings from December 2010

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

Thread Next
From:
Alexander Farber
Date:
December 7, 2010 01:28
Subject:
DBD::Oracle 1.26 does not install with CentOS/RHEL 5.5 and OIC 11.2
Message ID:
AANLkTi=TbkZWLkkoJKKye+qBCyffJvRMucNDES2WtQ6W@mail.gmail.com
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
    .

Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About