Is libclntsh.so where it is expected to be? If the path to the Oracle libraries has changed (includes version number) has that been reflected in your library path?

You can check what's happening using ldd /opt/info1tools/lib/perl5/site_perl/5.8.8/aix/auto/DBD/Oracle/Oracle.so. This will show what libraries are found against the Perl library file. If not found you can try export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:<path to Oracle libs>. When using instant client we have found we have sometimes needed to create links to the instant library directory for sub directories like lib. e.g. ln -s <instant client dir> <instant client dir>/lib

One thing we have in some of our Oracle Perl scripts is at startup we check for Oracle environment and if not set we set that up then exec the script over itself. Maybe not the best way but it does work both from command line/shell and cron.

In reply to Re: Oracle library error by tweetiepooh
in thread Oracle library error by snuvvula

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.