Re: Make failure on DBD-Oracle-1.19 "lclntsh: not found" -- Solaris 10

Just a few quick things

Instant client also requires the SDK download as well. Did you download that
Also make sure you have permission to make a symbolic link in the instant
client dir. This is also a requirement as Oracle has rebundeled the .so
files in an odd way.

cheers


""David Hull"" <davidhullster@xxxxxxxxx> wrote in message
news:7fa1a5400704162251p6bde9637i93118b5bdf18e956@xxxxxxxxxxxxxxxxx
I'm running Perl 5.8.4, DBI-1.54, on Solaris 10.
I've installed Oracle Instant Client 10.2.0.1.
sqlplus works fine, I can connect to my database and run queries.
The only env variable I've set it LD_LIBRARY_PATH, to
/opt/instantclient_10_2
Setting ORACLE_HOME to /opt/instantclient_10_2 doesn't seem to make any
difference, and breaks sqlplus.
perl Makefile.PL succeeds, but make fails, it says it can't find lclntsh.

Does anyone have advice on how I can make this work on my server?
I'm really stumped!

--David
(my first name +hullster at gmail)

<pre>
sol10# perl Makefile.PL -V 10.2
Using DBI 1.54 (for perl 5.008004 on sun4-solaris-64int) installed in
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/

Configuring DBD::Oracle for perl 5.008004 on solaris (sun4-solaris-64int)

Remember to actually *READ* the README file! Especially if you have any
problems.

Trying to find an ORACLE_HOME
using PATH /opt/SUNWspro/bin /bin /usr/bin /usr/local/sbin /usr/sfw/sbin
/opt/sfw/sbin /usr/sbin /usr/ccs/bin /usr/xpg6/bin /usr/xpg4/bin /sbin
/usr/local/bin /usr/bin /usr/sfw/bin /opt/sfw/bin /usr/ucb
Your LD_LIBRARY_PATH env var is set to '/opt/instantclient_10_2/'
using ldlib /opt/instantclient_10_2/
Found /opt/instantclient_10_2/

WARNING: Setting ORACLE_HOME env var to /opt/instantclient_10_2/ for you.
WARNING: The tests will probably fail unless you set ORACLE_HOME yourself!
Using Oracle in /opt/instantclient_10_2/
PATH=/opt/instantclient_10_2//bin:/opt/instantclient_10_2/:/opt/SUNWspro/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sfw/sbin:/opt/sfw/sbin:/usr/sbin:/usr/ccs/bin:/usr/xpg6/bin:/usr/xpg4/bin:/sbin:/usr/local/bin:/usr/bin:/usr/sfw/bin:/opt/sfw/bin:/usr/ucb
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software
directory

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.

Forcing Oracle version to be treated as 10.2
Oracle version 10.2 (10.2)
Looks like an Instant Client installation, okay
You don't have a libclntsh.so file, only
/opt/instantclient_10_2//libclntsh.so
/opt/instantclient_10_2//libclntsh.so.10.1
So I'm going to create a /opt/instantclient_10_2//libclntsh.so symlink to
/opt/instantclient_10_2//libclntsh.so.10.1
Can't create symlink /opt/instantclient_10_2//libclntsh.so to
/opt/instantclient_10_2//libclntsh.so.10.1: File exists
Your LD_LIBRARY_PATH env var is set to '/opt/instantclient_10_2/'
Oracle sysliblist:
Found /opt/instantclient_10_2//sdk/include/oci8dp.h
Found /opt/instantclient_10_2//sdk/include/ociapr.h
Found /opt/instantclient_10_2//sdk/include/ocidef.h
Found /opt/instantclient_10_2//sdk/include/ocidem.h
Found /opt/instantclient_10_2//sdk/include/ocidfn.h
Found /opt/instantclient_10_2//sdk/include/ociextp.h
Found /opt/instantclient_10_2//sdk/include/ocikpr.h
Found /opt/instantclient_10_2//sdk/include/oratypes.h
Found header files in /opt/instantclient_10_2//sdk/include.

Checking for functioning wait.ph


System: perl5.008004 sunos localhost 5.10 sun4u sparc SUNW,Ultra-2
Compiler: cc -xO3 -xspace -xildoff -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO
Linker: /usr/ccs/bin/ld
Sysliblist:
Linking with -lclntsh.


WARNING: If you have problems you may need to rebuild perl with threading
enabled.
MakeMaker (v6.17)
ABSTRACT_FROM => q[Oracle.pm]
AUTHOR => q[Tim Bunce (dbi-users@xxxxxxxx)]
DEFINE => q[ -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2\"]
DIR => []
EXE_FILES => [q[ora_explain]]
INC => q[-I/opt/instantclient_10_2//sdk/include
-I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI]
LIBS => [q[-L/opt/instantclient_10_2/ -lclntsh ]]
NAME => q[DBD::Oracle]
OBJECT => q[$(O_FILES)]
PREREQ_PM => { DBI=>q[0] }
VERSION_FROM => q[Oracle.pm]
clean => { FILES=>q[xstmp.c Oracle.xsi dll.base dll.exp sqlnet.log
libOracle.def ora_explain mk.pm DBD_ORA_OBJ.*] }
dist => { DIST_DEFAULT=>q[clean distcheck disttest tardist],
COMPRESS=>q[gzip -v9], PREOP=>q[$(MAKE) -f Makefile.old distdir],
SUFFIX=>q[gz] }
dynamic_lib => { OTHERLDFLAGS=>q[] }
Using PERL=/bin/perl
Potential libraries are '-L/opt/instantclient_10_2/ -lclntsh':
'-lclntsh' found at /opt/instantclient_10_2//libclntsh.so.10.1
LD_RUN_PATH=/opt/instantclient_10_2
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.54 (for perl 5.008004 on sun4-solaris-64int) installed in
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/
Writing Makefile for DBD::Oracle

*** If you have problems...
read all the log printed above, and the README and
README.help.txtfiles.
(Of course, you have read README by now anyway, haven't you?)

sol10#
sol10# make
Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/lib/DBD/mkta.pl (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
cc -c -I/opt/instantclient_10_2//sdk/include
-I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3
-xspace -xildoff -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -KPIC
"-I/usr/perl5/5.8.4/lib/sun4-solaris-64int/CORE" -DUTF8_SUPPORT
-DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2\" Oracle.c
cc -c -I/opt/instantclient_10_2//sdk/include
-I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3
-xspace -xildoff -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -KPIC
"-I/usr/perl5/5.8.4/lib/sun4-solaris-64int/CORE" -DUTF8_SUPPORT
-DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2\" dbdimp.c
cc -c -I/opt/instantclient_10_2//sdk/include
-I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3
-xspace -xildoff -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -KPIC
"-I/usr/perl5/5.8.4/lib/sun4-solaris-64int/CORE" -DUTF8_SUPPORT
-DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2\" oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/opt/instantclient_10_2" cc -G Oracle.o dbdimp.o
oci8.o -o
blib/arch/auto/DBD/Oracle/Oracle.so -L/opt/instantclient_10_2/ -lclntsh
ld: fatal: library -lclntsh: not found
ld: fatal: File processing errors. No output written to
blib/arch/auto/DBD/Oracle/Oracle.so
*** Error code 1
make: Fatal error: Command failed for target
`blib/arch/auto/DBD/Oracle/Oracle.so'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
perl -V

Summary of my perl5 (revision 5 version 8 subversion 4) configuration:
Platform:
osname=solaris, osvers=2.10, archname=sun4-solaris-64int
uname='sunos localhost 5.10 sun4u sparc SUNW,Ultra-2'
config_args=''
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=define use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8
-D_TS_ERRNO',
optimize='-xO3 -xspace -xildoff',
cppflags=''
ccversion='Sun WorkShop', gccversion='', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=87654321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='cc', ldflags =''
libpth=/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lc
perllibs=-lsocket -lnsl -ldl -lm -lc
libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-R
/usr/perl5/5.8.4/lib/sun4-solaris-64int/CORE'
cccdlflags='-KPIC', lddlflags='-G'


Characteristics of this binary (from libperl):
Compile-time options: USE_64_BIT_INT USE_LARGE_FILES
Locally applied patches:
22667 The optree builder was looping when constructing the ops ...
22715 Upgrade to FileCache 1.04
22733 Missing copyright in the README.
22746 fix a coredump caused by rv2gv not fully converting a PV ...
22755 Fix 29149 - another UTF8 cache bug hit by substr.
22774 [perl #28938] split could leave an array without ...
22775 [perl #29127] scalar delete of empty slice returned garbage
22776 [perl #28986] perl -e "open m" crashes Perl
22777 add test for change #22776 ("open m" crashes Perl)
22778 add test for change #22746 ([perl #29102] Crash on assign ...
22781 [perl #29340] Bizarre copy of ARRAY make sure a pad op's ...
22796 [perl #29346] Double warning for int(undef) and abs(undef)
...
22818 BOM-marked and (BOMless) UTF-16 scripts not working
22823 [perl #29581] glob() misses a lot of matches
22827 Smoke [5.9.2] 22818 FAIL(F) MSWin32 WinXP/.Net SP1 (x86/1
cpu)
22830 [perl #29637] Thread creation time is hypersensitive
22831 improve hashing algorithm for ptr tables in perl_clone: ...
22839 [perl #29790] Optimization busted: '@a = "b", sort @a' ...
22850 [PATCH] 'perl -v' fails if local_patches contains code
snippets
22852 TEST needs to ignore SCM files
22886 Pod::Find should ignore SCM files and dirs
22888 Remove redundant %SIG assignments from FileCache
23006 [perl #30509] use encoding and "eq" cause memory leak
23074 Segfault using HTML::Entities
23106 Numeric comparison operators mustn't compare addresses of ...
23320 [perl #30066] Memory leak in nested shared data structures
...
23321 [perl #31459] Bug in read()
SPRINTF0 - fixes for sprintf formatting issues - CVE-2005-3962
Built under solaris
Compiled at Feb 13 2006 05:12:02
@INC:
/usr/perl5/5.8.4/lib/sun4-solaris-64int
/usr/perl5/5.8.4/lib
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int
/usr/perl5/site_perl/5.8.4
/usr/perl5/site_perl
/usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int
/usr/perl5/vendor_perl/5.8.4
/usr/perl5/vendor_perl
</pre>



.

Relevant Pages

  • Re: DBD::Oracle Install Mystery
    ... getting trying to install DBD::Oracle: ... Looking at your compile line above I'm guessing you are using Oracle 8.1.6 and that OCI_FETCH_CURRENT was not available in 8.1.6)or at least not defined). ... get a recent instant client and instant client sdk and compile DBD::Oracle against that. ... Perl 5.10 recently installed with gcc, ...
    (perl.dbi.users)
  • Make failure on DBD-Oracle-1.19 "lclntsh: not found" -- Solaris 10
    ... I'm running Perl 5.8.4, DBI-1.54, on Solaris 10. ... I've installed Oracle Instant Client 10.2.0.1. ... sqlplus works fine, I can connect to my database and run queries. ...
    (perl.dbi.users)
  • Re: DBD::oracle DBD::ODBC DBI
    ... What it does not work is the dbd::oracle in the perl program complaint about can not find. ... Perl 5.8, in Solaris 8, running with ORACLE 9i ... Instant client libraries are available separately from ...
    (perl.dbi.users)
  • Re: DBD::Oracle 1.19 fails to find Oracle version, problem and solution
    ... I don't understand your response since the problem I am seeing is that sqlplus will NOT run if ORACLE_HOME is defined and it does not seem related to combining libraries into one. ... Just attempted to install DBD::Oracle 1.19 on an Ubuntu Server 7.04 Feisty machine running Perl v5.8.8 (and instant client 10.2.0.3-20061115) and hit a problem with the Makefile.PL not being able to determine my Oracle version. ... WARNING: The tests will probably fail unless you set ORACLE_HOME yourself! ... You may need to set ORACLE_HOME to your Oracle software directory ...
    (perl.dbi.users)
  • Re: ANNOUNCE: DBD:Oracle 1.18
    ... Well a warning in one compiler is better than and error in an other so I ... This might be a problem more with the older oracle OCI in your client. ... perl -Mblib t/26exe_array.t ...
    (perl.dbi.users)