{"id":259,"date":"2010-04-15T11:05:26","date_gmt":"2010-04-15T03:05:26","guid":{"rendered":"http:\/\/www.genepeng.com\/index.php\/259"},"modified":"2010-04-15T11:07:38","modified_gmt":"2010-04-15T03:07:38","slug":"install_driveroracle-failed-cant-load-dbdoracleoracle-so-for-module-dbdoracle","status":"publish","type":"post","link":"https:\/\/www.genepeng.com\/index.php\/259","title":{"rendered":"install_driver(Oracle) failed: Can’t load `…\/DBD\/Oracle\/Oracle.so’ for module DBD::Oracle"},"content":{"rendered":"

Description<\/p>\n

This section is from the "Practical mod_perl<\/a> " book, by Stas Bekman<\/a> and Eric Cholet<\/a> . Also available from Amazon: Practical mod_perl<\/a><\/p>\n

<\/a><\/p>\n

Here’s an example of the full error <\/a>report that you might see:<\/a><\/p>\n

\n
install_driver(Oracle) failed: Can't load
\n\n'\/usr\/lib\/perl5\/site_perl\/5.6.1\/i386-linux\/auto\/DBD\/Oracle\/Oracle.so'
\n\nfor module DBD::Oracle:
\n\nlibclntsh.so.8.0: cannot open shared object file: 
\n\nNo such file or directory at
\n\n\/usr\/lib\/perl5\/5.6.1\/i386-linux\/DynaLoader.pm line 169.
\n\nat (eval 27) line 3
\n\nPerhaps a required shared
\n\nlibrary or dll isn't installed where expected at 
\n\n\/usr\/local\/apache\/perl\/tmp.pl line 11
\n<\/a>\n\"\"\n 
<\/pre>\n<\/blockquote>\n
On BSD-style filesystems, LD_LIBRARY_PATH<\/tt> is not searched for setuid<\/strong> programs. If Apache is a setuid<\/strong> executable, you might receive this error. Therefore, the first solution is to explicitly load the library from the system-wide ldconfig<\/strong> configuration file:<\/a><\/p>\n
\n
panic# echo $ORACLE_HOME\/lib >> \/etc\/ld.so.conf
\n\npanic# ldconfig
\n\n(\u4f7f\u7528\u8be5\u65b9\u6cd5\u6211\u7684\u95ee\u9898\u5c31\u89e3\u51b3\u4e86)<\/a><\/pre>\n<\/blockquote>\n
Another solution to this problem is to modify the Makefile<\/strong> file (which is created when you run perl Makefile.PL<\/strong> ) as follows:<\/a><\/p>\n
    \n
  1. \n
    Search for the line LD_RUN_PATH=<\/tt><\/a><\/p>\n<\/li>\n
  2. \n
    Replace it with LD_RUN_PATH=my_oracle_home\/lib<\/tt><\/a><\/p>\n<\/li>\n<\/ol>\n
    where my_oracle_home<\/strong> is, of course, the home path to your Oracle installation. In particular, the file libclntsh.so.8.0<\/strong> should exist in the lib<\/strong> subdirectory.<\/a><\/p>\n
    Then just type make install<\/strong> , and all should go well.<\/a><\/p>\n
    Note that setting LD_RUN_PATH<\/tt> has the effect of hardcoding the path to my_oracle_home\/lib<\/strong> in the file Oracle.so<\/strong> , which is generated by DBD::Oracle<\/tt> . This is an efficiency mechanism, so that at runtime it doesn’t have to search through LD_LIBRARY_PATH<\/tt> or the default directories used by ld<\/strong>.<\/a><\/p>\n
    For more information, see the ld<\/strong> manpage and the essay on LD_LIBRARY_PATH<\/tt> at <\/a>http:\/\/www.visi.com\/~barr\/ldpath.html<\/a> .<\/p>\n","protected":false},"excerpt":{"rendered":"
    Description This section is from the "Practical mod_perl " book, by Stas Bekman and Eric Cholet . Also available from Amazon: Practical mod_perl 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 … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9,4],"tags":[],"_links":{"self":[{"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/posts\/259"}],"collection":[{"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/comments?post=259"}],"version-history":[{"count":2,"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/posts\/259\/revisions"}],"predecessor-version":[{"id":319,"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/posts\/259\/revisions\/319"}],"wp:attachment":[{"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/media?parent=259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/categories?post=259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/tags?post=259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}