I used the lastest version as stated below.
I gunziped and untarred them in /tmp.
I installed DBI as root. It looked fine.
I installed DB as oracle . It looked fine.
While I run the connect.pl script I get the below error:
#!/usr/bin/perl
use warnings;
use strict;
use DBI;
my $dbh = DBI->connect('dbi:Oracle:orcl11g', 'HR','oracle');
die "connect failed: " . DBI->errstr() unless $dbh;
print "connect successful!\n";
$dbh->disconnect();
error:
$perl connect.pl
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC
(@INC contains:
/usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2
/usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0 /
usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5.8.4
/usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl/5.8.2 /usr/lib/perl5/vendor_perl/5.8.1
/usr/lib/perl5/vendor_perl/5.8.0
/usr/lib/perl5/vendor_perl .) at (eval 3) line 3.
Perhaps the DBD::Oracle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge.
at connect.pl line 7
thanks.
On Thu, Feb 5, 2009 at 5:52 AM, John Scoles <[email protected]> wrote:
> If you are using Oracle EE 11.1.0.7.0 I would go with the latest version of
> each DBI 1.607 and DBD::Oracle 1.22.
>
> So far there has been a few issues with ee 11 (solaris systems mainly) but
> nothing that would stop you from using it.
> cheers
> John Scoles
>
> David Ehresmann wrote:
>>
>> List ,
>>
>> I want to install the DBI module on my linux server. It is not
>> connected to a network.
>>
>> I am using Oracle EE 11g 11.1.0.7.0 and Red Hat Linux ES 4.
>>
>> My perl home is /usr/lib/perl.
>>
>> Which version of DBI and DBD::oracle do I use?
>>
>> I can go to this website: http://search.cpan.org/~timb/ and view the
>> modules ( or bundles ).
>> Which DBI version do I need, i.e. DBI 1.??
>> Which DBD::oracle driver do I need 1.17 thru 1.21?
>>
>> Any pointers are appreciated!
>>
>> Thanks.
>>
>>
>>
>> If I type perl -v and perl -V below are the output.
>>
>> $perl -v
>>
>> This is perl, v5.8.5 built for i386-linux-thread-multi
>>
>>
>> $perl -V
>> Summary of my perl5 (revision 5 version 8 subversion 5) configuration:
>> Platform:
>> osname=linux, osvers=2.4.21-25.elsmp, archname=i386-linux-thread-multi
>> uname='linux porky.build.redhat.com 2.4.21-25.elsmp #1 smp fri nov
>> 12 21:34:51 est 2004 i686 i686 i386 gnulinux '
>> config_args='-des -Doptimize=-O2 -g -pipe -m32 -march=i386
>> -mtune=pentium4 -Dversion=5.8.5 -Dmyhostname=localhost
>> -dperladmin=r...@localhost -Dcc=gcc -Dcf_by=Red Hat, Inc.
>> -Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux
>> -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 -Ubincompat5005 -Uversiononly
>> -Dpager=/usr/bin/less -isr -Dinc_version_list=5.8.4 5.8.3 5.8.2 5.8.1
>> 5.8.0'
>> 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=undef use64bitall=undef uselongdouble=undef
>> usemymalloc=n, bincompat5005=undef
>> Compiler:
>> cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING
>> -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
>> -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm',
>> optimize='-O2 -g -pipe -m32 -march=i386 -mtune=pentium4',
>> cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING
>> -fno-strict-aliasing -pipe -I/usr/local/include -I/usr/include/gdbm'
>> ccversion='', gccversion='3.4.3 20041125 (Red Hat 3.4.3-6.EL4)',
>> gccosandvers=''
>> intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
>> d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
>> ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
>> lseeksize=8
>> alignbytes=4, prototype=define
>> Linker and Libraries:
>> ld='gcc', ldflags =' -L/usr/local/lib'
>> libpth=/usr/local/lib /lib /usr/lib
>> libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc
>> perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
>> libc=/lib/libc-2.3.3.so, so=so, useshrplib=true, libperl=libperl.so
>> gnulibc_version='2.3.3'
>> Dynamic Linking:
>> dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E
>> -Wl,-rpath,/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE'
>> cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'
>>
>>
>> Characteristics of this binary (from libperl):
>> Compile-time options: DEBUGGING MULTIPLICITY USE_ITHREADS
>> USE_LARGE_FILES PERL_IMPLICIT_CONTEXT
>> Built under linux
>> Compiled at Dec 1 2004 14:28:51
>> @INC:
>> /usr/lib/perl5/5.8.5/i386-linux-thread-multi
>> /usr/lib/perl5/5.8.5
>> /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
>> /usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
>> /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
>> /usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi
>> /usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
>> /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
>> /usr/lib/perl5/site_perl/5.8.5
>> /usr/lib/perl5/site_perl/5.8.4
>> /usr/lib/perl5/site_perl/5.8.3
>> /usr/lib/perl5/site_perl/5.8.2
>> /usr/lib/perl5/site_perl/5.8.1
>> /usr/lib/perl5/site_perl/5.8.0
>> /usr/lib/perl5/site_perl
>> /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
>> /usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
>> /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
>> /usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi
>> /usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
>> /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
>> /usr/lib/perl5/vendor_perl/5.8.5
>> /usr/lib/perl5/vendor_perl/5.8.4
>> /usr/lib/perl5/vendor_perl/5.8.3
>> /usr/lib/perl5/vendor_perl/5.8.2
>> /usr/lib/perl5/vendor_perl/5.8.1
>> /usr/lib/perl5/vendor_perl/5.8.0
>> /usr/lib/perl5/vendor_perl
>> .
>>
>
