RE: DBD::Oracle: make test fails:another solution found

[Byars, James D Contractor/NCCIM]

Here's my build environment:

HP/UX 11.0 on a RISC2 N Class Box
Oracle 8.1.6
Perl 5.6
DBI-1.14
DBD-Oracle-1.06

Here's how I got mine to work:

I built perl using:  ./Configure -Dusethreads
I took the default answer on everything except for the libs.  I changed them
from:
libs = -lnsl -lnm -lndbm -lmalloc -ldld -lm -lpthread -lc -lndir -lcrypt -lsec
to:
libs = -lnsl -lnm -lndbm -lmalloc -ldld -lm -lpthread -lcl -lndir -lcrypt -lsec
(I just changed the -lc to -lcl)
I then did my make and make install for perl.

Next, I built DBI-1.14 normally:
perl Makefile.PL
make
make test
make install

Now, for the good part.  Here's how I built DBD-Oracle-1.06:

I tried the DBD static build as outlined in the README.help file.

perl Makefile.PL LINKTYPE=static
make
make perl
make test FULLPERL=./perl 
*DBD passed the make test!*
make install

I then ran:  make -f Makefile.aperl inst_perl MAP_TARGET=perl
This copies the perl binary you made above to your runtime directory.

Jim



-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 4:31 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: DBD::Oracle: make test fails: solution found


[EMAIL PROTECTED] wrote:
> 
> Hello,
> 
> I have a slight problem finishing my install of DBD-Oracle. I have read
> the list archive, and tried the solutions but to no avail. I would very
> much appreciate any hints of what to do to solve the problem.


I have found a solution for this problem. 
Instead of using this new library built by Oracle, the
libclntsh.so.8.0,I have put all the libraries by themselves (well almost
all - I might have to add some others?)
which means in the Makefile, I changed the LDLOADLIBS to:

LDLOADLIBS = -L/usr/local/oracle/app/oracle/product/8.1.7/lib/  -ln8
-lclient8 -lclntst8 -lvsn8 -lcommon8 -lgeneric8 -lmm -lntns8 -lcore8 
-lnl8 -lc -laio -lm  -lc

I do not know if all these libraries are needed - but these look like
the ones I used with Oracle7 .

Now - I have no more problems with loading the libraries, and the test
runs successfully.


Hope this helps 

PatRTome



> 
> Config:
> perl 5.6.0
> DBI - 1.14
> DBD-1.06
> Oracle 8.1.7
> Compaq - OSF 5.1  (true 64)
> C compiler from compaq
> 
> Problem:
> make test fails with unresolved symbols:
> t/general...........install_driver(Oracle) failed: Can't load
> 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: dlopen:
> blib/arch/auto/DBD/Oracle/Oracle.so: symbol "upihst" unresolved at
> /usr/local/lib/perl5/5.6.0/alpha-dec_osf/DynaLoader.pm line 200.