Upgrading is something I would love to do, but can't at this time. I have, however, tried DBD-Oracle 1.15 and 1.16 with the same error. I was hoping 1.17 would work. I was glad to see it available. I'm pretty sure it's an Oracle installation or evnironment issue. I just don't know where else to look for help.
Thanks. ""John Scoles"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > 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' > > > > > > > >
