Can't load Oracle.so for module DBD::Oracle
来源:互联网 发布:java exe软件安装路径 编辑:程序博客网 时间:2024/05/20 10:13
在使用perl连接数据库的时候出现错误如下:
如果是在oracle用户下执行没有问题,初步怀疑是环境变量配置关系
[oracle@test ~]$ more /Application/monitor/noc/db.pool
install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for mod
ule DBD::Oracle: libclntsh.so.10.1: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thr
ead-multi/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /home/oracle/sbin/mondb.pl line 11
[oracle@test ~]$ ls -l /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so
-r-xr-xr-x 1 root root 489328 Dec 18 13:05 /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so
install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for mod
ule DBD::Oracle: libclntsh.so.10.1: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thr
ead-multi/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /home/oracle/sbin/mondb.pl line 11
[oracle@test ~]$ ls -l /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so
-r-xr-xr-x 1 root root 489328 Dec 18 13:05 /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so
最后的解决方案如下:
# echo /u01/app/oracle/product/10.2.0/db_1/lib >> /etc/ld.so.conf
# echo /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle >> /etc/ld.so.conf
# ldconfig
# ldd /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so
查看lib包的相关性是否正常
# echo /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle >> /etc/ld.so.conf
# ldconfig
# ldd /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so
查看lib包的相关性是否正常
然后在perl脚本中加入环境变量
$ENV{'ORACLE_HOME'} = '/u01/app/oracle/product/10.2.0/db_1';
$ENV{'LD_LIBRARY_PATH'} = '/u01/app/oracle/product/10.2.0/db_1/lib';
注:一定要先配好oracle监听,在shell脚本中export ORACLE_HOME="xxxxxx"$ENV{'ORACLE_HOME'} = '/u01/app/oracle/product/10.2.0/db_1';
$ENV{'LD_LIBRARY_PATH'} = '/u01/app/oracle/product/10.2.0/db_1/lib';
- Can't load Oracle.so for module DBD::Oracle
- install_driver(Oracle) failed: Can't load `.../DBD/Oracle/Oracle.so' for module DBD::Oracle
- install_driver(Oracle) failed: Can't load `.../DBD/Oracle/Oracle.so' for module DBD::Oracle
- install_driver(Oracle) failed: Can't load `.../DBD/Oracle/Oracle.so' for module DBD::Oracle
- install_driver(Oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so'
- Can't load '/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for modu
- Can't load mysql.so
- install_driver oracle failed can't locate dbd/oracle.pm in @inc
- Can't load ...Magick.so错误解决
- can't load library 'libstdc++.so.6'
- oracle安装报:can't find libjava.so
- toad for oracle 出现Can't initialize OCI. Error -1
- /bin/thttpd: can't load library 'libcrypt.so.0问题解决
- openwrt运行提示 can't load library 'librt.so.0'
- 关于perl中DBD for Oracle的安装
- navicat 客户端连接oracle数据库 异常处理 can't load oci dll 和 Instant Client package...
- 遇到问题----------安装DBD:mysql时报错install_driver(mysql) failed: Can't load '/usr/lib64/perl5/site_perl/5.8
- Can't load library Android:No implementation found for native
- UIViewController中loadView的用法(应当注意的几点)
- h264图像宽度和高度
- 感慨舰载机降落成功
- <a> <img> css
- 删除表中重复数据
- Can't load Oracle.so for module DBD::Oracle
- 取得文件路径 MFC 在界面 按钮
- Procedural Timing Control (of Verilog HDL)
- 动态规划-最长上升子序列(LIS)
- 46
- 如何获得更多的可用分
- SVN的错误:Error: Can't connect to host '': 由于目标机器积极拒绝,无法连接。
- spring 3 事务例子
- VC调试方法大全