CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI:
"failed: ERROR OCIEnvNlsCreate" when connecting to Oracle 11gR2 DB

 



Neuron9
Novice

Sep 12, 2012, 6:18 AM

Post #1 of 5 (22417 views)
"failed: ERROR OCIEnvNlsCreate" when connecting to Oracle 11gR2 DB Can't Post

Hi,

Just wanted some resolution pointers regarding the error which am facing when trying to connect to oracle 11gR2 database with perl.

failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc. at

The same perl script can connect without any issues to 11gR1 and 10g databases.

Please can you direct me here and suggest TODOs.

Thanks in advance!

Regards,
Neuron


Laurent_R
Enthusiast / Moderator

Sep 12, 2012, 10:27 AM

Post #2 of 5 (22408 views)
Re: [Neuron9] "failed: ERROR OCIEnvNlsCreate" when connecting to Oracle 11gR2 DB [In reply to] Can't Post

Just an idea: perhaps you need to update your DBD::Oracle module. Check if yours supports Oracle 11gR2.


Neuron9
Novice

Sep 12, 2012, 11:50 PM

Post #3 of 5 (22400 views)
Re: [Laurent_R] "failed: ERROR OCIEnvNlsCreate" when connecting to Oracle 11gR2 DB [In reply to] Can't Post

Thanks for the feedback.

Yes it looks like the DBD:Oracle was compiled against 11gR1 client.

Can you or someone please send me steps or a pointer for TODOs for recompilation. I will be doing this for first time.

Thanks in advance!


Neuron9
Novice

Sep 13, 2012, 4:58 AM

Post #4 of 5 (22394 views)
Re: [Neuron9] "failed: ERROR OCIEnvNlsCreate" when connecting to Oracle 11gR2 DB [In reply to] Can't Post

Hi Laurent_R and others,
How can i check if my DBD:Oracle supports 11gR2?


Laurent_R
Enthusiast / Moderator

Sep 13, 2012, 11:53 AM

Post #5 of 5 (22387 views)
Re: [Neuron9] "failed: ERROR OCIEnvNlsCreate" when connecting to Oracle 11gR2 DB [In reply to] Can't Post

I am sorry, but I have no idea. I do not have the liberty to install myself modules on the production servers where I work, I have to request installation by the sys admin team (and that involves a lot of bureaucracy, I would prefer being able to do it myself, but it is simply not the case).

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives