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

On 06/12/10 20:32, Alexander Farber wrote:
> 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

<snipped unpacking>

> 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.

Is /usr/lib/oracle/11.2 where you really unzipped/installed the instant client? because DBD::Oracle does not recognise this path as containing the instant client.


>   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

I don't use rpms to install instant client and it works fine.
You need the sdk.

You could try downloading the zip versions and unzipping them somewhere and point LD_LIBRARY_PATH to the unzip dir - I don't think you need to set ORACLE_HOME with DBD::Oracle and instant client and in some rare cases it actually breaks the install.
 

> #  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
>     .

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com