Hi there.
In common apparently with many others, I can't seem to get DBD::Oracle
installed with the InstantClient. It was retrieved OK from CPAN, and
appears to build OK, but many tests fail and the install is stopped as a
result.
Attached is the output from one install attempt. It seems that many
tests fail with essentially the same message, about a service being
incorrectly configured.
So I'd like to know two things.
Firstly, is there some obvious thing I've missed that will make the
tests work?
Secondly, if not, can I/should I force the install? Attempts to use
sqlplus bring the same error message, so I'm guessing not.
As far as Oracle is concerned, I simply downloaded the three packages
basic, sdk and sqlplus, unpacked them all in a directory, and have set
that directory to be LD_LIBRARY_PATH and ORACLE_HOME. For good measure,
I set ORACLE_USERID to be 'scott/tiger', though that seems unnecessary
and doesn't help :-)
Regards, K.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Karl Auer ([EMAIL PROTECTED]) +61-2-64957160 (h)
http://www.biplane.com.au/~kauer/ +61-428-957160 (mob)
CPAN: Storable loaded ok
Going to read /home/kauer/.cpan/Metadata
Database was generated on Thu, 31 Aug 2006 11:32:19 GMT
Running install for module DBD::Oracle
Running make for P/PY/PYTHIAN/DBD-Oracle-1.18a.tar.gz
CPAN: Digest::MD5 loaded ok
Checksum for
/home/kauer/.cpan/sources/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.18a.tar.gz ok
Scanning cache /home/kauer/.cpan/build for sizes
DBD-Oracle-1.18/
DBD-Oracle-1.18/Oracle.ex/
DBD-Oracle-1.18/Oracle.ex/ex.pl
DBD-Oracle-1.18/Oracle.ex/sql
DBD-Oracle-1.18/Oracle.ex/japh
DBD-Oracle-1.18/Oracle.ex/oradump.pl
DBD-Oracle-1.18/Oracle.ex/curref.pl
DBD-Oracle-1.18/Oracle.ex/commit.pl
DBD-Oracle-1.18/Oracle.ex/mktable.pl
DBD-Oracle-1.18/Oracle.ex/bind.pl
DBD-Oracle-1.18/Oracle.ex/tabinfo.pl
DBD-Oracle-1.18/Oracle.ex/proc.pl
DBD-Oracle-1.18/Oracle.ex/README
DBD-Oracle-1.18/Oraperl.pm
DBD-Oracle-1.18/ocitrace.h
DBD-Oracle-1.18/hints/
DBD-Oracle-1.18/hints/svr4.pl
DBD-Oracle-1.18/hints/dgux.pl
DBD-Oracle-1.18/hints/macos_lib.syms
DBD-Oracle-1.18/hints/macos_bundle.syms
DBD-Oracle-1.18/hints/macos_syms.pl
DBD-Oracle-1.18/Todo
DBD-Oracle-1.18/README.login.txt
DBD-Oracle-1.18/oci8.c
DBD-Oracle-1.18/README.sec.txt
DBD-Oracle-1.18/README-files/
DBD-Oracle-1.18/README-files/hpux/
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-588-10.20-gcc
DBD-Oracle-1.18/README-files/hpux/libjava.eml
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-588-11.00-gcc32
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-588-11.11-gcc32
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-588-11.00-gcc64
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-588-11.11-gcc64
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-588-11.23-gcc64
DBD-Oracle-1.18/README-files/hpux/Conf-Roger
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-580-10.20-cc
DBD-Oracle-1.18/README-files/hpux/Conf-Lincoln-1.06
DBD-Oracle-1.18/README-files/hpux/Conf-Lincoln-1.07
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-585-11.00-cc
DBD-Oracle-1.18/README-files/hpux/Conf-Mike
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-585-11.11-cc
DBD-Oracle-1.18/README-files/hpux/Makefile-Lincoln
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-587-11.23-cc
DBD-Oracle-1.18/README.java.txt
DBD-Oracle-1.18/README.aix.txt
DBD-Oracle-1.18/README.longs.txt
DBD-Oracle-1.18/err_unicode/
DBD-Oracle-1.18/err_unicode/err_twolongstr.msg
DBD-Oracle-1.18/err_unicode/err_char.msg
DBD-Oracle-1.18/README.hpux.txt
DBD-Oracle-1.18/err_docs/
DBD-Oracle-1.18/err_docs/err_trace.msg
DBD-Oracle-1.18/README.macosx.txt
DBD-Oracle-1.18/README.help.txt
DBD-Oracle-1.18/lib/
DBD-Oracle-1.18/lib/DBD/
DBD-Oracle-1.18/lib/DBD/Oracle/
DBD-Oracle-1.18/lib/DBD/Oracle/GetInfo.pm
DBD-Oracle-1.18/oraperl.ph
DBD-Oracle-1.18/MANIFEST
DBD-Oracle-1.18/oci.def
DBD-Oracle-1.18/Changes
DBD-Oracle-1.18/err_unsorted/
DBD-Oracle-1.18/err_unsorted/err_xmltypebindplsql.msg
DBD-Oracle-1.18/err_unsorted/err_ora9ir2oci.msg
DBD-Oracle-1.18/err_unsorted/err_xml2.msg
DBD-Oracle-1.18/err_unsorted/err_svrparse.msg
DBD-Oracle-1.18/err_unsorted/err_refcsr_slow.msg
DBD-Oracle-1.18/err_unsorted/err_refcsr_rowcache.msg
DBD-Oracle-1.18/err_unsorted/err_etherreal.msg
DBD-Oracle-1.18/err_unsorted/err_slowcsr.msg
DBD-Oracle-1.18/err_unsorted/err_multiora.msg
DBD-Oracle-1.18/err_unsorted/err_ref_type.msg
DBD-Oracle-1.18/err_unsorted/err_memleak2.msg
DBD-Oracle-1.18/err_unsorted/err_xml.msg
DBD-Oracle-1.18/README.linux.txt
DBD-Oracle-1.18/README.wingcc.txt
DBD-Oracle-1.18/MANIFEST.SKIP
DBD-Oracle-1.18/ora_explain.PL
DBD-Oracle-1.18/README.win32.txt
DBD-Oracle-1.18/README.vms.txt
DBD-Oracle-1.18/dbivport.h
DBD-Oracle-1.18/typemap
DBD-Oracle-1.18/dbdimp.c
DBD-Oracle-1.18/Oracle.pm
DBD-Oracle-1.18/err_bind/
DBD-Oracle-1.18/err_bind/err_bind_param_inout_overrun_bug.msg
DBD-Oracle-1.18/err_bind/err_bindclobleak.msg
DBD-Oracle-1.18/err_bind/err_bindnullhash.msg
DBD-Oracle-1.18/err_bind/err_bindarrays.msg
DBD-Oracle-1.18/err_bind/err_trailingblank.msg
DBD-Oracle-1.18/err_lob/
DBD-Oracle-1.18/err_lob/err_lobtesttblfail.msg
DBD-Oracle-1.18/err_lob/err_loblenwide.msg
DBD-Oracle-1.18/err_lob/err_csr_clob.msg
DBD-Oracle-1.18/err_lob/err_nulllobsegv.msg
DBD-Oracle-1.18/err_lob/err_tmplobfree.msg
DBD-Oracle-1.18/err_lob/err_nclob_form.msg
DBD-Oracle-1.18/Makefile.PL
DBD-Oracle-1.18/dbdimp.h
DBD-Oracle-1.18/Oracle.xs
DBD-Oracle-1.18/test.pl
DBD-Oracle-1.18/Oracle.h
DBD-Oracle-1.18/README
DBD-Oracle-1.18/t/
DBD-Oracle-1.18/t/26exe_array.t
DBD-Oracle-1.18/t/10general.t
DBD-Oracle-1.18/t/31lob.t
DBD-Oracle-1.18/t/23wide_db_8bit.t
DBD-Oracle-1.18/t/20select.t
DBD-Oracle-1.18/t/50cursor.t
DBD-Oracle-1.18/t/24implicit_utf8.t
DBD-Oracle-1.18/t/22nchar_al32utf8.t
DBD-Oracle-1.18/t/nchar_test_lib.pl
DBD-Oracle-1.18/t/23wide_db_al32utf8.t
DBD-Oracle-1.18/t/55nested.t
DBD-Oracle-1.18/t/21nchar.t
DBD-Oracle-1.18/t/70meta.t
DBD-Oracle-1.18/t/60reauth.t
DBD-Oracle-1.18/t/25plsql.t
DBD-Oracle-1.18/t/15nls.t
DBD-Oracle-1.18/t/30long.t
DBD-Oracle-1.18/t/23wide_db.t
DBD-Oracle-1.18/t/22nchar_utf8.t
DBD-Oracle-1.18/t/01base.t
DBD-Oracle-1.18/t/40ph_type.t
DBD-Oracle-1.18/err_build/
DBD-Oracle-1.18/err_build/err_solarisnotes.msg
DBD-Oracle-1.18/err_build/err_hpux_ld.msg
DBD-Oracle-1.18/err_build/err_hpuxsuccess.msg
DBD-Oracle-1.18/err_build/err_aix64.msg
DBD-Oracle-1.18/err_build/err_memleak.msg
DBD-Oracle-1.18/err_build/err_makefileundef.msg
DBD-Oracle-1.18/err_build/err_instantclient.msg
DBD-Oracle-1.18/err_build/err_testfailnotable.msg
DBD-Oracle-1.18/mkta.pl
DBD-Oracle-1.18/README.explain.txt
DBD-Oracle-1.18/README.clients.txt
Removing previously used /home/kauer/.cpan/build/DBD-Oracle-1.18
CPAN.pm: Going to build P/PY/PYTHIAN/DBD-Oracle-1.18a.tar.gz
Using DBI 1.48 (for perl 5.008007 on i486-linux-gnu-thread-multi) installed in
/usr/lib/perl5/auto/DBI/
Configuring DBD::Oracle for perl 5.008007 on linux (i486-linux-gnu-thread-multi)
Remember to actually *READ* the README file! Especially if you have any
problems.
Using Oracle in /home/kauer/oracle/instantclient
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open
shared object file: No such file or directory
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 '/home/kauer/oracle/instantclient/lib'
Oracle sysliblist:
Found header files in /home/kauer/oracle/instantclient/sdk/include.
Checking for functioning wait.ph
System: perl5.008007 linux rothera 2.6.10 #1 smp fri may 13 09:24:22 utc 2005
i686 gnulinux
Compiler: cc -O2 -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN
-fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64
Linker: /usr/bin/ld
Sysliblist:
Linking with -lclntsh.
Checking if your kit is complete...
Warning: the following files are missing in your kit:
META.yml
Please inform the author.
LD_RUN_PATH=/home/kauer/oracle/instantclient
Using DBD::Oracle 1.18.
Using DBD::Oracle 1.18.
Using DBI 1.48 (for perl 5.008007 on i486-linux-gnu-thread-multi) installed in
/usr/lib/perl5/auto/DBI/
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help.txt files.
(Of course, you have read README by now anyway, haven't you?)
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp mkta.pl blib/lib/DBD/mkta.pl
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/lib/perl5/auto/DBI//Driver.xst >
Oracle.xsi
/usr/bin/perl /usr/share/perl/5.8/ExtUtils/xsubpp -typemap
/usr/share/perl/5.8/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc
&& mv Oracle.xsc Oracle.c
cc -c -I/home/kauer/oracle/instantclient/sdk/include
-I/usr/lib/perl5/auto/DBI/ -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.18\" -DXS_VERSION=\"1.18\" -fPIC
"-I/usr/lib/perl/5.8/CORE" -Wall -Wno-comment -DUTF8_SUPPORT
-DORA_OCI_VERSION=\"8.0.0.0\" Oracle.c
cc -c -I/home/kauer/oracle/instantclient/sdk/include
-I/usr/lib/perl5/auto/DBI/ -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.18\" -DXS_VERSION=\"1.18\" -fPIC
"-I/usr/lib/perl/5.8/CORE" -Wall -Wno-comment -DUTF8_SUPPORT
-DORA_OCI_VERSION=\"8.0.0.0\" dbdimp.c
cc -c -I/home/kauer/oracle/instantclient/sdk/include
-I/usr/lib/perl5/auto/DBI/ -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.18\" -DXS_VERSION=\"1.18\" -fPIC
"-I/usr/lib/perl/5.8/CORE" -Wall -Wno-comment -DUTF8_SUPPORT
-DORA_OCI_VERSION=\"8.0.0.0\" oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/home/kauer/oracle/instantclient" cc -shared -L/usr/local/lib
Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so
-L/home/kauer/oracle/instantclient -lclntsh
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
Manifying blib/man1/ora_explain.1p
Manifying blib/man3/DBD::Oracle.3pm
Manifying blib/man3/DBD::Oraperl.3pm
/usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
t/01base................ok
t/10general.............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-33
Failed 33/33 tests, 0.00% okay
t/15nls.................ok
9/9 skipped: Unable to connect to Oracle (ORA-12162: TNS:net service
name is incorrectly specified (DBD ERROR: OCIServerAttach))
t/20select..............skipped
all skipped: no reason given
t/21nchar...............skipped
all skipped: Not connected to oracle
t/22nchar_al32utf8......skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/22nchar_utf8..........skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/23wide_db.............skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/23wide_db_8bit........skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/23wide_db_al32utf8....skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/24implicit_utf8.......skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/25plsql...............skipped
all skipped: no reason given
t/26exe_array...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-13
Failed 12/13 tests, 7.69% okay
t/30long................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-376
Failed 376/376 tests, 0.00% okay
t/31lob.................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/40ph_type.............skipped
all skipped: no reason given
t/50cursor..............skipped
all skipped: no reason given
t/55nested..............skipped
all skipped: no reason given
t/60reauth..............skipped
all skipped: no reason given
t/70meta................skipped
all skipped: no reason given
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/10general.t 255 65280 33 66 200.00% 1-33
t/26exe_array.t 255 65280 13 24 184.62% 2-13
t/30long.t 255 65280 376 752 200.00% 1-376
t/31lob.t 255 65280 9 18 200.00% 1-9
14 tests and 9 subtests skipped.
/usr/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force
