Re: DBD::Oracle install problems
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
DBD::Oracle install problems
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
Re: DBD::Oracle install problems
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
Re: MacOSX DBD::Oracle install problems with libclntsh
On Tue, Aug 17, 2004 at 06:34:35PM +0100, Tim Barrass wrote: Hi all- hopefully I'm not just repeating a problem everyone knows about, had a search but not found much- anyhow: Installing DBD::Oracle fails for me on generating the Makefile- it's related to some manual modification of libclntsh required, which I believe I've done correctly. Session and output below, here are my details: Darwin Kernel Version 7.5.0 (Mac OSX 10.3.5) Perl v5.8.1-RC3 built for darwin-thread-multi-2level Oracle client runtime installation 10g Release 1 (10.1.0.3) for Apple MAC OS X DBD::Oracle 1.15 Feel free to reply tersely with a pointer to the solution if necessary.. Retry with http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc6-20040807.tar.gz and then again with rc7 whenever that gets announced (this week I hope). Tim.
MacOSX DBD::Oracle install problems with libclntsh
Hi all- hopefully I'm not just repeating a problem everyone knows about, had a search but not found much- anyhow: Installing DBD::Oracle fails for me on generating the Makefile- it's related to some manual modification of libclntsh required, which I believe I've done correctly. Session and output below, here are my details: Darwin Kernel Version 7.5.0 (Mac OSX 10.3.5) Perl v5.8.1-RC3 built for darwin-thread-multi-2level Oracle client runtime installation 10g Release 1 (10.1.0.3) for Apple MAC OS X DBD::Oracle 1.15 Feel free to reply tersely with a pointer to the solution if necessary.. Many thanks, Tim $ export $ORACLE_HOME=/Users/oracle/OraHome_1/ $ cd /sw/lib/perl5/5.8.1/DBD-Oracle-1.15 $ nmedit -R ./hints/macos_lib.syms /Users/oracle/OraHome_1/lib/libclntsh.dylib.10.1 medit: symbols names listed in: ./hints/macos_lib.syms not in: /Users/oracle/OraHome_1/lib/libclntsh.dylib.10.1 _dlclose _dlsym _poll $ perl Makefile.PL Using DBI 1.43 (for perl 5.008001 on darwin-thread-multi-2level) installed in /Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBI Configuring DBD::Oracle ... Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /Users/oracle/OraHome_1/ WARNING: could not decode oracle version from /Users/oracle/OraHome_1//orainst/inspdver, or /Users/oracle/OraHome_1//install/unix.rgs or from ORACLE_HOME path /Users/oracle/OraHome_1/. Oracle version based logic in Makefile.PL may produce erroneous results. ERROR: symbol table needs modification in Oracle library: /Users/oracle/OraHome_1//lib/libclntsh.dylib Manual modification required - see README.macosx