Hi -

I am using the DBI module (1.609) with DBD-Oracle (1.23) on a Solaris 10 system connecting to an Oracle 11gR1 database (11.1.0.7). All is fine with that. However, we just migrated a database in preparation for an application upgrade to 11gR2 (11.2.0.1).

When I attempt to run one of my Perl programs that worked yesterday when we were still on 11gR1 I now get this error message:

DBI connect('','xxxxxx/yyyyyy',...) failed: ERROR OCIEnvNlsCreate. Che
+ck ORACLE_HOME (Linux) env var  or PATH (Windows) and or NLS settings
+, permissions, etc. at /dcos/mda1/lib/SQLQuery.pl line 47

[download]

I replaced the actual login id and password in the message with the xxxxxx and yyyyyy srings.

The SQLQuery.pl is a function library and the line in question (# 47) is this:

$dbh = DBI->connect('DBI:Oracle:', "$_oraUser/$_oraPasswd");

[download]

Now, I have checked all the obvious things like ORACLE_HOME, LD_LIBRARY_PATH, permissions in the $ORACLE_HOME/bin and $ORACLE_HOME/lib directories and they are all ok. So, before spending too much time beating my head against the wall attempting to make something work that just isn't going to work, do I have to recompile and install the DBI and DBD-Oracle modules with Oracle 11gR2?

I plan on recompiling, but I was hoping that my users would be able to upgrade their database first and then upgrade the application (which would include Perl modules) at a soon, but somewhat later date. The idea being to allow them to get some sleep.

Thanks in advance.

In reply to Connection Problem using DBI w/ Oracle 11gR2 by VingInMedina

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.