Hi, I've googled my error and have seen similar problems, but no solutions are found.
/usr/local/sparc-sun-solaris2.8/bin/ld: cannot find -lclntsh I'm trying to install any version of DBD::Oracle on Solaris 2.8, with perl 5.6.1. Currently trying DBD-Oracle 1.17. My Oracle environment is set up and working as far as I can tell by using sqlplus successfully. My current solution for Perl and Oracle invloves using open3 and sqlplus, and I have to get away from this. My problem may be library related but I've tried numerous combinations of LD_LIBRARY_PATH, etc... Many thanks in advance. Mike Here's the output from my latest attempt: # perl Makefile.PL Using DBI 1.40 (for perl 5.006001 on sun4-solaris) installed in /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DB I Configuring DBD::Oracle for perl 5.006001 on solaris (sun4-solaris) Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /apps/oracle/product/9.2.0 DEFINE _SQLPLUS_RELEASE = "902000100" (CHAR) Oracle version 9.2.0.1 (9.2) Found /apps/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk Found /apps/oracle/product/9.2.0/precomp/demo/proc/demo_proc.mk Using /apps/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk Your LD_LIBRARY_PATH env var is set to '/apps/oracle/product/9.2.0/lib64:/apps/oracle/product/9.2.0/lib32' Reading /apps/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk Reading /apps/oracle/product/9.2.0/rdbms/lib/env_rdbms.mk Attempting to discover Oracle OCI build rules gcc -c DBD_ORA_OBJ.c by executing: [make -f /apps/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo ge nclntsh' CC=true OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o] Oracle oci build prolog: [Building client shared library libclntsh.so ...] [Call script /apps/oracle/product/9.2.0/bin/genclntsh ...] [genclntsh] [Built /apps/oracle/product/9.2.0/lib/libclntsh.so ... DONE] Oracle oci build command: [true -L/apps/oracle/product/9.2.0/lib32/ -L/apps/oracle/product/9.2.0/rdbms /lib32/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat /apps/oracle/product/9.2.0/lib/sysliblist` -R/apps/oracle/product/9.2.0/lib -laio -lposix4 -lkstat -lm -lthread] Found header files in /apps/oracle/product/9.2.0/rdbms/demo /apps/oracle/product/9.2.0/rdbms/public. Checking for functioning wait.ph System: perl5.006001 sunos solaris 5.8 generic sun4u sparc sunw,ultra-5_10 Compiler: gcc -O -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE _OFFSET_BITS=64 Linker: /usr/ccs/bin/ld Sysliblist: -lnsl -lsocket -lgen -ldl -lsched Oracle makefiles would have used these definitions but we override them: CC: cc CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) [$(GFLAG) -xO3 $(CDEBUG) -Xa $(PROFILE) -xstrconst -dalign -xF $(XS) $(MR) -xildoff -errtags=yes -v -xarch=v9 -xchip=ultra3 -W2,-AKNR_S -Wd,-xsafe=unboundsym -Wc,-Qiselect-funcalign=32 - xcode=abs44 -Wc,-Qgsched-trace_late=1 -Wc,-Qg sched-T5 -xalias_level=weak -D_REENTRANT -DSS_64BIT_SERVER -DBIT64 -DMACHINE 64 -K PIC -I/apps/oracle/product/9.2.0/rdbms/ demo -I/apps/oracle/product/9.2.0/rdbms/public -I/apps/oracle/product/9.2.0/ plsql/public -I/apps/oracle/product/9.2.0/net work/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD -D_REENTRANT $(LPFLAGS) $(USRFLAGS)] LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) [-o $@ -L/apps/oracle/product/9.2.0/rdbms/lib/ -L$(LIBHOME)] Linking with OTHERLDFLAGS = -L/apps/oracle/product/9.2.0/lib32/ -L/apps/oracle/product/9.2.0/rdbms/lib 32/ -lclntsh `c at /apps/oracle/product/9.2.0/lib/sysliblist` -R/apps/oracle/product/9.2.0/lib -laio -lposix4 -lkstat -lm -lthread [fro m 'build' rule] WARNING: If you have problems you may need to rebuild perl with threading enabled. WARNING: If you have problems you may need to rebuild perl with -Uusemymalloc. Checking if your kit is complete... Looks good LD_RUN_PATH=/apps/oracle/product/9.2.0/lib32:/apps/oracle/product/9.2.0/rdbm s/lib32 Using DBD::Oracle 1.17. Using DBI 1.40 (for perl 5.006001 on sun4-solaris) installed in /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DB I Writing Makefile for DBD::Oracle *** If you have problems... read all the log printed above, and the README and README.help.txt files. (Of course, you have read README by now anyway, haven't you?) # make Skip blib/lib/DBD/Oracle.pm (unchanged) Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged) Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged) Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged) Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged) Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged) Skip blib/lib/oraperl.ph (unchanged) Skip blib/lib/Oraperl.pm (unchanged) /bin/sh -c true /bin/sh -c true /usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/Driver.xst > Oracle. xsi /usr/bin/perl -I/usr/local/lib/perl5/5.6.1/sun4-solaris -I/usr/local/lib/per l5/5.6.1 /usr/local/lib/perl5/5.6.1/ExtUtils/ xsubpp -typemap /usr/local/lib/perl5/5.6.1/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Ora cle.c gcc -c -I/apps/oracle/product/9.2.0/rdbms/demo -I/apps/oracle/product/9.2.0/ rdbms/public -I/apps/oracle/product/9.2.0/rdb ms/demo -I/apps/oracle/product/9.2.0/rdbms/public -I/apps/oracle/product/9.2 .0/plsql/public -I/apps/oracle/product/9.2.0/ network/public -I/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI -fno-strict-aliasing -I/usr/local/include -D_ LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.17\" -DXS_VERSION=\ "1.17\" -fPIC -I/usr/local/lib/perl5/5.6. 1/sun4-solaris/CORE -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_O CI_VERSION=\"9.2.0.1\" Oracle.c Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_append': Oracle.xs:201: warning: unused variable `startp' Oracle.c: At top level: /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/dbipport.h:529: warning: `my_sv_2pvbyte' defined but not used gcc -c -I/apps/oracle/product/9.2.0/rdbms/demo -I/apps/oracle/product/9.2.0/ rdbms/public -I/apps/oracle/product/9.2.0/rdb ms/demo -I/apps/oracle/product/9.2.0/rdbms/public -I/apps/oracle/product/9.2 .0/plsql/public -I/apps/oracle/product/9.2.0/ network/public -I/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI -fno-strict-aliasing -I/usr/local/include -D_ LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.17\" -DXS_VERSION=\ "1.17\" -fPIC -I/usr/local/lib/perl5/5.6. 1/sun4-solaris/CORE -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_O CI_VERSION=\"9.2.0.1\" dbdimp.c dbdimp.c: In function `dbd_discon_all': dbdimp.c:142: warning: unused variable `Perl___notused' dbdimp.c: In function `ora_db_login6': dbdimp.c:264: warning: unused variable `Perl___notused' dbdimp.c: In function `ora_db_disconnect': dbdimp.c:712: warning: unused variable `Perl___notused' dbdimp.c: In function `ora_db_destroy': dbdimp.c:749: warning: unused variable `Perl___notused' dbdimp.c: In function `dbd_rebind_ph_char': dbdimp.c:1052: warning: value computed is not used dbdimp.c: In function `pp_exec_rset': dbdimp.c:1218: warning: unused variable `Perl___notused' dbdimp.c: In function `ora_st_execute': dbdimp.c:1596: warning: unused variable `Perl___notused' dbdimp.c: In function `ora_st_finish': dbdimp.c:1803: warning: unused variable `Perl___notused' dbdimp.c: In function `ora_st_destroy': dbdimp.c:1895: warning: unused variable `Perl___notused' dbdimp.c: At top level: /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/dbipport.h:529: warning: `my_sv_2pvbyte' defined but not used gcc -c -I/apps/oracle/product/9.2.0/rdbms/demo -I/apps/oracle/product/9.2.0/ rdbms/public -I/apps/oracle/product/9.2.0/rdb ms/demo -I/apps/oracle/product/9.2.0/rdbms/public -I/apps/oracle/product/9.2 .0/plsql/public -I/apps/oracle/product/9.2.0/ network/public -I/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI -fno-strict-aliasing -I/usr/local/include -D_ LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.17\" -DXS_VERSION=\ "1.17\" -fPIC -I/usr/local/lib/perl5/5.6. 1/sun4-solaris/CORE -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_O CI_VERSION=\"9.2.0.1\" oci8.c oci8.c: In function `fetch_func_varfield': oci8.c:537: warning: value computed is not used oci8.c: In function `fetch_func_nty': oci8.c:568: warning: value computed is not used oci8.c: In function `fetch_cleanup_rset': oci8.c:582: warning: unused variable `Perl___notused' oci8.c: In function `fetch_func_rset': oci8.c:626: warning: value computed is not used oci8.c:606: warning: unused variable `Perl___notused' oci8.c: In function `dbd_rebind_ph_lob': oci8.c:711: warning: value computed is not used oci8.c: In function `ora_blob_read_mb_piece': oci8.c:747: warning: value computed is not used oci8.c:755: warning: value computed is not used oci8.c:763: warning: value computed is not used oci8.c:791: warning: value computed is not used oci8.c: In function `ora_blob_read_piece': oci8.c:851: warning: value computed is not used oci8.c:858: warning: value computed is not used oci8.c:865: warning: value computed is not used oci8.c:895: warning: value computed is not used oci8.c:908: warning: long unsigned int format, ub4 arg (arg 9) oci8.c:925: warning: value computed is not used oci8.c: In function `fetch_func_autolob': oci8.c:994: warning: value computed is not used oci8.c:1027: warning: value computed is not used oci8.c:1036: warning: value computed is not used oci8.c:1056: warning: value computed is not used oci8.c: In function `sth_set_row_cache': oci8.c:1199: warning: long unsigned int format, ub4 arg (arg 3) oci8.c:1199: warning: long unsigned int format, ub4 arg (arg 4) oci8.c: In function `ora_st_fetch': oci8.c:1550: warning: unused variable `Perl___notused' oci8.c:1557: warning: unused variable `Perl___notused' oci8.c:1617: warning: value computed is not used oci8.c:1636: warning: value computed is not used oci8.c: In function `post_execute_lobs': oci8.c:2118: warning: value computed is not used oci8.c:2121: warning: value computed is not used oci8.c: At top level: /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/dbipport.h:529: warning: `my_sv_2pvbyte' defined but not used oci8.c:563: warning: `fetch_func_nty' defined but not used Running Mkbootstrap for DBD::Oracle () chmod 644 Oracle.bs rm -f blib/arch/auto/DBD/Oracle/Oracle.so LD_RUN_PATH="/apps/oracle/product/9.2.0/lib32:/apps/oracle/product/9.2.0/rdb ms/lib32" gcc -G -L/usr/local/lib Oracle.o dbdimp.o oci8.o -L/apps/oracle/product/9.2.0/lib32/ -L/apps/oracle/product/9.2.0/rdbm s/lib32/ -lclntsh `cat /apps/or acle/product/9.2.0/lib/sysliblist` -R/apps/oracle/product/9.2.0/lib -laio -l posix4 -lkstat -lm -lthread -o blib/arch/au to/DBD/Oracle/Oracle.so /usr/local/sparc-sun-solaris2.8/bin/ld: cannot find -lclntsh collect2: ld returned 1 exit status *** Error code 1 make: Fatal error: Command failed for target `blib/arch/auto/DBD/Oracle/Oracle.so'
