Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot, bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010

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