Getting DBD::Oracle tests working

--=-/7h/9CTtN0LPaqkrxAd/
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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@biplane.com.au) +61-2-64957160 (h)
http://www.biplane.com.au/~kauer/ +61-428-957160 (mob)

--=-/7h/9CTtN0LPaqkrxAd/
Content-Disposition: attachment; filename=cpan_errors.txt
Content-Type: text/plain; name=cpan_errors.txt; charset=UTF-8
Content-Transfer-Encoding: 7bit

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-gcc3 2
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-588-11.11-gcc3 2
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-588-11.00-gcc6 4
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-588-11.11-gcc6 4
DBD-Oracle-1.18/README-files/hpux/Conf-Merijn-588-11.23-gcc6 4
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.ms g
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

--=-/7h/9CTtN0LPaqkrxAd/--

Re: Getting DBD::Oracle tests working

In message <1157121702.8344.276.camel@localhost.localdomain>, Karl Auer writes:
> 9/9 skipped: Unable to connect to Oracle (ORA-12162: TNS:net service n
>ame is incorrectly specified (DBD ERROR: OCIServerAttach))

You did not set TWO_TASK properly.

John
groenveld@acm.org

Re: Getting DBD::Oracle tests working

"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"

Looking at the above means you did not load all of the instantclient files
besides
Instant Client Package - Basic: All files required to run OCI, OCCI, and
JDBC-OCI applications

you need

Instant Client Package - SQL*Plus: Additional libraries and executable for
running SQL*Plus with Instant Client
Instant Client Package - SDK:

as well

all available from Oracle

Re: Getting DBD::Oracle tests working

John Scoles wrote:
> "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"
>
> Looking at the above means you did not load all of the instantclient files
> besides
> Instant Client Package - Basic: All files required to run OCI, OCCI, and
> JDBC-OCI applications
>
> you need
>
> Instant Client Package - SQL*Plus: Additional libraries and executable
> for running SQL*Plus with Instant Client
> Instant Client Package - SDK:
>
> as well
>
> all available from Oracle
>

According to Karl's email he had already installed those packages.
The problem is more likely this:

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.

i.e. /home/kauer/oracle/instantclient is not in his LD_LIBRARY_PATH and
hence sqlplus cannot run because it cannot fine libsqlplus.so.

The install says his LD_LIBRARY_PATH is set to:

/home/kauer/oracle/instantclient/lib

which if IIRC does not exist in instantclient (now?) and DBD::Oracle
creates.

Try again with LD_LIBRARY_PATH set to:

/home/kauer/oracle/instantclient:/home/kauer/oracle/instantc lient/lib

Then you need to set your TWO_TASK or TNS_ADMIN and tnsnames.ora and get
sqlplus working first before running make test.

Martin

Re: Getting DBD::Oracle tests working

Karl Auer wrote:
> 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 :-)

Here are the steps I used

A complete client installation is not needed to install DBD::Oracle. At
a minimum copy over from $ORACLE_HOME the directories:

bin
lib
network
oracore
rdbms
sqlplus

Set the following environment variables

export ORACLE_HOME=
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:/$ORACLE_HOME/bin

Set TWO_TASK appropriately. This varies depending on the type of
connection used. For example, if you use tnsnames.ora for resolution:

export TWO_TASK=

You should now be able to connect with:

$ sqlplus /

Build the module:

$ perl Makefile.PL
$ make

Set a user/pass for testing

$ export ORACLE_USERID=/

Test

$ make test

Install

$ sudo make install

Before using it is a good idea to link libclntsh.so somewhere "normal".

/usr/lib/libclntsh.so.10.1 ->
/mp001/app/oracle/product/10/lib/libclntsh.so.10.1


--
Stephen Carville
Unix and Network Admin
Nationwide Totalflood
6033 W. Century Blvd
Los Angeles, CA 90045
310-342-3602

Re: Getting DBD::Oracle tests working

On Fri, 2006-09-01 at 10:56 -0400, John D Groenveld wrote:
> In message <1157121702.8344.276.camel@localhost.localdomain>, Karl Auer writes:
> > 9/9 skipped: Unable to connect to Oracle (ORA-12162: TNS:net service n
> >ame is incorrectly specified (DBD ERROR: OCIServerAttach))
>
> You did not set TWO_TASK properly.

This seems the most plausible answer so far. When I set it as follows:

export TWO_TASK=T:my_db_host_name:some_id

it takes longer to fail, indicating it is doing something over the net.
The error messages are the same though.

To the person who realised I had the wrong LD_LIBRARY_PATH - thank you,
I sent the wrong output. I had added /lib to the end of the correct path
in quiet desperation. In earlier and leter attempts with the right
library path it still issued the above error messages, just not the one
about "error while loading shared libraries" :-)

To the person who said "copy this and that from ORACLE_HOME", thanks,
but I don't HAVE an ORACLE_HOME, I'm trying to use the instant client.
My machine does not have any other Oracle software installed.

I have emailed the person responsible for the database I want to use and
asked him to tell me what exactly I should have in TWO_TASK. Personally
I now suspect I have the wrong value for "some_id" above.

Is 'scott/tiger' some well-known user/password that is always present in
any Oracle install?

Regards, K.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~
Karl Auer (kauer@biplane.com.au) +61-2-64957160 (h)
http://www.biplane.com.au/~kauer/ +61-428-957160 (mob)

Re: Getting DBD::Oracle tests working

On 9/1/06, Karl Auer wrote:
> Is 'scott/tiger' some well-known user/password that is always present in
> any Oracle install?

It is a default login - but sensible Oracle admins either change the
password or disable (remove?) the account altogether.

See "Database Hacker's Handbook" for more information. See also Ron
Ben-Natan's "Implementing Database Security and Auditing".

--
Jonathan Leffler #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."

Re: Getting DBD::Oracle tests working

I am still trying to get a connection using InstantClient. InstantClient
is installed according to the instructions and I can start sqlplus.

I've given up on TWO_TASK for two reasons:

a) it is incomprehensible, and none of the stuff I have found on the net
(yes, NONE) actually gives a concrete example with real values.

b) what little I have found that made sense appears to be saying that
TWO_TASK refers to aliases specified elsewhere, such as in TNSNAMES.ORA.

I have had some success by simply specifying everything on the sqlplus
command line, but have run out of syntax! sqlplus runs, and I get this
error message:

ERROR:
ORA-12545: Connect failed because target host or object does not exist

This convinces me that I have successfully got as far as the host
concerned, because that message effectively comes from the listener. If
I specify a non-existent host, I get a quite different message (unable
to resolve host). And the host is pingable.

I have the following items in a TNSNAMES.ORA file that works (from
another machine with TOAD):

- a host name (like blah.bloo.com)
- a service name (like blather)
- a port
- a protocol (TCP)

I also have a username/password that is known to work.

It would be very useful at this point to be told either "put them
together like this on the sqlplus command line" OR "you can't get there
from here" OR anything else that might work :-)

Yours in continuing hope,
K.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~
Karl Auer (kauer@biplane.com.au) +61-2-64957160 (h)
http://www.biplane.com.au/~kauer/ +61-428-957160 (mob)

Re: Getting DBD::Oracle tests working

In message <1157171705.24711.13.camel@localhost.localdomain>, Karl Auer writes:
> export TWO_TASK=T:my_db_host_name:some_id

$ TWO_TASK="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=my_db_host_name)(PORT=1521)))(CONNECT_DATA=(SID=some_s id)))"
$ export TWO_TASK
$ make test

John
groenveld@acm.org

Re: Getting DBD::Oracle tests working

On Sun, 2006-09-03 at 18:47 -0400, John D Groenveld wrote:
> In message <1157171705.24711.13.camel@localhost.localdomain>, Karl Auer writes:
> > export TWO_TASK=T:my_db_host_name:some_id
>
> $ TWO_TASK="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=my_db_host_name)(PORT=1521)))(CONNECT_DATA=(SID=some_s id)))"
> $ export TWO_TASK
> $ make test

That did it - almost. I had to use SERVICE_NAME instead of SID, and had
to try several variations on the name I'd been given (grrr) but
eventually I got further.

I'm now getting "bad username or password", so I'm connecting with the
host and instance, which is major progress in itself. I guess
scott/tiger have been removed from the DB I'm trying to install with, so
the current plan is to find an Oracle instance that still has them (or
some usable alternative).

Regards, K.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~
Karl Auer (kauer@biplane.com.au) +61-2-64957160 (h)
http://www.biplane.com.au/~kauer/ +61-428-957160 (mob)

Re: Getting DBD::Oracle tests working

Well, I've gotten a very greatdeal further. The DB people pointed me at
a test system that still had scott/tiger and opened up that account's
permissions so it could create the necessary test tables.

It's down to one warning and one error now; the gist of it is these two
lines (no doubt folded by my mailer):

t/26exe_array...........DBD::Oracle::st execute_array warning:
ORA-24381: error(s) in array DML (DBD SUCCESS_WITH_INFO: error possibly
near <*> indicator at char 66 in 'INSERT INTO dbd_ora__drop_me ( row_1,
row_2, row_3) VALUES (:p1,:<*>p2,:p3)') [for Statement "INSERT INTO
dbd_ora__drop_me ( row_1, row_2, row_3) VALUES (?,?,?)" with
ParamValues: :p3=undef, :p1=undef, :p2=undef] at t/26exe_array.t line
77.

t/31lob.................DBD::Oracle::db selectrow_array failed:
ORA-00942: table or view does not exist (DBD ERROR: error possibly near
<*> indicator at char 103 in '
SELECT cache_lobs + nocache_lobs AS temp_lob_count
FROM v$temporary_lobs templob,
<*>v$session sess
WHERE sess.sid = templob.sid
AND sess.audsid = userenv('sessionid') ') [for Statement "
SELECT cache_lobs + nocache_lobs AS temp_lob_count
FROM v$temporary_lobs templob,
v$session sess
WHERE sess.sid = templob.sid
AND sess.audsid = userenv('sessionid') "] at t/31lob.t line 58.

# Failed test (t/31lob.t at line 166)
# got: undef
# expected: '0'
# Looks like you failed 1 test of 9.
dubious
Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 9
Failed 1/9 tests, 88.89% okay

I think only the latter one is actually holding me up, because the
summary at the end says only one test failed:

t/70meta................Failed 1/20 test scripts, 95.00% okay. 1/934
subtests failed, 99.89% okay.
ok
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ -------------------
t/31lob.t 1 256 9 1 11.11% 9
4 tests and 122 subtests skipped.
make: *** [test_dynamic] Error 255
/usr/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force

Any ideas gratefully received!

Regards, K.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~
Karl Auer (kauer@biplane.com.au) +61-2-64957160 (h)
http://www.biplane.com.au/~kauer/ +61-428-957160 (mob)

Re: Getting DBD::Oracle tests working

Success!

Thanks to help from you (and my DB admins getting a working scott/tiger
account going) I have finally managed to install DBD::Oracle!

The following might be of interest to someone. Every test run throws up
this warning:

Warning: the following files are missing in your kit:
META.yml
Please inform the author.

The absence of this file doesn't seem to have any serious effect, or any
effect at all. Also, when running the tests I get this warning:

t/26exe_array...........DBD::Oracle::st execute_array warning:
ORA-24381: error(s) in array DML (DBD SUCCESS_WITH_INFO: error possibly
near <*> indicator at char 66 in 'INSERT INTO dbd_ora__drop_me ( row_1,
row_2, row_3) VALUES (:p1,:<*>p2,:p3)') [for Statement "INSERT INTO
dbd_ora__drop_me ( row_1, row_2, row_3) VALUES (?,?,?)" with
ParamValues: :p3=undef, :p1=undef, :p2=undef] at t/26exe_array.t line
77.

Again, this doesn't seem to be particularly serious, and the install
proceeds anyway.

It skips quite a lot of tests "for various reasons".

Regards, K.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~
Karl Auer (kauer@biplane.com.au) +61-2-64957160 (h)
http://www.biplane.com.au/~kauer/ +61-428-957160 (mob)

Re: Getting DBD::Oracle tests working

----- Original Message -----
From: "Karl Auer"
To:
Sent: Wednesday, September 06, 2006 9:20 AM
Subject: Re: Getting DBD::Oracle tests working


> Success!
>
> Thanks to help from you (and my DB admins getting a working scott/tiger
> account going) I have finally managed to install DBD::Oracle!

if you actually read the READMEs you will find that you can bypass this by
setting the ORACLE_USERID enviornment variable

like this in windows

Set ORACLE_USERID=test/test@test

or in linux

export ORACLE_USERID=test/test@test


>
> The following might be of interest to someone. Every test run throws up
> this warning:
>
> Warning: the following files are missing in your kit:
> META.yml
> Please inform the author.
>
> The absence of this file doesn't seem to have any serious effect, or any
> effect at all. Also, when running the tests I get this warning:
>
> t/26exe_array...........DBD::Oracle::st execute_array warning:
> ORA-24381: error(s) in array DML (DBD SUCCESS_WITH_INFO: error possibly
> near <*> indicator at char 66 in 'INSERT INTO dbd_ora__drop_me ( row_1,
> row_2, row_3) VALUES (:p1,:<*>p2,:p3)') [for Statement "INSERT INTO
> dbd_ora__drop_me ( row_1, row_2, row_3) VALUES (?,?,?)" with
> ParamValues: :p3=undef, :p1=undef, :p2=undef] at t/26exe_array.t line
> 77.
>

> Again, this doesn't seem to be particularly serious, and the install
> proceeds anyway.

You are right this is a deliberate error that is testing to see if an error
in the tuple is returned. So you can ignore it.

>
> It skips quite a lot of tests "for various reasons".
>

Yep it does that depending on how Oracle was installed. Mostly to do with in
which format (UTF8,UTF16 etc) the DB is storing data
> Regards, K.
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~
> Karl Auer (kauer@biplane.com.au) +61-2-64957160 (h)
> http://www.biplane.com.au/~kauer/ +61-428-957160 (mob)
>
>

Re: Getting DBD::Oracle tests working

On Wed, 2006-09-06 at 09:30 -0400, John Scoles wrote:
> if you actually read the READMEs you will find that you can bypass this by
> setting the ORACLE_USERID enviornment variable

I did read the READMEs.

Regardless of the userid, you need a user with certain privileges if you
want the tests to run OK.

Since there was no appropriate user available to me, my admins had to
set one up. It was easiest to go with scott/tiger.

Regards, K.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~
Karl Auer (kauer@biplane.com.au) +61-2-64957160 (h)
http://www.biplane.com.au/~kauer/ +61-428-957160 (mob)

Re: Getting DBD::Oracle tests working

----- Original Message -----
From: "Karl Auer"
To:
Sent: Wednesday, September 06, 2006 9:36 AM
Subject: Re: Getting DBD::Oracle tests working


> On Wed, 2006-09-06 at 09:30 -0400, John Scoles wrote:
>> if you actually read the READMEs you will find that you can bypass this
>> by
>> setting the ORACLE_USERID enviornment variable
>
> I did read the READMEs.
>
> Regardless of the userid, you need a user with certain privileges if you
> want the tests to run OK.

good point I will add that to the READMEs

or if you wat you can write something up and I will add it.

>
> Since there was no appropriate user available to me, my admins had to
> set one up. It was easiest to go with scott/tiger.
>
> Regards, K.
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~
> Karl Auer (kauer@biplane.com.au) +61-2-64957160 (h)
> http://www.biplane.com.au/~kauer/ +61-428-957160 (mob)
>
>

Re: Getting DBD::Oracle tests working

On Wed, 2006-09-06 at 09:48 -0400, John Scoles wrote:
> > Regardless of the userid, you need a user with certain privileges if you
> > want the tests to run OK.
>
> good point I will add that to the READMEs
>
> or if you wat you can write something up and I will add it.

"The tests assume that a user 'scott' with password 'tiger' is
available, and that this user has sufficient privileges to create,
insert into, select from and drop a table, and to select from system
tables like 'v$sessions'. You can change the user and password used by
the tests by setting ORACLE_USERID appropriately, but whichever user ID
you use, ensure it has the appropriate privileges."

Regards, K.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~
Karl Auer (kauer@biplane.com.au) +61-2-64957160 (h)
http://www.biplane.com.au/~kauer/ +61-428-957160 (mob)

Re: Getting DBD::Oracle tests working

Ok I will put it in the next version.
Most likely I will work on it next week so I can get a new version out at
the end of the month.

Cheers
John Scoles

----- Original Message -----
From: "Karl Auer"
To:
Sent: Wednesday, September 06, 2006 10:08 AM
Subject: Re: Getting DBD::Oracle tests working


> On Wed, 2006-09-06 at 09:48 -0400, John Scoles wrote:
>> > Regardless of the userid, you need a user with certain privileges if
>> > you
>> > want the tests to run OK.
>>
>> good point I will add that to the READMEs
>>
>> or if you wat you can write something up and I will add it.
>
> "The tests assume that a user 'scott' with password 'tiger' is
> available, and that this user has sufficient privileges to create,
> insert into, select from and drop a table, and to select from system
> tables like 'v$sessions'. You can change the user and password used by
> the tests by setting ORACLE_USERID appropriately, but whichever user ID
> you use, ensure it has the appropriate privileges."
>
> Regards, K.
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~
> Karl Auer (kauer@biplane.com.au) +61-2-64957160 (h)
> http://www.biplane.com.au/~kauer/ +61-428-957160 (mob)
>
>