DBD-Oracle - ERROR OCIEnvNlsCreate with DBD::Oracle 1.18 and InstantClient 10.2.0.2

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