install_driver(Oracle) failed: Can't load `.../DBD/Oracle/Oracle.so' for module DBD::Oracle

系统管理员 2022-08-08 04:29 110阅读 0赞

#  #

Description

This section is from the "[Practical mod\_perl][Practical mod_perl] " book, by [Stas Bekman][] and [Eric Cholet][] . Also available from Amazon: [Practical mod\_perl][Practical mod_perl 1]

Here's an example of the full error  report that you might see:

>     install_driver(Oracle) failed: Can't load
>     
>     
>     '/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/Oracle/Oracle.so'
>     
>     
>     for module DBD::Oracle:
>     
>     
>     libclntsh.so.8.0: cannot open shared object file: 
>     
>     
>     No such file or directory at
>     
>     
>     /usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 169.
>     
>     
>     at (eval 27) line 3
>     
>     
>     Perhaps a required shared
>     
>     
>     library or dll isn't installed where expected at 
>     
>     
>     /usr/local/apache/perl/tmp.pl line 11

On BSD-style filesystems, LD\_LIBRARY\_PATH is not searched for **setuid** programs. If Apache is a **setuid** executable, you might receive this error. Therefore, the first solution is to explicitly load the library from the system-wide **ldconfig** configuration file:

>     panic# echo $ORACLE_HOME/lib >> /etc/ld.so.conf
>     
>     
>     panic# ldconfig
>     
>     
>     (使用该方法我的问题就解决了)

Another solution to this problem is to modify the **Makefile** file (which is created when you run **perl Makefile.PL** ) as follows:

1.  Search for the line LD\_RUN\_PATH= 
2.  Replace it with LD\_RUN\_PATH=my\_oracle\_home/lib

where **my\_oracle\_home** is, of course, the home path to your Oracle installation. In particular, the file **libclntsh.so.8.0** should exist in the **lib** subdirectory.

Then just type **make install** , and all should go well.

Note that setting LD\_RUN\_PATH has the effect of hardcoding the path to **my\_oracle\_home/lib** in the file **Oracle.so** , which is generated by DBD::Oracle . This is an efficiency mechanism, so that at runtime it doesn't have to search through LD\_LIBRARY\_PATH or the default directories used by **ld** .

For more information, see the **ld** manpage and the essay on LD\_LIBRARY\_PATH at  [http://www.visi.com/~barr/ldpath.html][http_www.visi.com_barr_ldpath.html] .

[Practical mod_perl]: http://chestofbooks.com/computers/webservers/apache/Stas-Bekman/Practical-mod_perl/index.html
[Stas Bekman]: http://stason.org/
[Eric Cholet]: http://www.logilune.com/eric/
[Practical mod_perl 1]: http://www.amazon.com/dp/0596002270?tag=ref%3Dnosim&link_code=as3&creativeASIN=0596002270&creative=373489&camp=211189
[http_www.visi.com_barr_ldpath.html]: http://www.visi.com/%7Ebarr/ldpath.html