Interesting...

Could you check out a few things for me?

  1. As the user under which the script runs, execute "tnsping db_tns_name" where db_tns_name is the Oracle TNS name of the instance to which your script is attempting to connect
  2. See if there is any additional error information in the Apache error log and if so, post it here
  3. See if the file sqlnet.log was generated. If so, and it contains any additional information, please post it here

I am guessing this is an Oracle OCI problem, and not really a perl problem.

Update:

Is there any chance the instance to which you are trying to connect is an Oracle 9i instance, and the previous ones were 8i? Looking on Oracle Metalink (support site) I did see some problems with the 8i OCI talking to 9i instances.

In reply to Re: Oracle Connection Error - have you seen this? by Rhose
in thread Oracle Connection Error - have you seen this? by Zo

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.