note that your $dsn is not used in your DBI->connect() which hardcodes the dsn.

Check if DBD::Oracle is installed under a path included in @INC. In Linux I use App::whichpm to locate modules from the command prompt, like: whichpm DBD::Oracle . In order to see Perl's @INC I do this from command prompt: perl -e "print \"@INC\"" (I guess that works in windows with lame quoting rules). Simply check if the starting path of the first command matches an entry in the output of the second.

Finally, as you said and other Monks said and the program diagnosed: Perhaps the capitalisation of DBD 'oracle' isn't right. And also the documentation of DBD::Oracle has this example (and that should have been your first call actually!):

use DBI;
 
$dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd);

[download]

Also note that more than one reasons for failure may apply.

bw, bliako

In reply to Re: Unable to connect to Oracle 19c by bliako
in thread Unable to connect to Oracle 19c by SpaceCowboy

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.