DBD::Oracle install problem On Solaris 8

I am trying to install DBD 1.3 with DBI 1.37 on Solaris and the database version is Oracle 9.2.
When I run the make command it returns the following error:

In file included from Oracle.h:20,
from Oracle.xs:1:
dbdimp.h:44: ocidfn.h: No such file or directory
dbdimp.h:57: ociapr.h: No such file or directory
make: *** [Oracle.o] Error 1

Env: Teamsite 5.5.2 SP6 on Solaris 8
Thanks
-H

Find more posts tagged with

Comments

nipper

do you hav either of those includes on the system ?

find / -name ocidfn.h -print

If so, then edit te makefile and put that in the include path.

herald10

I was able to remove those errors by installing OCI libraries but now I am facing the following problem.

/usr/local/sparc-sun-solaris2.8/bin/ld: cannot find -lclntsh
collect2: ld returned 1 exit status

Any body aware of this error?

Thanks
-H

iwovGraduate

You might want to search google for "ld: cannot find -lclntsh".
You will possibly find a bunch of discussion about this on threads related to DBI/Oracle/Solaris.

I just did that and found quite a few references.

mk2004

Follow this thread http://devnet.interwoven.com/forums/cgi-bin/showflat.pl?Cat=&Board=perl&Number=47147&page=0&view=collapsed&sb=5&o=&part=

herald10

I tried to reinstall the Oracle client. I am getting errors like the
following:
Error in invoking target relink of makefile ins_precomp.mk, and a whole bunch of other mk relink errors. I kept ignoring them. And finally the installer reported the following error:
ld.so.1:
/export/home/oracle/jre/1.1.8/bin/../bin/sparc/native_threads/jre:
fatal: libclntsh.so.9.0: open failed: No such file or directory
(/export/home/oracle/OraHome1/lib/libnjni9.so)
Error loading native library: libnjni9.so.
java.lang.UnsatisfiedLinkError: jniGetOracleHome
at oracle.net.common.NetGetEnv.getOracleHome(Compiled Code)
at oracle.net.ca.CmdlineArgs.setOraArgs(Compiled Code)
at oracle.net.ca.NetCA.<init>(Compiled Code)
at oracle.net.ca.NetCA.main(Compiled Code)

Since I don't have libclntsh.so.9.0 in the lib directory I tried to generate it using genclntsh command. But it throws errors like
./genclntsh
Undefined first referenced
symbol in file
nnfyboot /export/home/oracle/OraHome1/lib/libn9.a(nnfgt.o)
ld: fatal: Symbol referencing errors. No output written to /export/home/oracle/OraHome1/lib/libclntsh.so.9.0
cat: cannot open /tmp/clntst9.5548/*.nm
sort: can't stat /tmp/clntst9.5548/*.objs: No such file or directory
usage: ar -d[-vV] archive file ...
ar -m[-abivV] [posname] archive file ...
ar -p[-vV][-s] archive [file ...]
ar -q[-cuvV] [-abi] [posname] [file ...]
ar -r[-cuvV] [-abi] [posname] [file ...]
ar -t[-vV][-s] archive [file ...]
ar -x[-vV][-sCT] archive [file ...]
ar: creating /export/home/oracle/OraHome1/lib/libclntst9.a
Created /export/home/oracle/OraHome1/lib/libclntst9.a

Completely stumped as to whats going on.

Any help is appreciated
Thanks
-H

chandraiw

how are you trying to reinstall oracle client?
Did you happen to install DBI before trying to install Oracle DBD?

Adam Stoller

What version of what compiler are you using?
what version of what assember are you using?
Do you have the 32-bit version of the Oracle client software installed?
Do you have the additional headers and (32-bit) libraries from the Oracle server installation copied over (as mentioned in the DBD: Smiley Surprised

racle README* files)?
What other steps did you take prior to trying to invoke 'make' to build and install DBD: Smiley Surprised

racle?

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com

herald10

Thanks for your responses guys. I was able to resove the issue. Two packages were not installed properly. SUNWsprot and SUNWsra. Here is a list of packages that have to be present on the Solaris box for the installation of Oracle client and DBD module to succeed.

for tools (sccs, lex, yacc, make, nm, truss, ld, as):
SUNWbtool, SUNWsprot, SUNWtoo

for libraries & headers:
SUNWhea, SUNWarc, SUNWlibm, SUNWlibms
SUNWdfbh, SUNWcg6h, SUNWxwinc, SUNWolinc,
SUNWxglh

for 64 bit development:
SUNWarcx, SUNWbtoox, SUNWdplx, SUNWscpux, SUNWsprox,
SUNWtoox, SUNWlmsx, SUNWlmx, SUNWlibCx

for ucb compat:
SUNWsra, SUNWsrh

Also make sure that you are using as,ld from SUN not the gcc one. This can be done by putting /usr/ccb/bin ahead of /usr/local/bin in the PATH.

Thanks
-H