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=r...@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
.
