安装perl 的DBD::Oracle,一直报错

majia_520

一、1. 采用cpan的方式安装，失败，安装过程在http://www.weipengpeng.com/bbs/forum.php?mod=viewthread&tid=141&extra=page%3D1
Your LD_LIBRARY_PATH env var is set to ''
WARNING: Your LD_LIBRARY_PATH env var doesn't include '/u01/app/oracle/product/10.2.0/client_1/lib' but probably needs to.

2. 设置环境变量LD_LIBRARY_PATH后，依然报错，安装过程在http://www.weipengpeng.com/bbs/forum.php?mod=viewthread&tid=142&extra=page%3D1

二、下载，安装，参考资料：http://news.bangkaow.com/news/20110530/176736.html
该文没有做make test，我也跟着没有做，直接make install了，貌似安装成功了，但是在程序中调用DBD::Oracle时，出错。

三、再回头去准备用cpan install，结果:
[root@ftpsvr get_wm]# cpan install DBD::Oracle
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
  Database was generated on Sun, 24 Jul 2011 23:27:17 GMT
install is up to date.
DBD::Oracle is up to date.
[root@ftpsvr get_wm]#

四、想想，先卸载掉吧，于是回到安装目录/tmp/DBD-Oracle-1.28去，执行make uninstall
结果：
Uninstall is unsafe and deprecated, the uninstallation was not performed.
We will show what would have been done.

unlink /usr/bin/ora_explain
unlink /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBD/Oracle.pm
unlink /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBD/Oracle/GetInfo.pm
unlink /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBD/Oracle/Object.pm
unlink /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Oraperl.pm
unlink /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.bs
unlink /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.h
unlink /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so
unlink /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/dbdimp.h
unlink /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/mk.pm
unlink /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/ocitrace.h
unlink /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/oraperl.ph
unlink /usr/share/man/man1/ora_explain.1
unlink /usr/share/man/man3/DBD::Oracle.3pm
unlink /usr/share/man/man3/DBD::Oraperl.3pm
unlink /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/.packlist

Uninstall is unsafe and deprecated, the uninstallation was not performed.
Please check the list above carefully, there may be errors.
Remove the appropriate files manually.
Sorry for the inconvenience.

五、 再去cpan install DBD::Oracle 还是提示已经安装。

问题:

怎么才能完整地把DBD::Oracle装上呢？

majia_520

哇。。。。我好可怜啊，怎么没人来踩我啊

majia_520

ideaz

1、安装oracle-instantclient安装包，oracle官网下载basic、devel、sqlplus三个rpm包。
2、rpm -ivh oracle-instantclient*.rpm
3、echo '/usr/lib/oracle/11.1/client/lib' > /etc/ld.so.conf.d/oracle_client.conf; /sbin/ldconfig
4、测试 sqlplus username/password@ip:port/sid
5、正常安装 DBI-1.616.tar.gz
6、正常安装 DBD-Oracle-1.28.tar.gz

打完收工。

majia_520

1、安装oracle-instantclient安装包，oracle官网下载basic、devel、sqlplus三个rpm包。
2、rpm -ivh oracl ...
ideaz 发表于 2011-07-26 22:30

我已经安装好了Oracle 客户端了，还需要instantclient?

majia_520

回复 4# ideaz


    6、正常安装 DBD-Oracle-1.28.tar.gz

这一步时，make test一直出错。

majia_520

echo '/usr/lib/oracle/11.2/client64/lib' > /etc/ld.so.conf.d/oracle_client.conf; /sbin/ldconfig

majia_520

Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: /u01/app/oracle/product/10.2.0/client_1/lib/libnnz10.so:

majia_520

[root@ftpsvr Oracle]# pwd
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle
[root@ftpsvr Oracle]# ll
total 760
-r--r--r-- 1 root root  16335 Mar 21 01:25 dbdimp.h
-r--r--r-- 1 root root  25093 Jul 27 08:35 mk.pm
-r--r--r-- 1 root root  24322 Dec 19  2010 ocitrace.h
-r--r--r-- 1 root root      0 Jul 26 09:48 Oracle.bs
-r--r--r-- 1 root root   4441 Dec 18  2010 Oracle.h
-r-xr-xr-x 1 root root 668303 Jul 27 08:36 Oracle.so
[root@ftpsvr Oracle]#

majia_520

Can't load '/root/.cpanplus/5.8.8/build/DBD-Oracle-1.28/blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: /u01/app/oracle/product/10.2.0/client_1/lib/libnnz10.so: cannot restore segment prot after reloc: Permission denied at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.