Thread

[ home | FAQ | about | stats | new post | login | register | tags ]
Attend the Test automation using Perl master class on 19-20 June in Chicago, IL. Just after YAPC::NA

DBD-Oracle [search.cpan.org] [Kobes search] [View and report bugs] [Ratings 3.5 (13) ]
[AnnoCPAN] [CPAN Tests results] [CPANTS]
Posted on Tue Sep 19 12:52:15 2006 by oboyaval
ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2
Hello

I have installed DBD::Oracle for my Hobbitmon server and I have a problem with it.

First I installed the Oracle Instantclient 10.2.0.2 (basic, sdk, sqlplus).

I have tested the database connection with sqlplus and it's OK

Next I have installed the DBD::Oracle 1.18a (the CPAN package) with sles 9 SP3 x86_64 package perl-DBI-1.41-28.4

The messages of the Makefile.PL are :
Using DBI 1.41 (for perl 5.008003 on x86_64-linux-thread-multi) installed in /usr/lib/perl5/vendor_ +perl/5.8.3/x86_64-linux-thread-multi/auto/DBI Configuring DBD::Oracle for perl 5.008003 on linux (x86_64-linux-thread-multi) Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /opt/instantclient SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly If sqlplus failed due to a linker/symbol/relocation/library error or similar problem then it's likely that you've not configured your environment correctly. Specifically, your LD_LIBRARY_PATH environment variable set to include the directory containing the Oracle libraries. I'm having trouble finding your Oracle version number... trying harder WARNING: I could not determine Oracle client version so I'll just default to version 8.0.0.0. Some features of DBD::Oracle may not work. Oracle version based logic in Makefile.PL may produce erroneous results. You can use "perl Makefile.PL -V X.Y.Z" to specify a your client version. Oracle version 8.0.0.0 (8.0) Looks like an Instant Client installation, okay Your LD_LIBRARY_PATH env var is set to '/opt/instantclient/' Oracle sysliblist: Found header files in /opt/instantclient/sdk/include. Checking for functioning wait.ph Scalar found where operator expected at (eval 182) line 1, near "'int' $__val" (Missing operator before $__val?) System: perl5.008003 linux salieri 2.6.5 #1 smp fri jan 14 15:41:33 utc 2005 x86_64 x86_64 x86_64 g +nulinux Compiler: cc -O2 -fmessage-length=0 -Wall -Wall -pipe -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_P +IDS -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 Linker: /usr/bin/ld Sysliblist: Linking with -lclntsh. LD_RUN_PATH=/opt/instantclient Using DBD::Oracle 1.18. Using DBD::Oracle 1.18. Using DBI 1.41 (for perl 5.008003 on x86_64-linux-thread-multi) installed in /usr/lib/perl5/vendor_ +perl/5.8.3/x86_64-linux-thread-multi/auto/DBI Writing Makefile for DBD::Oracle

make : Ok

make test : ERROR OCIEnvNlsCreate on database connections

I have tested with Makefile.PL -V 10.2.0 and I have the same problem

LD_LIBRARY_PATH and ORACLE_HOME are setting with /opt/instantclient/

any idea ?

cordialement
olivier
Direct Responses: 3089 | Write a response
Posted on Tue Sep 19 15:33:31 2006 by oboyaval in response to 3086
Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2
I have recompiled correctly DBD:Oracle and make test run ok (with a correct ORACLE_USERID variable).
With perl client for hobbitmon, I have always the problem with OCIEnvNlsCreate
Olivier
Direct Responses: 3091 | Write a response
Posted on Tue Sep 19 16:06:19 2006 by byterock in response to 3089
Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2
OCIEnvNlsCreate is used to specify client-side database and national character sets that OCI will use. Could be a few things going awry here. So your compile works it is just the connection with DBD that does not work. This might be some incompatibliyt there between the users NCS and the NCS of DBD
Direct Responses: 3092 | Write a response
Posted on Tue Sep 19 16:15:56 2006 by byterock in response to 3091
Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2
Also looks like it is not finding the correct Oracle client version is says 8.0 is should be something like this Using Oracle in C:/oraclexe/app/oracle/product/10.2.0/server DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2) Found OCI directory Using OCI directory 'OCI' Found OCI/lib/MSVC/oci.lib library Found OCI/lib/MSVC/ociw32.lib library Found OCI/lib/MSVC/oraocci10.lib library Using OCI/lib/MSVC/OCI.lib and that is sending you to OCIEnvCreate rather than the older OCIEnvNlsCreate or something like this. If you want I can send you a Debug version of Makefile.PL so I can see at which path your Makefile.PL takes. cheers John Scoles
Direct Responses: 3093 | Write a response
Posted on Tue Sep 19 17:18:00 2006 by oboyaval in response to 3092
Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2
For the Oracle client version, it's ok now.
The make test run correctly
in hobbit user environnement, a simple perl script with a database connection run correctly. In the same user environnement, the perl-hobbit-client doesn't connect with the prevouis database with error message : ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc. In this environnement LD_LIBRARY_PATH and ORACLE_HOME are setting to /opt/instantclient.
I'm not the author of perl-hobbit-client. He uses the full oracle client rather the instantclient and he hasn't problem so he can't really help me.
You can send me the debug version of Makefile.PL please.
cordialement
olivier
Direct Responses: 3094 | 3095 | Write a response
Posted on Tue Sep 19 17:59:07 2006 by byterock in response to 3093
Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2
I am going to need you email address? The file is ready. I may take a few runs back and forth to nail down what is going on in the make. cheers John Scoles my email is Scoles at Pythain.com
Direct Responses: 3096 | 3097 | 3099 | Write a response
Posted on Tue Sep 19 18:16:19 2006 by byterock in response to 3093
Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2
I am going to need you email address? The file is ready. I may take a few runs back and forth to nail down what is going on in the make. cheers John Scoles my email is Scoles at Pythain.com
Write a response
Posted on Tue Sep 19 18:18:29 2006 by oboyaval in response to 3094
Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2
oboyaval aT ch-bethune dOt fr
Direct Responses: 3098 | Write a response
Posted on Tue Sep 19 18:28:42 2006 by oboyaval in response to 3094
Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2
oboyaval aT ch-bethune dOt fr
Write a response
Posted on Tue Sep 19 18:31:16 2006 by byterock in response to 3096
Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2
Ok I sent it hopefully it arrives soon
Write a response
Posted on Tue Sep 19 18:31:54 2006 by oboyaval in response to 3094
Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2
oboyaval aT ch-bethune dOt fr
Direct Responses: 3101 | Write a response
Posted on Tue Sep 19 18:51:44 2006 by byterock in response to 3099
Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2
The email bounced back can you send me one at scoles at pythian.com cheers
Direct Responses: 3172 | Write a response
Posted on Tue Oct 3 13:21:29 2006 by oboyaval in response to 3101
Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2
Hello, I have resolved my problem with the install of the full oracle client 10g2 for linux x86_64. The Oracle instant client is not ok. thank for your help olivier
Write a response
[ home | FAQ | about | stats | new post | login | register | tags ]
Attend the Test automation using Perl master class on 19-20 June in Chicago, IL. Just after YAPC::NA
Service launched on 2nd of February 2005.
Comments, and other submissions on CPAN Forum are Copyright 2005-2007, their respective owners.
Site maintainer is not responsible for content. Privacy Policy
Maintained and hosted by Gabor Szabo at Perl Training Israel
See also World Wide Perl Training