Getting DBD::Oracle tests working

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 (kauer@xxxxxxxxxxxxxx) +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

Relevant Pages

  • Re: DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch wont install
    ... Currently all my Oracle inst client files are user oracle group oinstall yet lib bin and other dirs have 755 permission so root should be able to access and execute these softlibs. ... As I have written, I have installed DBD::Oracle-1.19 many times with a full client without problem, yet with the limited instant client it does not find the mk file, and the one mk file that the instant client installs does not work. ... It also gives me a makefile for DBD::Oracle but install and test fail ...
    (perl.dbi.users)
  • RE: Oracle with ActiveState build 8xx
    ... > 8.1.7.4 client lib, ... I have near zero Oracle ... > libs and the OCI ... > they do install ...
    (perl.dbi.users)
  • Re: Running oracle 8 or oracle 9 on RedHat9.x
    ... > because php doesn't work with the oracle 9 client. ... But I know for sure that PHP *does* work with Oracle9 client, ... ./runInstaller again and click "Install client" or something like that. ...
    (RedHat)
  • Re: Adding RAM
    ... About Oracle, I currently use Mysql for my TM databases but I have been ... Limited to a 4GB database but that should be adequate ... The rpm is easy to install and you get a nice tutorial to ... Here's the link to the Oracle-10g + Compiere installation on SuSE ...
    (alt.os.linux.suse)
  • Re: Upgrade 8i to 9i --- multiple oracle_base !!!!!!
    ... > it's own system owning account. ... > 1) Install one copy of the latest version of SQL-Backtrack into its own ... completely separate from any Oracle directories. ... > 2) Shutdown and cold backup both databases. ...
    (comp.databases.oracle.server)