Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Oracle library error

by tweetiepooh (Hermit)
on May 09, 2017 at 12:22 UTC ( #1189893=note: print w/replies, xml ) Need Help??


in reply to Oracle library error

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.

Replies are listed 'Best First'.
Re^2: Oracle library error
by snuvvula (Novice) on May 09, 2017 at 13:04 UTC
    I get following error while i run ldd command. ldd /opt/XXX/lib/perl5/site_perl/5.8.8/aix/auto/DBD/Oracle/Oracle.so /opt/XXX/lib/perl5/site_perl/5.8.8/aix/auto/DBD/Oracle/Oracle.so needs: /usr/lib/libc.a(shr.o) Cannot find libclntsh.so /unix /usr/lib/libcrypt.a(shr.o)
      Any update please?

        Did you do as I suggested?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1189893]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (3)
As of 2022-08-08 08:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?