http://www.perlmonks.org?node_id=324837

sparkyichi has asked for the wisdom of the Perl Monks concerning the following question:

I just installed Fedora core1 and installed the latest version of the DBI module. When I they to connect to an Oracle Database on another server(there is no local install of oracle on the server) I get an install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (see the bottom for the full error.) So then I download the DBD::Oracle module and install it but I get this error when I do the perl Makefile.PL: Multiple copies of Driver.xst found in:....(see the bottom for the full error.)

I think I'm having an oracle driver problem but I do not know how to solve it. Any suggestions?

Sparky

Detailed Errors section>>>>
Script Error:
$ perl -w dbtest.pl install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@IN +C contains: /usr/lib/perl5/5.8.1/i386-linux-thread-multi /usr/lib/per +l5/5.8.1 /usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi /usr/ +lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl /usr/lib/perl5/ven +dor_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8 +.1 /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/ +perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8 +.1/i386-linux-thread-multi /usr/lib/perl5/5.8.1 .) at (eval 1) line 3 +. Perhaps the DBD::Oracle perl module hasn't been fully installed, or perhaps the capitalisation of 'Oracle' isn't right. Available drivers: ExampleP, Pg, Proxy, Sponge, mysql. at dbtest.pl line 7


DBI::Oracle installation Error:
# perl Makefile.PL<BR> Multiple copies of Driver.xst found in: /usr/lib/perl5/site_perl/5.8.1 +/i386-linux-thread-multi/auto/DBI /usr/lib/perl5/vendor_perl/5.8.0/i3 +86-linux-thread-multi/auto/DBI at Makefile.PL line 37 Using DBI 1.40 (for perl 5.008001 on i386-linux-thread-multi) installe +d in /usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi/auto/DBI Configuring DBD::Oracle ... >>> Remember to actually *READ* the README file! Especially if you have any problems. The ORACLE_HOME environment variable must be set. 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 README.clients file for more information. ABORTED!
Sparky
FMTEYEWTK

Replies are listed 'Best First'.
Re: Fedora DBI Oracle install help
by perrin (Chancellor) on Jan 29, 2004 at 05:03 UTC
    The install message is not a problem, just a warning telling you that you have some stuff from your old Perl installation hanging around. The real problem is that you didn't set the ORACLE_HOME environment variable before trying to run Makefile.PL.
Re: Fedora DBI Oracle install help
by rdfield (Priest) on Jan 29, 2004 at 10:25 UTC
    You'll need to install the Oracle Client software on your local machine.

    rdfield