Yes, it certainly sound like DBD::Oracle couldn't load the external (propritary) libraries from instantclient.

Note: It's been a long time since i used Oracle, but DBD::Oracle was always a bit of a bear to install, because the Oracle client bins and libs and configs are just weird and do things a bit different than any other modern database.

Other people had similar problems:

One thing, that trips me up sometimes for all kinds of software installations and permission/usergroup creation stuff: Using old login sessions that haven't loaded all the new permissions and environment variables. If you're stumped, it's always a good idea to close all SSH sessions and start fresh (or reboot, if it's on the local computer).

One thing i would re-check after a session refresh/reboot is that the Oracle provided command line tools (sqlplus, tnsping) still work as a normal user.

Downloading the tarball for DBD::Oracle and running "perl Makefile.PL && make test" as the non-root user might provide additional insight on what is failing.

Checking dmesg output and any selinux errors also often helps. I'm not a RedHat user, but here is a guide on how to check if selinux security is tripping you up in some way: How to read and correct SELinux denial messages

DBD::Oracle has a lot of open issues on the issue tracker. I couldn't find anything related, though, but OP might have additional info to put into the search bar.

PerlMonks XP is useless? Not anymore: XPD - Do more with your PerlMonks XP
Also check out my sisters artwork and my weekly webcomics

In reply to Re^4: Can't locate loadable object for module DBD::Oracle in @INC by cavac
in thread Can't locate loadable object for module DBD::Oracle in @INC by Calab

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.