topic Re: DBD::Oracle problem in Operating System - HP-UX

DBD::Oracle problem

Keely Jackson — Tue, 18 Nov 2003 10:05:10 GMT

Good Afternoon

I am trying to install the DBD::Oracle 1.1.4 module for Perl. During the 'make test' phase I got loads of errors for unresolved symbols. I have exported all the variables and tried the workaround suggested in the README.hpux adding the libraries to the OTHERLDFLAGS. But now I get the error:

/usr/bin/ld: Can't find library for -lclntsh
*** Error exit code 1

I've searched the forums and am still stuck as to what to try next.

Any suggestions gratefully received.

Thanks
Keely

hp-ux 10.20
perl 5.8.0 (downloaded from Merijns site)
gcc 3.3.2 (also from Merijns site)
oracle 7.3.4

There's nothing like having state of the art technology!

Re: DBD::Oracle problem

H.Merijn Brand (procura — Tue, 18 Nov 2003 10:40:21 GMT

Have you set SHLIB_PATH to where it can find clntsh ?

Modify your Makefile to include -L/your/path/to/oracle/libs

Enjoy, have FUN! H.Merijn

Re: DBD::Oracle problem

Keely Jackson — Tue, 18 Nov 2003 10:47:54 GMT

Hi

The SHLIB_PATH is set to the $ORACLE_HOME/lib which is where the libclntsh.sl file is.

The Makefile already has the lines:

EXTRALIBS = -L/opt/oracle/product/734/lib -lclntsh -lcma -lm -L$(LIBHOME)
LDLOADLIBS = -L/opt/oracle/product/734/lib -lclntsh -lcma -lm
BSLOADLIBS =
LD_RUN_PATH=/opt/oracle/product/734/lib

Should I add it in somewhere else as well?

Thanks
Keely

Re: DBD::Oracle problem

H.Merijn Brand (procura — Tue, 18 Nov 2003 11:41:47 GMT

Have you checked if /opt/oracle/product/734/lib/linclntsh.a or /opt/oracle/product/734/lib/libclntsh.sl actually does exist and has the correct architecture? If not, maybe you forgot to install the part of Oracle that installs it.

I still hace a dangling libclntsh.sl of 2693584 ytes dated 23 Aug 2002 for v7341

what about adding -l:libclntsh.sl

Enjoy, have FUN! H.Merijn

Re: DBD::Oracle problem

Keely Jackson — Tue, 18 Nov 2003 12:25:15 GMT

Hello again

Yes, I have checked the file exists. I don't have a libclntsh.a but I do have the file libclntsh.sl in the directory. It is older than yours but the same size so I guess they are the same.

How do I check that it is for the correct architecture?

Thanks for your help so far.

Cheers
Keely

Re: DBD::Oracle problem

H.Merijn Brand (procura — Tue, 18 Nov 2003 12:28:16 GMT

# file libclntsh.sl

did the -l: work?

Enjoy, have FUN! H.Merijn

Re: DBD::Oracle problem

Keely Jackson — Tue, 18 Nov 2003 12:32:25 GMT

Hi

The file is:

libclntsh.sl: s800 shared library -not stripped

so yes, it is for the right architecture.

No, I haven't tried adding the -l. Next question, where do I add it?

Thanks again

Keely

Re: DBD::Oracle problem

Phil Storer — Mon, 24 Nov 2003 00:23:04 GMT

Keely, I had many problems similar to you trying to install the DBD-Oracle module using the gcc compiler. I ended up using HP's C/ANSI compiler.
I've put together a document showing the steps in on the install starting from the perl source code. Most of these instructions were lifted from 'Garry Ferguson' crib sheet which I used to solve my problems.
So if your still having problems try the steps shown in the attached doco.
Note ignore the reference to Cordaptix

Re: DBD::Oracle problem

H.Merijn Brand (procura — Mon, 24 Nov 2003 02:13:15 GMT

Hmm, sorry late reply.

You will have to add it in the Makefile. Search for -l and -L options, where you will recognize sortlike options.

FWIW DBD::Oracle-1.15 is about to be released, and Ralph Grothe has also tested it on HP-UX and after reading and re-reading README.hpux he got a full success with Oracle 9

If you want it, tell me, and I'll post you the link to the latest beta

Enjoy, have FUN! H.Merijn

Re: DBD::Oracle problem

Keely Jackson — Mon, 24 Nov 2003 04:11:31 GMT

Hi Phil and Merijn

Thanks for the docs and info.

I tried adding the -l in the obvious places in the Makefile and I still got errors. At that point I gave up and installed the whole lot on a hp-ux 11.0 oracle 8.1.7. I am waiting to hear if it is ok.

As all these systems are all being upgraded to 11i and oralce 9 soon and this is a 'nice to play around with' for somebody, rather than waste more of everybody's time, I will wait until after the upgrade to install it properly.

From what I have seen in my searches, something tells me I will back to ask more questions.

Many thanks for your time and help.

Cheers
Keely