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
Tags (1)
6 REPLIES
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