Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> I got it working: Re: Help! DBD::Oracle installation problem

I got it working: Re: Help! DBD::Oracle installation problem

From: Joe Edwards <cleanh2o_at_cleanh2o.com>
Date: 2000/04/14
Message-ID: <Pine.LNX.4.05.10004141705170.2459-100000@cleanh2o.com> 







Hope this helps, Joe Edwards



I had the same problem with:


Oracle8.1.6

Perl5.00503
DBI-1.13
DBD-1.03




Solaris2.6



I was already using the oracle libraries, including
libclntsh.so.8.0, with oci no problem.  So this problem
affects DBD:Oracle and not oci. (DBD:Oracle does use oci
but I am using oci with a fairly complex web search algorithm
(the lab search in www.genetests.org uses oci, the clinic
 search that I wrote more recently uses java + jdbc)).



I linked up a different


DBD-Oracle-1.03/blib/arch/auto/DBD/Oracle/Oracle.so
and now I have DBD:Oracle running.  And I've tested it with
several scripts that I was using on a linux box to generate
some complex reports from oracle data.



I essentially forced Oracle.so to use /usr/java/lib/libjava.so.
I'm not sure that this is all that I did though.
I am not an expert at this so I would appreciate comments.
And perhaps a DBD:Oracle fix.



Here's what I did:       


set:


LD RUN PATH=/u01/app/oracle/product/8.1.6/lib:/usr/lib:/usr/java/lib
LD LIBRARY PATH=/u01/app/oracle/product/8.1.6/lib:/u01/app/oracle/product
/8.1.6/jdbc/lib/:/usr/java/lib 



run gcc again after running DBD-Oracle-1.03/make like so:
(I hand edited this item. I couldn't see how to alter Makefile.pl.
 Could someone perhaps enlighten me about how to?)
gcc -o blib/arch/auto/DBD/Oracle/Oracle.so -R/lib -R/usr/ccs/lib \
-R/usr/lib -G -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o \

/u01/app/oracle/product/8.1.6/rdbms/lib/ssdbaed.o \
/u01/app/oracle/product/8.1.6/rdbms/lib/defopt.o \
/u01/app/oracle/product/8.1.6/lib/nautab.o \
/u01/app/oracle/product/8.1.6/lib/naeet.o \
/u01/app/oracle/product/8.1.6/lib/naect.o \
/u01/app/oracle/product/8.1.6/lib/naedhs.o -L/usr/java/lib -lncrypt8 \
-lthread -ljava -L/u01/app/oracle/product/8.1.6/lib -lnbeq8 -lnhost8 \
-ln8 -lnidx8 -lnus8 -lnk58 -lnldap8 -lldapclnt8 -lnsslb8 -lnoname8 \
-lnrad8 -lnsid8 -lntcp8 -lntcps8 -lnent8 -lntns8 -lclient8 -lvsn8 \
-lwtc8 -lcommon8 -lgeneric8 -lmm -lnls8 -lcore8 -ltrace8 -lnsl \


-lsocket -lgen -ldl -lsched -laio -lposix4 -lkstat -lm -lc -lmp \
-lsql8 -lpls8 -lnl8 -lnro8 -lclntsh -locijdbc8 -locijdbc8 g -ljox8



Here's the test.pl output:



DBD-Oracle-1.03> make test


PERL DL NONLAZY/usr/local/bin/perl -Iblib/arch -Iblib/lib
-I/usr/local/lib/perl5/5.00503/sun4-solaris -I/usr/local/lib/perl5/5.00503
-e 'use Test::Harness qw(&runtests $verbose); $verbose
'

t/*.t
t/base..............ok
t/general...........ok
t/long..............ok
t/plsql.............ok
t/reauth............skipping test on this platform


All tests successful, 1 test skipped.


Files  Tests"4, 14 wallclock secs ( 3.77 cusr +  0.94 csys =  4.
71


CPU)



PERL DL NONLAZY/usr/local/bin/perl -Iblib/arch -Iblib/lib
-I/usr/local/lib/perl5/5.00503/sun4-solaris -I/usr/local/lib/perl5/5.00503
test.pl


Oraperl test application $Revision: 1.2 $
Oraperl emulation interface version 1.39 
DBD::Oracle 1.03 using OCI8 by Tim Bunce
DBI 1.13 by Tim Bunce


Oracle.so relinked by Joe Edwards


Data sources:

        dbi:Oracle:EXTPROC CONNECTION DATA
        dbi:Oracle:ORACLE




Connecting


 to 'oracle' (from command line, else uses ORACLE SID or TWO TASK -
recommended)


 as 'scott/tiger' (via ORACLE USERID env var or default -
recommend name/passwd_at_dbname)


(ORACLE SID='oracle', TWO TASK='')



Testing internal row fetch overhead.


50000 fetches:  2 wallclock secs ( 1.10 usr +  0.00 sys =  1.10 CPU)
25000 per clock second, 45454 per cpu second



Fields:    5


Names:     'NUM T'      'DATE T'        'CHAR T'        'ROWID T'
'NULL T'


Lengths:   134  76      31      21      1
OraTypes:  2    12      1       104     1
SQLTypes:  3    9       12      -9104   12
Scale:     0    0       0       0       0
Precision: 38   75      30      20      0
Nullable:  1    1       1       1       1


Est row width:    45


Data rows:


    fetch: '7.2', '14-APR-00', 'SCOTT', 'AAAADDAABAAAAHSAAA', undef



csr reassigned (forces destruction)...


Fetch list of tables:

Fetched: DUAL
Fetched: SYSTEM PRIVILEGE MAP
Fetched: TABLE PRIVILEGE MAP
Fetched: STMT AUDIT OPTION MAP




Test ora do with harmless non-select statement (set transaction read only)
Expect an 'ORA-01453' error message:


ora do: 1453: ORA-01453: SET TRANSACTION must be first statement of
transaction (DBD ERROR: OCIStmtExecute)


csr out of scope...


ora logoff...


lda out of scope...



Testing repetitive connect/open/close/disconnect:
Expect sequence of digits, no other messages:
1 2 3 4 5 



Test interaction of explicit close/logoff and implicit DESTROYs
Expect just 'done.', no other messages:


done.



Testing row cache (5).


Test completed in 1 seconds.



Test complete (4 seconds).


If the tests above have produced the 'expected' output then they have
passed.






On Thu, 13 Apr 2000 thcitro_at_my-deja.com wrote:



> We are trying to do the same thing and

> getting the exact same errors. Any information that

> you may find out to solve this would be very helpful.

> 

> Thanks,

> Tab

> 

> In article <38F5D9F1.DA70502C_at_cismsun.univ-lyon1.fr>,

>   mclaire <mclaire_at_cismsun.univ-lyon1.fr> wrote:

> > can anybody help us?

> > we are trying to install DBD:Oracle.

> > we have successfully installed these pkgs to a DIGITAL UNIX 4.0C

> > Oracle8.1.5

> > Perl-5.6

> > DBI-1.13


> > DBD-1.03


> > we have set the user envirment (ie, ORACLE HOME, ORACLE SID etc)

> > it seems that it is ok in the step 'perl Makefile.PL' and 'make'

> > when gose on with 'make test' step. it gose wrong with this message:

> > -------------------------------------

> > $ make test

> >

> > PERL DL NONLAZY/bin/perl -Iblib/arch -Iblib/lib

> > -I/usr/local/lib/pe

> > rl5/5.6.0/alpha-dec osf -I/usr/local/lib/perl5/5.6.0 -e

> > 'use Test::Har

> > ness qw(&runtests $verbose); $verbose

> > @ARGV;' t/*.t

> > t/base..............install driver(Oracle) failed:

> > Can't load 'blib/ar

> > ch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:

> > dlopen: cannot l

> > oad blib/arch/auto/DBD/Oracle/Oracle.so at

> > /usr/local/lib/perl5/5.6.0/

> > alpha-dec osf/DynaLoader.pm line 200.

> >  at (eval 1) line 3

> > Compilation failed in require at (eval 1) line 3.

> >

> >  at t/base.t line 17

> >

> > t/base..............dubious

> >         Test returned status 255 (wstat 65280, 0xff00)

> > DIED. FAILED tests 4-5

> >         Failed 2/5 tests, 60.00% okay

> > t/general...........install driver(Oracle) failed:

> > Can't load 'blib/ar

> > ch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:

> > dlopen: cannot l

> > oad blib/arch/auto/DBD/Oracle/Oracle.so at

> > /usr/local/lib/perl5/5.6.0/

> > alpha-dec osf/DynaLoader.pm line 200.

> >  at (eval 1) line 3

> > Compilation failed in require at (eval 1) line 3.

> >

> >  at t/general.t line 20

> >

> > t/general...........dubious

> >         Test returned status 255 (wstat 65280, 0xff00)

> > t/long..............Can't load

> > 'blib/arch/auto/DBD/Oracle/Oracle.so' f

> > or module DBD::Oracle: dlopen: cannot load

> > blib/arch/auto/DBD/Oracle/O

> > racle.so at

> > /usr/local/lib/perl5/5.6.0/alpha-dec osf/DynaLoader.pm

> > lin

> > e 200.

> >  at t/long.t line 4

> > Compilation failed in require at t/long.t line 4.

> > BEGIN failed--compilation aborted at t/long.t line 4.

> >

> > t/long..............dubious

> >         Test returned status 255 (wstat 65280, 0xff00)

> > t/plsql.............Can't load

> > 'blib/arch/auto/DBD/Oracle/Oracle.so' f

> > or module DBD::Oracle: dlopen: cannot load

> > blib/arch/auto/DBD/Oracle/O

> > racle.so at

> > /usr/local/lib/perl5/5.6.0/alpha-dec osf/DynaLoader.pm

> > lin

> > e 200.

> >  at t/plsql.t line 17

> > Compilation failed in require at t/plsql.t line 17.

> > BEGIN failed--compilation aborted at t/plsql.t line 17.

> >

> > t/plsql.............dubious

> >         Test returned status 255 (wstat 65280, 0xff00)

> > t/reauth............skipped test on this platform

> > Failed Test  Status Wstat Total Fail  Failed  List of

> > failed

> > -------------------------------------------------------

> > ---------------

> > ---------

> > t/base.t        255 65280     5    2  40.00%  4-5

> > t/general.t     255 65280    ??   ??       %  ??

> > t/long.t        255 65280    ??   ??       %  ??

> > t/plsql.t       255 65280    ??   ??       %  ??

> > 1 test skipped.

> > Failed 4/5 test scripts, 20.00% okay. 2/5 subtests

> > failed, 60.00% okay

> > .

> > *** Exit 2

> > Stop.

> >

> > --

> > Marie-Claire Legeard

> > CISM, Universit  Claude Bernard Lyon I et INSA de Lyon

> > --

> >

> 

> 

> Sent via Deja.com http://www.deja.com/

> Before you buy.

> 

> 




-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-


    The keeper of the Wastewater Engineering Virtual Library (WWEVL)
    the WWEVL URL = http://www.cleanh2o.com/
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
Received on Fri Apr 14 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US