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