perl 无法在@INC中找到DBD/Oracle.pm

yrdbyhpb  于 2022-11-15  发布在  Perl
关注(0)|答案(4)|浏览(174)

我尝试通过DBI连接到Oracle,但无法正常工作。
我的设置:

# cat /proc/version 
Linux version 2.6.18-194.el5 (mockbuild@ca-build10.us.oracle.com) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-48)) #1 SMP Mon Mar 29 20:06:41 EDT 2010
# uname -i 
i386
# perl -v 
This is perl, v5.8.8 built for i386-linux-thread-multi 
<...>
# echo $ORACLE_HOME
/usr/lib/oracle/12.1/client

我正在尝试使用此脚本进行连接:

#!/usr/bin/perl
# dbi.pl
use warnings;
use strict;
use DBI;

$ENV{ORACLE_HOME}="/usr/lib/oracle/12.1";
$ENV{LD_LIBRARY_PATH}="/usr/lib/oracle/12.1/client/lib";
$ENV{NLS_LANG}="american_america.CL8MSWIN1251";

my $user='user';
my $pw='pw';
my $host='servername';
my $port='1521';
my $SID = 'SID';
my $source = "dbi:Oracle:$host;sid=$SID;port=$port";

my $dbh=DBI->connect($source,$user,$pw,{PrintError=>0,AutoCommit=>0,RaiseError=>1}) or die "Oracle:$DBI::errstr\n";

当我尝试执行它时,我得到一个错误:

#  ./dbi.pl
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 .) 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, Proxy, Sponge, mysql.
 at ./dbi.pl line 21

我尝试重新安装DBD-Oracle:

root@hostname:/tmp/DBD-Oracle-1.66# perl Makefile.PL
Using DBI 1.52 (for perl 5.008008 on i386-linux-thread-multi) installed in /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBI/

Configuring DBD::Oracle for perl 5.008008 on linux (i386-linux-thread-multi)

Remember to actually *READ* the README file! Especially if you have any problems.

Installing on a linux, Ver#2.6
Using Oracle in /usr/lib/oracle/12.1/client
DEFINE _SQLPLUS_RELEASE = "1201000100" (CHAR)
Oracle version 12.1.0.1 (12.1)

        Unable to locate an oracle.mk or other suitable *.mk
        file in your Oracle installation.  (I looked in
        /usr/lib/oracle/12.1/client/rdbms/demo/demo_xe.mk /usr/lib/oracle/12.1/client/rdbms/demo/demo_rdbms32.mk /usr/lib/oracle/12.1/client/rdbms/demo/demo_rdbms.mk /usr/lib/oracle/12.1/client/rdbms/lib/ins_rdbms.mk /usr/share/oracle/12.1/client/demo.mk under /usr/lib/oracle/12.1/client)

        The oracle.mk (or demo_rdbms.mk) file is part of the Oracle
        RDBMS product.  You need to build DBD::Oracle on a
        system which has one of these Oracle components installed.
        (Other *.mk files such as the env_*.mk files will not work.)
        Alternatively you can use Oracle Instant Client.

        In the unlikely event that a suitable *.mk file is installed
        somewhere non-standard you can specify where it is using the -m option:
                perl Makefile.PL -m /path/to/your.mk

        See the appropriate README file for your OS for more information and some alternatives.

     at Makefile.PL line 1187.
root@hostname:/tmp/DBD-Oracle-1.66#  ls /usr/lib/oracle/12.1/client/
total 8.0K
drwxr-xr-x 2 root root 4.0K Sep 24 13:23 bin/
drwxr-xr-x 2 root root 4.0K Sep 24 13:23 lib/
root@hostname:/tmp/DBD-Oracle-1.66#

所以,我没有这个'rdbms'目录,因为我安装了instantclient。有没有什么方法可以让它在不安装数据库的情况下工作?

dgsult0t

dgsult0t1#

最近完整的Oracle数据库安装没有安装DBD::Oracle所需的所有位。很抱歉,我不记得您需要安装的可选位的名称。但是,一个替代方法(也是一个更简单的方法)是下载Oracle即时客户端“basic”、“sdk”和“sqlplus”,将它们解压缩到某个地方,并将LD_LIBRARY_PATH指向该位置。它还使您独立于当前的Oracle数据库安装,这意味着如果您的dba升级了它(或它的一部分),您不需要考虑重建DBD::Oracle。
顺便说一句,在perl脚本中设置LD_LIBRARY_PATH是行不通的--太晚了。

t30tvxxf

t30tvxxf2#

在我的情况下,这解决了问题:

perl -MCPAN -e shell
      get DBD::Oracle
      quit

     cd ~/.cpan/build/DBD-Oracle***
     export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
     export ORACLE_HOME=/usr/lib/oracle/11.2/client64/
     perl Makefile.PL
     make
        make install
yjghlzjz

yjghlzjz3#

解决方法:数据库驱动器::Oracle

jdzmm42g

jdzmm42g4#

你好,你设置了LD_LIBRARY_PATH吗?根据docs,Makefile.PL现在应该可以和即时客户端一起工作了,但是这是我看到的唯一一个你没有遵循的选项(或者至少表明你遵循了)。

相关问题