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遍,没找到合适的答案,忘高手指点一下!
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
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28