Ok 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 a lot guys Hemanth -----Original Message----- From: Hemanth Kumar Sent: Thursday, April 21, 2005 10:38 AM To: 'dbi-users@perl.org' Cc: [EMAIL PROTECTED] Subject: RE: :Oracle install problem On Solaris 8 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 Hemanth -----Original Message----- From: Hemanth Kumar Sent: Wednesday, April 20, 2005 4:24 PM To: 'Reidy, Ron'; Michael Nhan Cc: dbi-users@perl.org Subject: RE: :Oracle install problem On Solaris 8 Ron, I'm Sorry for not getting the name right. 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) Do you know why this is happening? Thanks Hemanth -----Original Message----- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 19, 2005 7:54 PM To: Hemanth Kumar; Michael Nhan Cc: dbi-users@perl.org Subject: RE: :Oracle install problem On Solaris 8 Yes. And the name is Ron. -----Original Message----- From: Hemanth Kumar [mailto:[EMAIL PROTECTED] Sent: Tue 4/19/2005 4:44 PM To: Reidy, Ron; Michael Nhan Cc: dbi-users@perl.org Subject: RE: :Oracle install problem On Solaris 8 Randy, yeah that's what it looks like. So do you suggest I uninstall everything and do it from the scratch? Thanks Hemanth -----Original Message----- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 19, 2005 5:45 PM To: Reidy, Ron; Hemanth Kumar; Michael Nhan Cc: dbi-users@perl.org Subject: RE: :Oracle install problem On Solaris 8 You will need the full client install. -----Original Message----- From: Reidy, Ron Sent: Tue 4/19/2005 4:43 PM To: Hemanth Kumar; Michael Nhan Cc: dbi-users@perl.org Subject: RE: :Oracle install problem On Solaris 8 I reiterate - you have a bad install! -- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Hemanth Kumar [mailto:[EMAIL PROTECTED] Sent: Tue 4/19/2005 4:28 PM To: Michael Nhan Cc: dbi-users@perl.org Subject: RE: :Oracle install problem On Solaris 8 Sqlplus doesn't run properly. It throws the following error. ld.so.1: ./sqlplus: fatal: libclntsh.so.9.0: open failed: No such file or directory Killed I have only the client installed on the box. Not sure whats wrong. Thanks for your help Hemanth -----Original Message----- From: Michael Nhan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 19, 2005 4:50 PM To: Hemanth Kumar Cc: dbi-users@perl.org Subject: RE: :Oracle install problem On Solaris 8 Okay, does your oracle client work? Can you connect to the oracle server using the sqlplus with your present client install? > Date: Tue, 19 Apr 2005 16:40:43 -0500 > From: Hemanth Kumar <[EMAIL PROTECTED]> > To: Michael Nhan <[EMAIL PROTECTED]> > Cc: dbi-users@perl.org > Subject: RE: :Oracle install problem On Solaris 8 > > The thing is the lib directory under ORACLE_HOME doesn't have the file > libclntsh.so.9.0 either. > > > Thanks > Hemanth > > > -----Original Message----- > From: Michael Nhan [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 19, 2005 4:39 PM > To: Hemanth Kumar > Cc: dbi-users@perl.org; [EMAIL PROTECTED] > Subject: RE: :Oracle install problem On Solaris 8 > > just make a link from libclntsh.so.9.0 to libclntsh.so (ln -s > libclntsh.so.9.0 libclntsh.so) > > >> Date: Tue, 19 Apr 2005 16:36:16 -0500 >> From: Hemanth Kumar <[EMAIL PROTECTED]> >> To: Michael Nhan <[EMAIL PROTECTED]> >> Cc: dbi-users@perl.org, [EMAIL PROTECTED] >> Subject: RE: :Oracle install problem On Solaris 8 >> >> But I don't have the file libclntsh.so under ORACLE_HOME/lib. So I > tried >> to generate the file by running $ORACLE_HOME/bin/genclntsh which > throws >> the following error: >> >> 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.3879/*.nm >> sort: can't stat /tmp/clntst9.3879/*.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 >> >> >> When I run the the make command with -s option and the symbol nnfyboot >> it returns the following >> searching oracle lib/libn9.a ... >> [12] | 0| 0|NOTY |GLOB |0 |UNDEF |nnfyboot >> >> Please find the log file of make and all the steps mentioned in the >> README file by Tim. >> >> Thanks >> Hemanth >> >> >> -----Original Message----- >> From: Michael Nhan [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, April 19, 2005 4:23 PM >> To: Hemanth Kumar >> Cc: dbi-users@perl.org >> Subject: RE: :Oracle install problem On Solaris 8 >> >> include oracle_home/lib in your ld_library_path >> >> >>> Date: Tue, 19 Apr 2005 13:14:34 -0500 >>> From: Hemanth Kumar <[EMAIL PROTECTED]> >>> To: Hemanth Kumar <[EMAIL PROTECTED]>, dbi-users@perl.org >>> Subject: RE: :Oracle install problem On Solaris 8 >>> >>> 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 >>> Hemanth >>> >>> >>> -----Original Message----- >>> From: Hemanth Kumar [mailto:[EMAIL PROTECTED] >>> Sent: Tuesday, April 19, 2005 12:19 PM >>> To: dbi-users@perl.org >>> Subject: 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 >>> >>> Any ideas please... >>> >>> Thanks >>> Hemanth >>> >>> >> >> ---//--- >> "He who learns must suffer. And even in our sleep, pain that >> cannot forget, falls drop by drop upon the heart; and, in our own >> despair, against our will, comes wisdom to us by the awful grace of >> God." >> --- Aeschylus >> > > ---//--- > "He who learns must suffer. And even in our sleep, pain that > cannot forget, falls drop by drop upon the heart; and, in our own > despair, against our will, comes wisdom to us by the awful grace of > God." > --- Aeschylus > > ---//--- "He who learns must suffer. And even in our sleep, pain that cannot forget, falls drop by drop upon the heart; and, in our own despair, against our will, comes wisdom to us by the awful grace of God." --- Aeschylus This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system. This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system. This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.