NLS_LANG/ORACLE_HOME

Highlighted
One Star

NLS_LANG/ORACLE_HOME

Hello,
When I work with java, there are no issues, I can connect to my Oracle database very easily. But when I work with perl (ActivePerl: 5.8.8), here come the troubles! I can't connect to my Oracle DB. this is what I get when I try to do a simple tOracleInput and run the job:
--------------
Starting job xxx at 18:09 26/11/2007.
DBI connect('host=xxx;sid= xxx;port=xxx','xxx',...) failed: ERROR OCINlsEnvironmentVariableGet(OCI_NLS_CHARSET_ID) Check ORACLE_HOME and NLS settings etc. at \\xxx\xxx\xxx\xxx\xxx\logiciel\TOS-All-r7019-V2.3.0M1\workspace\.Perl\ALIMENTATION.job_xxx.pl line 393
can't connect to database at \\xxx\xxx\xxx\xxx\xxx\logiciel\TOS-All-r7019-V2.3.0M1\workspace\.Perl\ALIMENTATION.job_xxx.pl line 393.
Job xxx ended at 18:09 26/11/2007.
-------------
I've downloaded all the package needed, especially DBD-Oracle (1.17):
In the tab "module" of TOS, everything about Oracle seems to be well installed.
I've also checked my environment variable and run the script you put in the forum:
Starting job xxx at 18:27 26/11/2007.
ORACLE_HOME: C:\OraHome1
NLS_LANG: FR_FR
=== PATH
C:\Program Files\Java\jre1.6.0_03\bin\client
C:\Program Files\Java\jre1.6.0_03\bin
C:\Perl\bin\
C:\OraHome1\bin
C:\Program Files\Oracle\jre\1.1.8\bin
C:\Program Files\Oracle\jre\1.3.1\bin
C:\Program Files\Business Objects\common\3.5\bin\NOTES\
C:\Program Files\Business Objects\common\3.5\bin\NOTES\DATA\
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
===
Job xxx ended at 18:27 26/11/2007.
I'm on windows xp, an oracle client is installed locally (9.2)
Thanks for your help!
Regards
One Star

Re: NLS_LANG/ORACLE_HOME

Hi,
I really need an answer. Any suggestions would be great Smiley Wink
Thank you.
Regards.
One Star

Re: NLS_LANG/ORACLE_HOME

When I use the following script:
#!/usr/bin/perl -w
use DBI;
use DBD:Smiley Surprisedracle;
use strict;
my $dbname = 'xxx';
my $user = 'xxx';
my $passwd = 'xxx';
my $dbh = DBI->connect("dbiSmiley Surprisedracle:$dbname", $user, $passwd) or
die "Database connection not made: $DBI::errstr";
$dbh -> disconnect;
I've got this error:
L'application ou la DLL C:\Perl\bin\OraOCIEI10.dll n'est pas une image Windows valide. Verifiez à l'aide de votre disquette d'installation.
and then I've got the same error with the NLS....

Any idea?
Regards.
Employee

Re: NLS_LANG/ORACLE_HOME

Hi,
Have you tried to reinstall your DBD-Oracle module : from a command line
ppm remove DBD-Oracle
ppm install DBD-Oracle
You should be prompted during the installation to download the Oracle client.
Hope this helps.
One Star

Re: NLS_LANG/ORACLE_HOME

Hi,
Thank you for your answer.
When I look in C:\Perl\bin, the size of oraociei10.dll is 0.
I've removed DBD-Oracle and I'm trying to reinstall it but it doesn't work:
Do you accept the terms of this license ? (y/n) : y
Fetching oci.dll.gz (94 Kb)
94Kb/94Kb (100.00%)
Decompressing.
oci.dll checksum: OK
Fetching oraociei10.dll.gz (28 Mb)
28Mb/28Mb (100.00%)
DecompressingCan't call method "gzread" on an undefined value at install_script
line 149.
ppm install failed: Command exits with 2:
C:\Perl\bin\perl.exe install_script
stopped

Do you have any idea?
Thanks
Employee

Re: NLS_LANG/ORACLE_HOME

You can download oci.dll and oraociei10.dll from http://ppm.activestate.com/libs/oracle-instant-client/MSWin32-x86-multi-thread/ and copy them in c:\Perl\bin
Regards
One Star

Re: NLS_LANG/ORACLE_HOME

Hi,
Thanks a lot, it finally works!!!!
Regards

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog