Skip Menu |

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 27153
Status: rejected
Priority: 0/
Queue: DBD-Oracle
People
Owner: Nobody in particular
Requestors: David.Himber [...] jpmchase.com
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Wed May 16 10:43:29 2007 David.Himber [...] jpmchase.com - Ticket created
CC: robert.i.kislin [...] jpmchase.com
Subject: Installation issues on Solaris 10, Oracle 10g
Date: Wed, 16 May 2007 10:41:31 -0400
To: bug-DBD-Oracle [...] rt.cpan.org
From: David.Himber [...] jpmchase.com
Did not work well with perl version bundled with solaris 10 (This is perl, v5.8.4 built for sun4-solaris-64int) Upgraded to perl 5.8.8 from sunfreeware, DBI 1.56 and DBD 1.19 and it didn't help Added some debugging stmts to Makefile.PL Even though it knows it is a 32 bit perl, the Makefile references oracle_home/lib instead of lib32. So when u installed and executed at runtime would get error about ELFCLASS mismatch, unless you had LD_LIBRARY_PATH explicitly set to have lib32. This doesn't work since some of our binaries use 64 bit so can't use LD_LIBRARY_PATH like that. Finally manually edited the generated Makefile LD_RUN_PATH = /apps/oracle/product/10.2.0/db_3/lib32 :/apps/oracle/product/10.2.0/db_3/rdbms/lib32 OTHERLDFLAGS = -xarch=v9 -L/apps/oracle/product/10.2.0/db_3/lib32/ -L/apps/oracle/product/10.2.0/db_3/rdbms/lib32/ -lclntsh `cat /apps/oracle/product/10.2.0/db_3/lib32/sysliblist` -R/apps/oracle/product/10.2.0/db_3/lib32 -laio -lposix4 -lkstat -lm -lthread -lpthread Show quoted text
ezpclu2>uname -a
SunOS ezpclu2 5.10 Generic_118833-24 sun4u sparc SUNW,Ultra-Enterprise Show quoted text
ezpclu2>perl -v
This is perl, v5.8.8 built for sun4-solaris perl Makefile.PL.DH 2>&1 | tee x.txt Multiple copies of Driver.xst found in: /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/ /usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/auto/DBI/ at Makefile.PL.DH line 35 Using DBI 1.56 (for perl 5.008008 on sun4-solaris) installed in /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/ Configuring DBD::Oracle for perl 5.008008 on solaris (sun4-solaris) Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /apps/oracle/product/10.2.0/db_3 DEFINE _SQLPLUS_RELEASE = "1002000300" (CHAR) Oracle version 10.2.0.3 (10.2) Found /apps/oracle/product/10.2.0/db_3/rdbms/demo/demo_rdbms.mk Using /apps/oracle/product/10.2.0/db_3/rdbms/demo/demo_rdbms.mk IN ORA_LIBDIR IN ORA_LIBDIR: CLIENT_VERSION: 10.2 PERL is 32 bit Your LD_LIBRARY_PATH env var is set to '/usr/lib:/apps/oracle/product/10.2.0/db_3/lib32:/usr/java/lib:/usr/java/jre/lib/sparc:/usr/local/lib:/opt/SUNWspro/lib' IN ORA_LIBDIR IN ORA_LIBDIR: CLIENT_VERSION: 10.2 PERL is 32 bit Reading /apps/oracle/product/10.2.0/db_3/rdbms/demo/demo_rdbms.mk Reading /apps/oracle/product/10.2.0/db_3/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/10.2.0/db_3/rdbms/demo/demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' 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/10.2.0/db_3/bin/genclntsh ...] [genclntsh] [Built /apps/oracle/product/10.2.0/db_3/lib/libclntsh.so ... DONE] Oracle oci build command: [true -xarch=v9 -L/apps/oracle/product/10.2.0/db_3/lib/ -L/apps/oracle/product/10.2.0/db_3/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat /apps/oracle/product/10.2.0/db_3/lib/sysliblist` -R/apps/oracle/product/10.2.0/db_3/lib -laio -lposix4 -lkstat -lm -lthread -lpthread] Found header files in /apps/oracle/product/10.2.0/db_3/rdbms/public. Checking for functioning wait.ph System: perl5.008008 sunos 5.10 generic_118822-30 sun4u sparc sunw,ultra-5_10 solaris Compiler: gcc -O -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -I/opt/gnu/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 Linker: /usr/ccs/bin/ld Sysliblist: -lkstat -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,-Qgsched-T5 -xalias_level=weak -D_REENTRANT -DSS_64BIT_SERVER -DBIT64 -DMACHINE64 -K PIC -I/apps/oracle/product/10.2.0/db_3/rdbms/demo -I/apps/oracle/product/10.2.0/db_3/rdbms/public -I/apps/oracle/product/10.2.0/db_3/plsql/public -I/apps/oracle/product/10.2.0/db_3/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD -D_REENTRANT $(LPFLAGS) $(USRFLAGS)] LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) [-o $@ -L/apps/oracle/product/10.2.0/db_3/rdbms/lib/ -L$(LIBHOME)] Linking with OTHERLDFLAGS = -xarch=v9 -L/apps/oracle/product/10.2.0/db_3/lib/ -L/apps/oracle/product/10.2.0/db_3/rdbms/lib/ -lclntsh `cat /apps/oracle/product/10.2.0/db_3/lib/sysliblist` -R/apps/oracle/product/10.2.0/db_3/lib -laio -lposix4 -lkstat -lm -lthread -lpthread [from 'build' rule] WARNING: If you have problems you may need to rebuild perl with threading enabled. Checking if your kit is complete... Looks good IN ORA_LIBDIR IN ORA_LIBDIR: CLIENT_VERSION: 10.2 PERL is 32 bit LD_RUN_PATH=/apps/oracle/product/10.2.0/db_3/lib32:/apps/oracle/product/10.2.0/db_3/rdbms/lib32 Using DBD::Oracle 1.19. Using DBD::Oracle 1.19. Multiple copies of Driver.xst found in: /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/ /usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/auto/DBI/ at Makefile.PL.DH line 1646 Using DBI 1.56 (for perl 5.008008 on sun4-solaris) installed in /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/ 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?) Thanks, David Himber E-ZPay Systems JPMorgan Chase 718-242-1024 3 CMC 3 Fl Brooklyn, NY 11245 ----------------------------------------- This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries and affiliates. This transmission may contain information that is privileged, confidential, legally privileged, and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. Although this transmission and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by JPMorgan Chase & Co., its subsidiaries and affiliates, as applicable, for any loss or damage arising in any way from its use. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. Please refer to http://www.jpmorgan.com/pages/disclosures for disclosures relating to UK legal entities.
  Thu Jan 31 11:37:03 2008 leelen.pillay [...] gmail.com - Correspondence added
From: leelen.pillay [...] gmail.com
Heja! All, This is a working installation procedure on Solaris 10(SPARC) export PATH=/usr/bin:/usr/sfw/bin/:/usr/local/bin:/usr/ccs/bin/:/mediation/perl/bin/:$PATH DBI ---- ~/perl/bin/perl Makefile.PL LIB=~/perl/lib INSTALLMAN1DIR=~/perl/man/man1 INSTALLMAN3DIR=~/perl/man/man3 /usr/ccs/bin/make /usr/ccs/bin/make test /usr/ccs/bin/make install -------Modification to the DBD-Oracle -------Current(Makefile.PL) sub find_bin{ use filetest 'access'; my $bin = shift; my $path_sep = $Config{path_sep}; foreach (split(/\Q$path_sep/, $ENV{PATH})){ return "$_/$bin" if -x "$_/$bin"; } return undef; } PS: When run on Solaris this does not find many of the required binaries mainly Linker ie. ld -------Current -------Proposed(Makefile.PL) sub find_bin{ use filetest 'access'; my $bin = shift; my $path_sep = $Config{path_sep}; foreach (split(/\Q$path_sep/, $ENV{PATH})){ return "$_/$bin" if -x "$_/$bin"; } return undef; } -------Proposed(Makefile.PL) DBD-Oracle ---- export PERL5LIB=~/perl/lib/sun4-solaris ~/perl/bin/perl Makefile.PL $ORACLE_HOMEsdk/demo/demo.mk LIB=~/perl/lib INSTALLMAN1DIR=~/perl/man/man1 INSTALLMAN3DIR=~/perl/man/man3 /usr/ccs/bin/make /usr/ccs/bin/make test /usr/ccs/bin/make install ThanX LEelen On Wed May 16 10:43:29 2007, David.Himber@jpmchase.com wrote: Show quoted text
> Did not work well with perl version bundled with solaris 10 (This is > perl, > v5.8.4 built for sun4-solaris-64int) > Upgraded to perl 5.8.8 from sunfreeware, DBI 1.56 and DBD 1.19 and it > didn't help > Added some debugging stmts to Makefile.PL > Even though it knows it is a 32 bit perl, the Makefile references > oracle_home/lib instead of lib32. So when u installed and executed at > runtime would get > error about ELFCLASS mismatch, unless you had LD_LIBRARY_PATH > explicitly > set to have lib32. This doesn't work since some of our binaries use > 64 > bit > so can't use LD_LIBRARY_PATH like that. > > Finally manually edited the generated Makefile > LD_RUN_PATH = /apps/oracle/product/10.2.0/db_3/lib32 > :/apps/oracle/product/10.2.0/db_3/rdbms/lib32 > OTHERLDFLAGS = -xarch=v9 -L/apps/oracle/product/10.2.0/db_3/lib32/ > -L/apps/oracle/product/10.2.0/db_3/rdbms/lib32/ -lclntsh `cat > /apps/oracle/product/10.2.0/db_3/lib32/sysliblist` > -R/apps/oracle/product/10.2.0/db_3/lib32 -laio -lposix4 -lkstat -lm > -lthread -lpthread >
> ezpclu2>uname -a
> SunOS ezpclu2 5.10 Generic_118833-24 sun4u sparc SUNW,Ultra-Enterprise
> ezpclu2>perl -v
> > This is perl, v5.8.8 built for sun4-solaris > > perl Makefile.PL.DH 2>&1 | tee x.txt > Multiple copies of Driver.xst found in: > /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/ > /usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/auto/DBI/ at > Makefile.PL.DH line 35 > Using DBI 1.56 (for perl 5.008008 on sun4-solaris) installed in > /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/ > > Configuring DBD::Oracle for perl 5.008008 on solaris (sun4-solaris) > > Remember to actually *READ* the README file! Especially if you have > any > problems. > > Using Oracle in /apps/oracle/product/10.2.0/db_3 > DEFINE _SQLPLUS_RELEASE = "1002000300" (CHAR) > Oracle version 10.2.0.3 (10.2) > Found /apps/oracle/product/10.2.0/db_3/rdbms/demo/demo_rdbms.mk > Using /apps/oracle/product/10.2.0/db_3/rdbms/demo/demo_rdbms.mk > IN ORA_LIBDIR > IN ORA_LIBDIR: CLIENT_VERSION: 10.2 > > PERL is 32 bit > Your LD_LIBRARY_PATH env var is set to >
'/usr/lib:/apps/oracle/product/10.2.0/db_3/lib32:/usr/java/lib:/usr/java/jre/lib/sparc:/usr/local/lib:/opt/SUNWspro/lib' Show quoted text
> IN ORA_LIBDIR > IN ORA_LIBDIR: CLIENT_VERSION: 10.2 > > PERL is 32 bit > Reading /apps/oracle/product/10.2.0/db_3/rdbms/demo/demo_rdbms.mk > Reading /apps/oracle/product/10.2.0/db_3/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/10.2.0/db_3/rdbms/demo/demo_rdbms.mk build > ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' 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/10.2.0/db_3/bin/genclntsh > ...] > [genclntsh] > [Built /apps/oracle/product/10.2.0/db_3/lib/libclntsh.so ... > DONE] > Oracle oci build command: > [true -xarch=v9 -L/apps/oracle/product/10.2.0/db_3/lib/ > -L/apps/oracle/product/10.2.0/db_3/rdbms/lib/ -o DBD_ORA_EXE > DBD_ORA_OBJ.o > -lclntsh `cat /apps/oracle/product/10.2.0/db_3/lib/sysliblist` > -R/apps/oracle/product/10.2.0/db_3/lib -laio -lposix4 -lkstat -lm > -lthread -lpthread] > > Found header files in /apps/oracle/product/10.2.0/db_3/rdbms/public. > > Checking for functioning wait.ph > > > System: perl5.008008 sunos 5.10 generic_118822-30 sun4u sparc > sunw,ultra-5_10 solaris > Compiler: gcc -O -fno-strict-aliasing -pipe > -Wdeclaration-after-statement -I/usr/local/include -I/opt/gnu/include > -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 > Linker: /usr/ccs/bin/ld > Sysliblist: -lkstat -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,-Qgsched-T5 -xalias_level=weak > -D_REENTRANT > -DSS_64BIT_SERVER -DBIT64 -DMACHINE64 -K PIC > -I/apps/oracle/product/10.2.0/db_3/rdbms/demo > -I/apps/oracle/product/10.2.0/db_3/rdbms/public > -I/apps/oracle/product/10.2.0/db_3/plsql/public > -I/apps/oracle/product/10.2.0/db_3/network/public -DSLMXMX_ENABLE > -DSLTS_ENABLE -D_SVID_GETTOD -D_REENTRANT $(LPFLAGS) $(USRFLAGS)] > LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) > [-o $@ -L/apps/oracle/product/10.2.0/db_3/rdbms/lib/ > -L$(LIBHOME)] > Linking with OTHERLDFLAGS = -xarch=v9 > -L/apps/oracle/product/10.2.0/db_3/lib/ > -L/apps/oracle/product/10.2.0/db_3/rdbms/lib/ -lclntsh `cat > /apps/oracle/product/10.2.0/db_3/lib/sysliblist` > -R/apps/oracle/product/10.2.0/db_3/lib -laio -lposix4 -lkstat -lm > -lthread -lpthread [from 'build' rule] > > > WARNING: If you have problems you may need to rebuild perl with > threading > enabled. > Checking if your kit is complete... > Looks good > IN ORA_LIBDIR > IN ORA_LIBDIR: CLIENT_VERSION: 10.2 > > PERL is 32 bit >
LD_RUN_PATH=/apps/oracle/product/10.2.0/db_3/lib32:/apps/oracle/product/10.2.0/db_3/rdbms/lib32 Show quoted text
> Using DBD::Oracle 1.19. > Using DBD::Oracle 1.19. > Multiple copies of Driver.xst found in: > /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/ > /usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/auto/DBI/ at > Makefile.PL.DH line 1646 > Using DBI 1.56 (for perl 5.008008 on sun4-solaris) installed in > /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/ > 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?) > > Thanks, > David Himber > E-ZPay Systems > JPMorgan Chase > 718-242-1024 > 3 CMC 3 Fl > Brooklyn, NY 11245 > > > ----------------------------------------- > This communication is for informational purposes only. It is not > intended as an offer or solicitation for the purchase or sale of > any financial instrument or as an official confirmation of any > transaction. All market prices, data and other information are not > warranted as to completeness or accuracy and are subject to change > without notice. Any comments or statements made herein do not > necessarily reflect those of JPMorgan Chase & Co., its subsidiaries > and affiliates. > > This transmission may contain information that is privileged, > confidential, legally privileged, and/or exempt from disclosure > under applicable law. If you are not the intended recipient, you > are hereby notified that any disclosure, copying, distribution, or > use of the information contained herein (including any reliance > thereon) is STRICTLY PROHIBITED. Although this transmission and any > attachments are believed to be free of any virus or other defect > that might affect any computer system into which it is received and > opened, it is the responsibility of the recipient to ensure that it > is virus free and no responsibility is accepted by JPMorgan Chase & > Co., its subsidiaries and affiliates, as applicable, for any loss > or damage arising in any way from its use. If you received this > transmission in error, please immediately contact the sender and > destroy the material in its entirety, whether in electronic or hard > copy format. Thank you. > > Please refer to http://www.jpmorgan.com/pages/disclosures for > disclosures relating to UK legal entities.
  Thu Jan 31 11:37:07 2008 The RT System itself - Status changed from 'new' to 'open'
  Fri Oct 05 13:50:40 2012 champoux [...] pythian.com - Correspondence added
Closing as it's been open 5 years and it's not clear if it's still an issue, as the original problem seems to be mainly caused by a mix of 32 and 64-bit libraries on the user side. If the problem is still pertinent, please feel free to re-open the ticket.
  Fri Oct 05 13:50:42 2012 champoux [...] pythian.com - Status changed from 'open' to 'rejected'