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?
August 8th, 2013, 12:05 PM
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