Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

DBD::Oracle throwing below error

by mendeepak (Scribe)
on Apr 28, 2023 at 11:15 UTC ( [id://11151886]=perlquestion: print w/replies, xml ) Need Help??

mendeepak has asked for the wisdom of the Perl Monks concerning the following question:

I am trying to connect to oracle 19 via DBD::Oracle , but am getting this below error
can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/' for module DBD::Oracle no such file or directory
DBD::Oracle version is 1.74
oracle 19
ORACLE_HOME is set in linux bash_profile
its been some time I have used perl. bit confusing what i need to set


Replies are listed 'Best First'.
Re: DBD::Oracle throwing below error
by hv (Prior) on Apr 28, 2023 at 11:42 UTC

    I suggest starting with a look through the output of ldd /usr/local/lib64/perl5/auto/DBD/Oracle/, to compare the paths of libraries it successfully finds to the one(s) it does not.

    The next question is whether the requested library exists on the system. If it does, then the problem to solve is getting the linker and the actual location to agree, eg by moving or symlinking the file, or via the environment variable LD_LIBRARY_PATH; if it does not, the next step is to check if Oracle or the O/S supply a package that provides that library.

    Beyond that: has it ever worked? What version of perl is it? Did you install DBD::Oracle yourself, or did it come as an O/S package? (If you installed it yourself: did it pass its tests? If it came as an O/S package, it may be a packaging dependencies error.)

Re: DBD::Oracle throwing below error
by marto (Cardinal) on Apr 28, 2023 at 11:40 UTC

    "DBD::Oracle version is 1.74"

    You'll probably want to upgrade. Did you previously have this working with Oracle 12C?

      this is working with 12c


        And you've upgraded to 19?

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://11151886]
Approved by Arunbear
Front-paged by Corion
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (7)
As of 2024-04-22 13:36 GMT
Find Nodes?
    Voting Booth?

    No recent polls found