> 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 >
That version of DBI is over 2 years old so I doubt it will work with DBD::Oracle 1.17. You might want to try upgrading your DBI first. ""MIKE VANOLE"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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' > > >
