+ -
当前位置:首页 → 问答吧 → perl连接ORACLE,很纠结!

perl连接ORACLE,很纠结!

时间:2010-08-18

来源:互联网

cpan> m DBD::Oracle
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
  Database was generated on Tue, 17 Aug 2010 20:32:47 GMT
Module id = DBD::Oracle
    DESCRIPTION  Oracle Driver for DBI
    CPAN_USERID  DBIML (DBI Mailing Lists <[email protected]>)
    CPAN_VERSION 1.24
    CPAN_FILE    P/PY/PYTHIAN/DBD-Oracle-1.24b.tar.gz
    DSLI_STATUS  MmcO (mature,mailing-list,C,object-oriented)
    MANPAGE      DBD::Oracle - Oracle database driver for the DBI module
    INST_FILE    /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBD/Oracle.pm
    INST_VERSION 1.24


[root@leoxqing ~]# ./test.pl
install_driver(Oracle) failed: Can't locate DBD/Oracle/Object.pm in @INC (@INC contains: /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 .) at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBD/Oracle.pm line 20.
BEGIN failed--compilation aborted at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBD/Oracle.pm line 20.
Compilation failed in require at (eval 3) line 3.
Perhaps a module that DBD::Oracle requires hasn't been fully installed
at ./test.pl line 7

测试代码:
#!/usr/bin/perl -w
use DBI;
$dbname="zxsjk";
$user="rm";
$passwd="rpora";
$dbh="";
$dbh = DBI->connect("DBI:Oracle:$dbname",$user,$passwd) or die "can't connect to database ";
$sth=$dbh->prepare("select * from user_tables");
$sth->execute;
while (@recs=$sth->fetchrow_array) {
print $recs[0].":".$recs[1]."\n";
}
$dbh->disconnect;
print "hello \n";

[root@leoxqing ~]# vi /etc/profile
......
export ORACLE_HOME=/opt/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export TNS_ADMIN=/opt/oracle/network/admin


DBD::Oracle客户端装了,ORACLE客户端也装了,环境变量也设置了,为什么执行脚本的时候还通不过呢,很纠结,GOOGLE了N遍,没找到合适的答案,忘高手指点一下!

作者: leoxqing   发布时间: 2010-08-18

加了2个软链接搞定了!重新安装DBD::Oracle就搞定了!

作者: leoxqing   发布时间: 2010-08-18