Can't load Oracle.so for module DBD::Oracle

在使用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

最后的解决方案如下：

# 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包的相关性是否正常

然后在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"