#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    1
    Rep Power
    0

    DBI failed: ERROR OCIEnvNlsCreate on Oracle 11g


    I was connecting to Oracle 11g DB through Redhat Linux server with Use DBI: but it returned

    DBI connect('host=$hostname;sid=$sid;port=$port','$name',...) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc. at perlrun.pl line 85

    My ORACLE_HOME was set to /oracle/client/11.2

    If I switch it back to /oracle/client/10.2.0, the same script runs without error.

    Anyone experienced this?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2013
    Posts
    1
    Rep Power
    0

    Perl with Oracle Client


    My SA load Oracle Client 11.2.0 and I got the same error with my path set to /data/oraclse/product/11.2.0/client_1/bin.
    However, when I shortened to /data/oraclse/product/11.2.0/client_1 I connected successfully.

    Don't know if this is the fix, just that it worked for me

IMN logo majestic logo threadwatch logo seochat tools logo