Unfortunately I don't have Oracle and my experience with it is limited to my very limited exposure to it while taking a database class in college. However, I do have a few ideas.

The first thing that I would test is to see if the Oracle client can connect from the same system that you're running your Perl code from. If that can't connect, you probably won't be able to connect via Perl or any other language. Also, that test will help verify that you have the Oracle driver installed on your OS.

Second, make sure that you don't have a firewall blocking the desired port.

Other than that, I'm not sure what other suggestions that I could offer.

In reply to Re^3: DBI Connection with RAC by dasgar
in thread DBI Connection with RAC by asafp

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.