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



Neuron9
Novice

Sep 12, 2012, 6:18 AM


Views: 42884
"failed: ERROR OCIEnvNlsCreate" when connecting to Oracle 11gR2 DB

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
Veteran / Moderator

Sep 12, 2012, 10:27 AM


Views: 42875
Re: [Neuron9] "failed: ERROR OCIEnvNlsCreate" when connecting to Oracle 11gR2 DB

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


Views: 42867
Re: [Laurent_R] "failed: ERROR OCIEnvNlsCreate" when connecting to Oracle 11gR2 DB

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


Views: 42861
Re: [Neuron9] "failed: ERROR OCIEnvNlsCreate" when connecting to Oracle 11gR2 DB

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


Laurent_R
Veteran / Moderator

Sep 13, 2012, 11:53 AM


Views: 42854
Re: [Neuron9] "failed: ERROR OCIEnvNlsCreate" when connecting to Oracle 11gR2 DB

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).