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: Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g clientin Cygwin

Posted on 2008-04-24 09:38:12 by christian.merz

Hello Dunston,

did you read
perldoc DBI
and
perldoc DBD::Oracle

? To detect if DBI is able to locate DBD::Oracle use:
@driver_names = DBI->available_drivers;

If so, you can idenitfy your oracle Instances via:
@data_sources = DBI->data_sources($driver_name, \%attr);

You may try:
use DBI;
print "available_drivers:\n";
print "$_\n" foreach DBI->available_drivers;
print "\ndata_sources:\n";
print "$_\n" foreach DBI->data_sources('Oracle');

The output of the latter may be used for the connect statement.

cu, Christian


Dunston Rocks schrieb:
> 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