Skip Menu |

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 63678
Status: resolved
Priority: 0/
Queue: DBD-Oracle
People
Owner: Nobody in particular
Requestors: alexander.farber [...] gmail.com
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Mon Dec 06 15:33:07 2010 alexander.farber [...] gmail.com - Ticket created
CC: dbi-dev [...] perl.org
Subject: DBD::Oracle 1.26 does not install with CentOS/RHEL 5.5 and OIC 11.2
Date: Mon, 6 Dec 2010 21:32:54 +0100
To: bug-DBD-Oracle [...] rt.cpan.org
From: Alexander Farber <alexander.farber [...] 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 .
  Fri Dec 17 10:24:39 2010 bohica [...] ntlworld.com - Correspondence added
On Mon Dec 06 15:33:07 2010, alexander.farber@gmail.com wrote: Show quoted text
> 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 >
.....................................--------------------------------------- <snipped unpacking> Show quoted text
> 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. Show quoted text
> 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 >
<snipped perl -V> 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. Martin -- Martin J. Evans Wetherby, UK
  Fri Dec 17 10:24:40 2010 The RT System itself - Status changed from 'new' to 'open'
  Fri Dec 17 10:37:34 2010 farber [...] cpan.org - Correspondence added
Hello, On Fri Dec 17 10:24:39 2010, MJEVANS wrote: Show quoted text
> On Mon Dec 06 15:33:07 2010, alexander.farber@gmail.com wrote:
> > 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
Show quoted text
> 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.
I've just installed the above rpm packages. They have the following contents and maybe DBD::Oracle misses a dir called "sdk" there? # rpm -ql oracle-instantclient11.2-basic /usr/lib/oracle/11.2/client64/bin/adrci /usr/lib/oracle/11.2/client64/bin/genezi /usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 /usr/lib/oracle/11.2/client64/lib/libnnz11.so /usr/lib/oracle/11.2/client64/lib/libocci.so.11.1 /usr/lib/oracle/11.2/client64/lib/libociei.so /usr/lib/oracle/11.2/client64/lib/libocijdbc11.so /usr/lib/oracle/11.2/client64/lib/ojdbc5.jar /usr/lib/oracle/11.2/client64/lib/ojdbc6.jar /usr/lib/oracle/11.2/client64/lib/xstreams.jar # rpm -ql oracle-instantclient11.2-devel /usr/include/oracle/11.2/client64/ldap.h /usr/include/oracle/11.2/client64/nzerror.h /usr/include/oracle/11.2/client64/nzt.h /usr/include/oracle/11.2/client64/occi.h /usr/include/oracle/11.2/client64/occiAQ.h /usr/include/oracle/11.2/client64/occiCommon.h /usr/include/oracle/11.2/client64/occiControl.h /usr/include/oracle/11.2/client64/occiData.h /usr/include/oracle/11.2/client64/occiObjects.h /usr/include/oracle/11.2/client64/oci.h /usr/include/oracle/11.2/client64/oci1.h /usr/include/oracle/11.2/client64/oci8dp.h /usr/include/oracle/11.2/client64/ociap.h /usr/include/oracle/11.2/client64/ociapr.h /usr/include/oracle/11.2/client64/ocidef.h /usr/include/oracle/11.2/client64/ocidem.h /usr/include/oracle/11.2/client64/ocidfn.h /usr/include/oracle/11.2/client64/ociextp.h /usr/include/oracle/11.2/client64/ocikpr.h /usr/include/oracle/11.2/client64/ocixmldb.h /usr/include/oracle/11.2/client64/ocixstream.h /usr/include/oracle/11.2/client64/odci.h /usr/include/oracle/11.2/client64/oratypes.h /usr/include/oracle/11.2/client64/ori.h /usr/include/oracle/11.2/client64/orid.h /usr/include/oracle/11.2/client64/orl.h /usr/include/oracle/11.2/client64/oro.h /usr/include/oracle/11.2/client64/ort.h /usr/include/oracle/11.2/client64/xa.h /usr/lib/oracle/11.2/client64/lib/libclntsh.so /usr/lib/oracle/11.2/client64/lib/libocci.so /usr/lib/oracle/11.2/client64/lib/ottclasses.zip /usr/share/oracle/11.2/client64/cdemo81.c /usr/share/oracle/11.2/client64/demo.mk /usr/share/oracle/11.2/client64/occidemo.sql /usr/share/oracle/11.2/client64/occidemod.sql /usr/share/oracle/11.2/client64/occidml.cpp /usr/share/oracle/11.2/client64/occiobj.cpp /usr/share/oracle/11.2/client64/occiobj.typ /usr/share/oracle/11.2/client64/ott # rpm -ql oracle-instantclient11.2-sqlplus /usr/bin/sqlplus64 /usr/lib/oracle/11.2/client64/bin/sqlplus /usr/lib/oracle/11.2/client64/lib/glogin.sql /usr/lib/oracle/11.2/client64/lib/libsqlplus.so /usr/lib/oracle/11.2/client64/lib/libsqlplusic.so # export|grep -i ora declare -x LD_LIBRARY_PATH="/usr/lib/oracle/11.2/client64/lib" declare -x ORACLE_HOME="/usr/lib/oracle/11.2" declare -x ORACLE_PATH="/etc" declare -x PATH="/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/afarber/bin:/sbin:/usr/lib/oracle/11.2/client64/bin" Show quoted text
>
> > 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.
Show quoted text
> <snipped perl -V> > > 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.
Ok, thanks. My workaround is to use PHP for this project for now. Regards Alex
  Fri Dec 17 11:16:55 2010 bohica [...] ntlworld.com - Correspondence added
On Fri Dec 17 10:37:34 2010, FARBER wrote: Show quoted text
> Hello, > > On Fri Dec 17 10:24:39 2010, MJEVANS wrote:
> > On Mon Dec 06 15:33:07 2010, alexander.farber@gmail.com wrote:
> > > 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
>
> > 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.
> > I've just installed the above rpm packages. > They have the following contents and maybe > DBD::Oracle misses a dir called "sdk" there?
Yes, very much so. Show quoted text
> # rpm -ql oracle-instantclient11.2-basic > /usr/lib/oracle/11.2/client64/bin/adrci > /usr/lib/oracle/11.2/client64/bin/genezi > /usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 > /usr/lib/oracle/11.2/client64/lib/libnnz11.so > /usr/lib/oracle/11.2/client64/lib/libocci.so.11.1 > /usr/lib/oracle/11.2/client64/lib/libociei.so > /usr/lib/oracle/11.2/client64/lib/libocijdbc11.so > /usr/lib/oracle/11.2/client64/lib/ojdbc5.jar > /usr/lib/oracle/11.2/client64/lib/ojdbc6.jar > /usr/lib/oracle/11.2/client64/lib/xstreams.jar > > # rpm -ql oracle-instantclient11.2-devel > /usr/include/oracle/11.2/client64/ldap.h > /usr/include/oracle/11.2/client64/nzerror.h > /usr/include/oracle/11.2/client64/nzt.h > /usr/include/oracle/11.2/client64/occi.h > /usr/include/oracle/11.2/client64/occiAQ.h > /usr/include/oracle/11.2/client64/occiCommon.h > /usr/include/oracle/11.2/client64/occiControl.h > /usr/include/oracle/11.2/client64/occiData.h > /usr/include/oracle/11.2/client64/occiObjects.h > /usr/include/oracle/11.2/client64/oci.h > /usr/include/oracle/11.2/client64/oci1.h > /usr/include/oracle/11.2/client64/oci8dp.h > /usr/include/oracle/11.2/client64/ociap.h > /usr/include/oracle/11.2/client64/ociapr.h > /usr/include/oracle/11.2/client64/ocidef.h > /usr/include/oracle/11.2/client64/ocidem.h > /usr/include/oracle/11.2/client64/ocidfn.h > /usr/include/oracle/11.2/client64/ociextp.h > /usr/include/oracle/11.2/client64/ocikpr.h > /usr/include/oracle/11.2/client64/ocixmldb.h > /usr/include/oracle/11.2/client64/ocixstream.h > /usr/include/oracle/11.2/client64/odci.h > /usr/include/oracle/11.2/client64/oratypes.h > /usr/include/oracle/11.2/client64/ori.h > /usr/include/oracle/11.2/client64/orid.h > /usr/include/oracle/11.2/client64/orl.h > /usr/include/oracle/11.2/client64/oro.h > /usr/include/oracle/11.2/client64/ort.h > /usr/include/oracle/11.2/client64/xa.h > /usr/lib/oracle/11.2/client64/lib/libclntsh.so > /usr/lib/oracle/11.2/client64/lib/libocci.so > /usr/lib/oracle/11.2/client64/lib/ottclasses.zip > /usr/share/oracle/11.2/client64/cdemo81.c > /usr/share/oracle/11.2/client64/demo.mk > /usr/share/oracle/11.2/client64/occidemo.sql > /usr/share/oracle/11.2/client64/occidemod.sql > /usr/share/oracle/11.2/client64/occidml.cpp > /usr/share/oracle/11.2/client64/occiobj.cpp > /usr/share/oracle/11.2/client64/occiobj.typ > /usr/share/oracle/11.2/client64/ott > > # rpm -ql oracle-instantclient11.2-sqlplus > /usr/bin/sqlplus64 > /usr/lib/oracle/11.2/client64/bin/sqlplus > /usr/lib/oracle/11.2/client64/lib/glogin.sql > /usr/lib/oracle/11.2/client64/lib/libsqlplus.so > /usr/lib/oracle/11.2/client64/lib/libsqlplusic.so > > # export|grep -i ora > declare -x LD_LIBRARY_PATH="/usr/lib/oracle/11.2/client64/lib" > declare -x ORACLE_HOME="/usr/lib/oracle/11.2" > declare -x ORACLE_PATH="/etc" > declare -x >
PATH="/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/afarber/bin:/ sbin:/usr/lib/oracle/11.2/client64/bin" Show quoted text
>
> >
> > > 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.
>
> > <snipped perl -V> > > > > 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.
> > Ok, thanks. My workaround is to use PHP for this project for now.
And did PHP's version of DBD::Oracle build with the same tree above? Show quoted text
> Regards > Alex
Thanks for the rpm contents. Martin -- Martin J. Evans Wetherby, UK
  Fri Dec 17 11:34:22 2010 farber [...] cpan.org - Correspondence added
On Fri Dec 17 11:16:55 2010, MJEVANS wrote: Show quoted text
> On Fri Dec 17 10:37:34 2010, FARBER wrote:
Show quoted text
> > > > 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
Show quoted text
> > > 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.
> > > > Ok, thanks. My workaround is to use PHP for this project for now.
> > And did PHP's version of DBD::Oracle build with the same tree above?
Yes, PHP OIC and sqlplus both work ok with the rpms: # pecl list Installed packages, channel pecl.php.net: ========================================= Package Version State oci8 1.4.4 stable xdebug 2.1.0 stable You mentioned using OIC zips instead of rpms. Have you created a dir called "sdk" there? Regards Alex
  Fri Dec 17 11:41:33 2010 bohica [...] ntlworld.com - Correspondence added
On Fri Dec 17 11:34:22 2010, FARBER wrote: Show quoted text
> On Fri Dec 17 11:16:55 2010, MJEVANS wrote:
> > On Fri Dec 17 10:37:34 2010, FARBER wrote:
>
> > > > > 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
>
> > > > 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 Show quoted text
> > > to
> > > > set ORACLE_HOME with DBD::Oracle and instant client and in some
rare Show quoted text
> > > > cases it actually breaks the install.
> > > > > > Ok, thanks. My workaround is to use PHP for this project for now.
> > > > And did PHP's version of DBD::Oracle build with the same tree above?
> > Yes, PHP OIC and sqlplus both work ok with the rpms: > > # pecl list > Installed packages, channel pecl.php.net: > ========================================= > Package Version State > oci8 1.4.4 stable > xdebug 2.1.0 stable
Thanks, that is useful to know. Show quoted text
> You mentioned using OIC zips instead of rpms. > Have you created a dir called "sdk" there?
oh, yes: martin@bragi:/tmp/p$ unzip /home/martin/Desktop/oracle11/instantclient- sdk-linux32-11.2.0.1.zip Archive: /home/martin/Desktop/oracle11/instantclient-sdk-linux32- 11.2.0.1.zip creating: instantclient_11_2/sdk/ creating: instantclient_11_2/sdk/include/ inflating: instantclient_11_2/sdk/include/occi.h inflating: instantclient_11_2/sdk/include/occiCommon.h inflating: instantclient_11_2/sdk/include/occiControl.h inflating: instantclient_11_2/sdk/include/occiData.h inflating: instantclient_11_2/sdk/include/occiObjects.h inflating: instantclient_11_2/sdk/include/occiAQ.h inflating: instantclient_11_2/sdk/include/oci.h inflating: instantclient_11_2/sdk/include/oci1.h inflating: instantclient_11_2/sdk/include/oci8dp.h inflating: instantclient_11_2/sdk/include/ociap.h inflating: instantclient_11_2/sdk/include/ociapr.h inflating: instantclient_11_2/sdk/include/ocidef.h inflating: instantclient_11_2/sdk/include/ocidem.h inflating: instantclient_11_2/sdk/include/ocidfn.h inflating: instantclient_11_2/sdk/include/ociextp.h inflating: instantclient_11_2/sdk/include/ocikpr.h inflating: instantclient_11_2/sdk/include/ocixmldb.h inflating: instantclient_11_2/sdk/include/ocixstream.h inflating: instantclient_11_2/sdk/include/odci.h inflating: instantclient_11_2/sdk/include/oratypes.h inflating: instantclient_11_2/sdk/include/ori.h inflating: instantclient_11_2/sdk/include/orid.h inflating: instantclient_11_2/sdk/include/orl.h inflating: instantclient_11_2/sdk/include/oro.h inflating: instantclient_11_2/sdk/include/ort.h inflating: instantclient_11_2/sdk/include/xa.h inflating: instantclient_11_2/sdk/include/nzt.h inflating: instantclient_11_2/sdk/include/nzerror.h inflating: instantclient_11_2/sdk/include/ldap.h creating: instantclient_11_2/sdk/demo/ inflating: instantclient_11_2/sdk/demo/demo.mk inflating: instantclient_11_2/sdk/demo/cdemo81.c inflating: instantclient_11_2/sdk/demo/occidemo.sql inflating: instantclient_11_2/sdk/demo/occidemod.sql inflating: instantclient_11_2/sdk/demo/occidml.cpp inflating: instantclient_11_2/sdk/demo/occiobj.cpp inflating: instantclient_11_2/sdk/demo/occiobj.typ inflating: instantclient_11_2/sdk/SDK_README extracting: instantclient_11_2/sdk/ottclasses.zip inflating: instantclient_11_2/sdk/ott Martin -- Martin J. Evans Wetherby, UK
  Fri Dec 17 11:48:46 2010 bohica [...] ntlworld.com - Correspondence added
Would you be prepared to try again but setting LD_LIBRARY_PATH to /usr/lib/oracle/11.2/client64 and exporting it before attempting to install DBD::Oracle. $ export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64 I don't have an RPM based system so I cannot try this myself. Thanks Martin -- Martin J. Evans Wetherby, UK
  Fri Dec 17 12:01:54 2010 farber [...] cpan.org - Correspondence added
Sorry if I missed mentioning this - I already have it in my environment: # echo $LD_LIBRARY_PATH /usr/lib/oracle/11.2/client64/lib # export | grep -i ora declare -x LD_LIBRARY_PATH="/usr/lib/oracle/11.2/client64/lib" declare -x ORACLE_HOME="/usr/lib/oracle/11.2" declare -x ORACLE_PATH="/etc" declare -x PATH="/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/afarber/bin:/sbin:/usr/lib/oracle/11.2/client64/bin" And I call: # sudo -E perl -MCPAN -e shell cpan shell -- CPAN exploration and modules installation (v1.9402) ....... 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 cpan[2]> Lockfile removed.
  Fri Dec 17 12:08:46 2010 bohica [...] ntlworld.com - Correspondence added
On Fri Dec 17 12:01:54 2010, FARBER wrote: Show quoted text
> Sorry if I missed mentioning this - > I already have it in my environment: > > # echo $LD_LIBRARY_PATH > /usr/lib/oracle/11.2/client64/lib
but without the /lib on the end. Show quoted text
> # export | grep -i ora > declare -x LD_LIBRARY_PATH="/usr/lib/oracle/11.2/client64/lib" > declare -x ORACLE_HOME="/usr/lib/oracle/11.2" > declare -x ORACLE_PATH="/etc" > declare -x >
PATH="/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/afarber/bin:/ sbin:/usr/lib/oracle/11.2/client64/bin" Show quoted text
> > And I call:
and without ORACLE_HOME set. Martin -- Martin J. Evans Wetherby, UK
  Fri Dec 17 13:04:16 2010 farber [...] cpan.org - Correspondence added
Ok (I don't have root access there, so I use "sudo -E"): # export | grep -i ora declare -x LD_LIBRARY_PATH="/usr/lib/oracle/11.2/client64" declare -x ORACLE_PATH="/etc" # ll /etc/tnsnames.ora -rw-r--r-- 1 root root 195 Dec 6 13:45 /etc/tnsnames.ora # echo $LD_LIBRARY_PATH /usr/lib/oracle/11.2/client64 # 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 Fri, 17 Dec 2010 12:35:12 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/3): /home/afarber/.cpan/build/IO-Compress-2.030 DEL(2/3): /home/afarber/.cpan/build/IO-Zlib-1.10 DEL(3/3): /home/afarber/.cpan/build/Archive-Zip-1.30 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. Trying to find an ORACLE_HOME Your LD_LIBRARY_PATH env var is set to '' The ORACLE_HOME environment variable is not set and I couldn't guess it. It must be set to hold the path to an Oracle installation directory on this machine (or a machine with a compatible architecture). 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 Regards Alex
  Fri Dec 17 13:16:42 2010 bohica [...] ntlworld.com - Correspondence added
On Fri Dec 17 13:04:16 2010, FARBER wrote: Show quoted text
> Ok (I don't have root access there, so I use "sudo -E"): > > # export | grep -i ora > declare -x LD_LIBRARY_PATH="/usr/lib/oracle/11.2/client64" > declare -x ORACLE_PATH="/etc" > # ll /etc/tnsnames.ora > -rw-r--r-- 1 root root 195 Dec 6 13:45 /etc/tnsnames.ora > # echo $LD_LIBRARY_PATH > /usr/lib/oracle/11.2/client64 > > # 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 Fri, 17 Dec 2010 12:35:12 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 >
...................................................................--------- <snipped unpacking> Show quoted text
> 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. > > Trying to find an ORACLE_HOME > Your LD_LIBRARY_PATH env var is set to ''
That is weird as it does not think your LD_LIBRARY_PATH is set. I thought -E on sudo was supposed to keep the environment? One last thing to double-check. Can you change the Makefile.PL where it starts: ## Makefile.PL for DBD::Oracle - see README file for more information. # Copyright (c) 1994-2006 Tim Bunce. Ireland. # Copyright (c) 2006-2008 John Scoles (The Pythian Group). Canada. # vim: ts=8:sw=4 BEGIN { $^W = 1 } BEGIN { require 5.006 } use ExtUtils::MakeMaker 5.16, qw(&WriteMakefile $Verbose); use Getopt::Long; use Config; use Cwd; use File::Find; use strict; # This DBI must be installed before we can build a DBD. # For those not using Dynamic loading this means building a # new static perl in the DBI directory by saying 'make perl' # and then using _that_ perl to make this one. use DBI 1.51; use DBI::DBD; # DBD creation tools # Some MakeMaker's forged some FileHandle methods require FileHandle unless defined(&FileHandle::new); BEGIN { if ($^O eq 'VMS') { require vmsish; import vmsish; require VMS::Filespec; import VMS::Filespec; }} and simply add after the above: print $ENV{LD_LIBRARY_PATH}, "\n"; exit 0; You would need to find the dir where cpan shell download DBD::Oracle (or download and untar it yourself) then run sudo -E perl Makefile.PL Show quoted text
> The ORACLE_HOME environment variable is not set and I couldn't > guess it. > It must be set to hold the path to an Oracle installation > directory > on this machine (or a machine with a compatible architecture). > 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 > > > Regards > Alex
I'd also be interested in what: perl -le 'use Config; print $Config{ldlibpthname},"\n";' prints for you. Martin -- Martin J. Evans Wetherby, UK
  Fri Dec 17 13:21:48 2010 farber [...] cpan.org - Correspondence added
Do you want me to put your Makefile.PL into the tarball: # ll /home/afarber/.cpan/sources/authors/id/T/TI/TIMB/ -rw-r--r-- 1 root root 40412 Dec 3 11:37 CHECKSUMS -rw-r--r-- 1 root root 342067 Dec 3 11:37 DBD-Oracle-1.26.tar.gz But then the checksum will fail, no? # export | grep -i ora declare -x LD_LIBRARY_PATH="/usr/lib/oracle/11.2/client64" declare -x ORACLE_PATH="/etc" # perl -le 'use Config; print $Config{ldlibpthname},"\n";' LD_LIBRARY_PATH # sudo -E perl -le 'use Config; print $Config{ldlibpthname},"\n";' LD_LIBRARY_PATH # sudo -E perl -e 'print $ENV{LD_LIBRARY_PATH}' # (variable not set in sudo?)
  Fri Dec 17 13:25:35 2010 farber [...] cpan.org - Correspondence added
Oh, sorry - I see now: # sudo sudo -V Environment variables to remove: LD_* Maybe I'm a bad reporter for this bug...
  Fri Dec 17 13:56:46 2010 bohica [...] ntlworld.com - Correspondence added
On Fri Dec 17 13:25:35 2010, FARBER wrote: Show quoted text
> Oh, sorry - I see now: > > # sudo sudo -V > Environment variables to remove: > LD_* > > Maybe I'm a bad reporter for this bug...
Now, we /may/ be getting somewhere. However, does the sudo -E arg allow environment variables through? I'm not sure from the documentation and I don't use it. What I was suggesting before with the make file change was to simply download DBD::Oracle from CPAN, untar it, cd into the dir (or find it in $HOME/.cpan when cpan shell will have untarred it). Then edit Makefile.PL (as in previous email) and run sudo -E perl Makefile.PL to see if LD_LIBRARY_PATH was seen in the Makefile. The check for the Config var was just to check it was looking for LD_LIBRARY_PATH and not something else on your machine. My suspicion is that LD_LIBRARY_PATH is NOT visible when the cpan shell runs Makefile.PL. Martin -- Martin J. Evans Wetherby, UK
  Fri Dec 17 14:21:13 2010 alexander.farber [...] gmail.com - Correspondence added
Subject: Re: [rt.cpan.org #63678] DBD::Oracle 1.26 does not install with CentOS/RHEL 5.5 and OIC 11.2
Date: Fri, 17 Dec 2010 20:21:03 +0100
To: bug-DBD-Oracle [...] rt.cpan.org
From: Alexander Farber <alexander.farber [...] gmail.com>
Can't get my sudo to pass env. variables... Sorry Martin, I will try it again another day. Have a nice weekend Alex
  Mon Dec 20 09:28:08 2010 alexander.farber [...] gmail.com - Correspondence added
Subject: Re: [rt.cpan.org #63678] DBD::Oracle 1.26 does not install with CentOS/RHEL 5.5 and OIC 11.2
Date: Mon, 20 Dec 2010 15:27:55 +0100
To: bug-DBD-Oracle [...] rt.cpan.org
From: Alexander Farber <alexander.farber [...] gmail.com>

Message body is not shown because it is too large.

  Tue Dec 21 08:03:14 2010 bohica [...] ntlworld.com - Correspondence added
On Mon Dec 20 09:28:08 2010, alexander.farber@gmail.com wrote: Show quoted text
> Hello, > > I've had 2 another tries, using env to set the variables:
Sorry Alex that we have not got this working. I guess I'm going to have to get my hands on a centos box and install these rpms to see what is going on. The main point is the rpms seem to install a different structure to what you get from the zip files. If you still want to use DBD::Oracle then I'm sure you'll be ok if you get hold of the zip files and unzip them yourself to any directory you like then point LD_LIBRARY_PATH at it and don't set ORACLE_HOME. Martin -- Martin J. Evans Wetherby, UK
  Wed Apr 13 12:32:45 2011 abraxxa [...] cpan.org - Correspondence added
I've installed those three rpms on two RHEL4 boxes yesterday and it works. I've add a /etc/profile.d/oracle.sh containing: export ORACLE_HOME=/usr/lib/oracle/11.2/client if [ -z $LD_LIBRARY_PATH ] then export LD_LIBRARY_PATH=$ORACLE_HOME/lib else export LD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH} fi export SQLPATH=$ORACLE_HOME/lib export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 export TNS_ADMIN=/etc After that logout and login again and install DBD::Oracle again. I'm not sure SQLPATH is needed as I don't have that set on my Debian boxes.
  Mon Nov 26 15:05:04 2012 champoux [...] pythian.com - Correspondence added
That seems to have been more of an install issue rather than a problem with DBD::Oracle itself. Closing.
  Mon Nov 26 15:05:07 2012 champoux [...] pythian.com - Status changed from 'open' to 'resolved'