Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

Posted on 2008-04-22 21:59:26 by rocksdunston

Hi
I had posted a few days ago about facing problems installing DBD::Oracle with Oracle 10g client under Cygwin.
Though those were circumvented successfully, when I try to run a simple script that calls DBI->Connect, I get

DBI connect(....) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc. at tmp.pl line 12
Error ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc. at tmp.pl line 12.

ORACLE_HOME C:\oracle\product\10.2.0\client_2
ORACLE_SID DEVDB
TWO_TASK DEVDB
NLS_LANG WE8ISO8859P15

I saw some earlier threads on this issue which recommended ensuring that the permissions on ORACLE_HOME/bin and ORACLE_HOME/lib are set correctly.
All user-accounts on this machine have "Full Control" for these directories.

Any recommendations anyone?

Thanks







____________________________________________________________ ________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

Report this message

#2: Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g clientin Cygwin

Posted on 2008-04-23 12:50:57 by christian.merz

Hello Dunston,

in my test script i set:

$ENV{ORACLE_SID} = "ORCL";
$ENV{ORACLE_HOME} = "/path/to/oracle/home";
$ENV{NLS_LANG} = "AMERICAN_AMERICA.WE8DEC";
# or "GERMAN_GERMANY.WE8ISO8859P15";
$ENV{ORA_NLS} = $ENV{ORACLE_HOME} . "/ocommon/nls/admin/data";
$ENV{PATH} = $ENV{ORACLE_HOME} . "/bin:/usr/bin";
$ENV{LD_LIBRARY_PATH} = $ENV{ORACLE_HOME} . "/lib";

In Oracle10 you should replace NLS_LANG by s'thing like:
$ENV{ORA_NLS10} = '/oracle/product/10.2.0/nls/data';

cu, Christian


Dunston Rocks schrieb:
> Hi
> I had posted a few days ago about facing problems installing DBD::Oracle with Oracle 10g client under Cygwin.
> Though those were circumvented successfully, when I try to run a simple script that calls DBI->Connect, I get
>
> DBI connect(....) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc. at tmp.pl line 12
> Error ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc. at tmp.pl line 12.
>
> ORACLE_HOME C:\oracle\product\10.2.0\client_2
> ORACLE_SID DEVDB
> TWO_TASK DEVDB
> NLS_LANG WE8ISO8859P15
>
> I saw some earlier threads on this issue which recommended ensuring that the permissions on ORACLE_HOME/bin and ORACLE_HOME/lib are set correctly.
> All user-accounts on this machine have "Full Control" for these directories.
>
> Any recommendations anyone?
>
> Thanks
>
>
>
>
>
>
>
> ____________________________________________________________ ________________________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>

Report this message

#3: Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

Posted on 2008-04-23 16:45:28 by rocksdunston

Hi
I have updated my system per your instructions and also included these lines as a preamble in my test script.

I have modified the security settings for every folder under ORACLE_HOME to give full read-write permissions to every user-account on this computer.

However I still continue to encounter the same error.

Any input on resolving the above would be helpful!

Thanks

----- Original Message ----
From: Christian Merz <christian.merz@muenchen.de>
To: Dunston Rocks <rocksdunston@yahoo.com>
Cc: dbi-users@perl.org
Sent: Wednesday, April 23, 2008 6:50:57 AM
Subject: Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

Hello Dunston,

in my test script i set:

$ENV{ORACLE_SID} = "ORCL";
$ENV{ORACLE_HOME} = "/path/to/oracle/home";
$ENV{NLS_LANG} = "AMERICAN_AMERICA.WE8DEC";
# or "GERMAN_GERMANY.WE8ISO8859P15";
$ENV{ORA_NLS} = $ENV{ORACLE_HOME} . "/ocommon/nls/admin/data";
$ENV{PATH} = $ENV{ORACLE_HOME} . "/bin:/usr/bin";
$ENV{LD_LIBRARY_PATH} = $ENV{ORACLE_HOME} . "/lib";

In Oracle10 you should replace NLS_LANG by s'thing like:
$ENV{ORA_NLS10} = '/oracle/product/10.2.0/nls/data';

cu, Christian


Dunston Rocks schrieb:
> Hi
> I had posted a few days ago about facing problems installing DBD::Oracle with Oracle 10g client under Cygwin.
> Though those were circumvented successfully, when I try to run a simple script that calls DBI->Connect, I get
>
> DBI connect(....) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc. at tmp.pl line 12
> Error ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc. at tmp.pl line 12.
>
> ORACLE_HOME C:\oracle\product\10.2.0\client_2
> ORACLE_SID DEVDB
> TWO_TASK DEVDB
> NLS_LANG WE8ISO8859P15
>
> I saw some earlier threads on this issue which recommended ensuring that the permissions on ORACLE_HOME/bin and ORACLE_HOME/lib are set correctly.
> All user-accounts on this machine have "Full Control" for these directories.
>
> Any recommendations anyone?
>
> Thanks
>
>
>
>
>
>
>
> ____________________________________________________________ ________________________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>





____________________________________________________________ ________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

Report this message