Re: DBD-Oracle-1.14 and Oracle 9i
From: Dominik Stadler (dstadler_at_ftisoft.at)
Date: 01/27/04
- Next message: Tim Bunce: "Re: $sth->{NAME} doesn't work"
- Previous message: Dominik Stadler: "Re: DBD-Oracle-1.14 and Oracle 9i"
- In reply to: Tim Bunce: "Re: DBD-Oracle-1.14 and Oracle 9i"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: dbi-users@perl.org Date: Tue, 27 Jan 2004 13:55:27 +0100
Hi,
This built fine on Windows and Solaris with Oracle 9/32bit, I will now try
to install and run with it.
Should I be able to compile for Oracle 9/64bit on Solaris? "perl
Makefile.PL -r=build64" did not compile.
Dominik.
On Mon, 26 Jan 2004 09:35:08 +0000, Tim Bunce wrote:
> I'd be grateful if you both, and everyone having problems building
> DBD::Oracle with recent Oracle releases, could try this:
>
> http://homepage.eircom.net/~timbunce/DBD-Oracle-1.15-rc3-20040123.tar.gz
>
> and let me know how you get on. If you do have any problems *please*
> include the lg of the build (ideally created using the script command).
>
> Thank you.
>
> Tim.
>
> On Mon, Jan 26, 2004 at 08:56:13AM +0100, Joel Van Boeckel wrote:
>> Hi Mark,
>> In a preceding message, I explained how I succeeded to build DBD::Oracle with Oracle 9i on a HP-UX system.
>> It seems that you encounter the same messages I encountered.
>> Here a copy of my solution. It's perhaps not the best one, but it works.
>> Joël.
>> ----------------------------------------------------------------
>> ...
>> I had a lot of problems in order to build Oracle:DBD on HP-UX.
>> I finally ended to a very simple solution.
>> - recompile perl conforming to HP requirements (reccomendations from Garry Ferguson
>> available at http://www.mail-archive.com/dbi-users@perl.org/msg18687.html )
>> - patch DBD::Oracle Makefile.PL
>>
>> Perhaps may this information help you in fixing the solution.
>>
>> The final environment is :
>> Perl : 5.008002 (PA-RISC2.0) (32 bits)
>> OS : hpux (11.00)
>> Compiler : cc
>> Oracle client : SQL*Plus: Release 9.2.0.1.0 - Production
>> DBI : 1.38
>> DBD::Oracle : 1.15
>>
>> --------------------------------------------------------
>> Environment (important to specify the lib32 libraries)
>> --------------------------------------------------------
>> export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:/$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
>> export SHLIB_PATH=$ORACLE_HOME/lib32
>> export ORACLE_USERID="name/pwd@C_string"
>> echo ORACLE_SID=sid_name
>>
>> --------------------------------------------------------
>> Building perl with nothread
>> --------------------------------------------------------
>>
>> rm -f config.sh Policy.sh
>> ./Configure -Ubincompat5005 -Duselargefiles
>> When asked:
>> 1/ Build it "Not threaded" --> Build a threading Perl? [n]
>> 2/ "What libraries to use?" then prepend with -lcl -lpthread
>> --> What libraries to use?
>> [-lnsl -lnm -lndbm -lmalloc -ldld -lm -lcrypt -lsec -lc]
>> -lcl -lpthread -lnsl -lnm -lndbm -lmalloc -ldld -lm -lcrypt -lsec -lc
>> 3/ "Any additional cc flags?" then prepend with +z +DAportable +DSPA7300
>> --> Any additional cc flags?
>> [-Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -I/usr/local/include]
>> +z +DAportable +DSPA7300 -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings
>> -I/usr/local/include
>> 4/ Then answer & -d to a prompt to take defaults from then on.
>>
>> make
>> make test
>> make install
>>
>> --------------------------------------------------------
>> DBI DBI-1.38
>> --------------------------------------------------------
>> perl Makefile.PL
>> make
>> make test
>> make install
>>
>> --------------------------------------------------------
>> DBD::Oracle --> DBD-Oracle-1.15
>> --------------------------------------------------------
>> Patch Makefile.pl
>>
>> diff Makefile.PL.org Makefile.PL
>> 295c295
>> < $opts{LIBS} = [ "-L$OH/$libdir -l$lib $syslibs" ];
>> ---
>> > $opts{LIBS} = [ "-L$OH/$libdir -lnjni9 -ljip9 -l$lib $syslibs" ];
>>
>>
>> perl Makefile.PL -l
>> make
>> make test
>> make install
>>
>> -------------------------------------------------------
>> More information : perl -V
>> --------------------------------------------------------
>> Summary of my perl5 (revision 5.0 version 8 subversion 2) configuration:
>> Platform:
>> osname=hpux, osvers=11.00, archname=PA-RISC2.0
>> uname='hp-ux panic b.11.00 u 9000800 145069681 unlimited-user license '
>> config_args='-Ubincompat5005 -Duselargefiles'
>> hint=recommended, useposix=true, d_sigaction=define
>> usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
>> useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
>> use64bitint=undef use64bitall=undef uselongdouble=undef
>> usemymalloc=n, bincompat5005=undef
>> Compiler:
>> cc='cc', ccflags =' +z +DAportable +DSPA7300 -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -I/usr/l
>> ocal/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 ',
>> optimize='+O2 +Onolimit',
>> cppflags='-Aa -D__STDC_EXT__ -D_HPUX_SOURCE +z +DAportable +DSPA7300 -Ae -D_HPUX_SOURCE -Wl,+vn
>> ocompatwarnings -I/usr/local/include'
>> ccversion='B.11.11.02', gccversion='', gccosandvers=''
>> intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
>> d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
>> ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
>> alignbytes=8, prototype=define
>> Linker and Libraries:
>> ld='/usr/bin/ld', ldflags =' -L/usr/local/lib'
>> libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
>> libs=-lcl -lpthread -lnsl -lnm -lndbm -lmalloc -ldld -lm -lcrypt -lsec -lc
>> perllibs=-lcl -lpthread -lnsl -lnm -lmalloc -ldld -lm -lcrypt -lsec -lc
>> libc=/lib/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
>> gnulibc_version=''
>> Dynamic Linking:
>> dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,-B,deferred '
>> cccdlflags='+Z', lddlflags='-b +vnocompatwarnings -L/usr/local/lib'
>>
>>
>> Characteristics of this binary (from libperl):
>> Compile-time options: USE_LARGE_FILES
>> Built under hpux
>> Compiled at Jan 19 2004 13:17:12
>> @INC:
>> /opt/perl5/lib/5.8.2/PA-RISC2.0
>> /opt/perl5/lib/5.8.2
>> /opt/perl5/lib/site_perl/5.8.2/PA-RISC2.0
>> /opt/perl5/lib/site_perl/5.8.2
>> /opt/perl5/lib/site_perl
>>
>> --------------------------------------------------------
>> Joël,
>>
>> -----------------
>> Joël Van Boeckel,
>> DMP,
>> Joel.VanBoeckel@d-m-p.be
>> --------------------------------------------------------
>>
>>
>> -----Message d'origine-----
>> De : Krempasky, Mark [mailto:mkrempasky@doubleclick.net]
>> Envoyé : vendredi 23 janvier 2004 17:13
>> À : Potenza, Joe; 'Tim Bunce'
>> Cc : 'dbi-users@perl.org'
>> Objet : RE: DBD-Oracle-1.14 and Oracle 9i
>>
>>
>> I've not been able to successfully compile DBD-Oracle-1.14 with our current
>> setup on hugo.
>> Solaris 8, perl 5.005_03, DBI-1.35 and various types of "cc, ld and make"
>> Regardless of which brand of "cc, ld and make" I use I pretty much see the
>> same results
>> compiling DBD-Oracle-1.14 against 64bit and 32bit Oracle9 libraries with our
>> version of perl. The below error is a common issue of old perl vrs 64bit
>> Oracle9 libs during the make.
>> note that the LD_LIBRARY_PATH is not referenced during the compile, it's the
>> LD_RUN_PATH generated by the "perl Makefile.PL"
>>
>> LD_RUN_PATH="/app/oracle9/lib:/app/oracle9/rdbms/lib" cc -o
>> blib/arch/auto/DBD/Oracle/Oracle.so -G Oracle.o dbdimp.o oci7.o oci8.o
>> -L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build
>> -L/app/oracle9/rdbms/lib/ -L/app/oracle9/lib/ -lclntsh -lnbeq9 -lnhost9
>> -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9
>> -lnsslb9 -lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl -R/app/oracle9/lib -laio
>> -lposix4 -lkstat -lm -lthread
>> ld: fatal: file /app/oracle9/lib//libclntsh.so: wrong ELF class: ELFCLASS64
>> ld: fatal: File processing errors. No output written to build
>> *** Error code 1
>> make: Fatal error: Command failed for target
>> `blib/arch/auto/DBD/Oracle/Oracle.so'
>>
>> So the work around to the 64bit lib error is to modify the Makefile and
>> change every instance of "/app/oracle9/lib to /app/oracle9/lib32" so make
>> compiles against the 32bit oracle9 libs.
>>
>> After making the changes and running make the
>> `blib/arch/auto/DBD/Oracle/Oracle.so' is still not created in the DBD source
>> dir and the make bombs out.
>>
>> LD_RUN_PATH="/app/oracle9/lib32:/app/oracle9/rdbms/lib" cc -o
>> blib/arch/auto/DBD/Oracle/Oracle.so -G Oracle.o dbdimp.o oci7.o oci8.o
>> -L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build
>> -L/app/oracle9/rdbms/lib/ -L/app/oracle9/lib32/ -lclntsh -lnbeq9 -lnhost9
>> -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9
>> -lnsslb9 -lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl -R/app/oracle9/lib32
>> -laio -lposix4 -lkstat -lm -lthread
>> chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
>> chmod: WARNING: can't access blib/arch/auto/DBD/Oracle/Oracle.so
>> *** Error code 1
>> make: Fatal error: Command failed for target
>> `blib/arch/auto/DBD/Oracle/Oracle.so'
>>
>> I'm pretty well stumped, the only thing I can think of to try next is find
>> another development system with Oracle9, perl 5.6.0 or newer, "gnu gcc, make
>> and ld" and start from scratch.
>> But I'm definitely up for any input on trying to get this to work in our
>> current environment.
>>
>> Mark.
>>
>> -----Original Message-----
>> From: Potenza, Joe
>> Sent: Friday, January 23, 2004 8:19 AM
>> To: 'Tim Bunce'; Potenza, Joe; Krempasky, Mark
>> Cc: 'dbi-users@perl.org'
>> Subject: RE: DBD-Oracle-1.14 and Oracle 9i
>>
>>
>> I apologize for the lack of detail at this time. One of my co-workers was
>> attempting the compile and did some searching on google. I mainly wanted to
>> find out if DBD-Oracle-1.14 would work with Oracle9i before pursuing the
>> issue any further.
>>
>> Mark K.,
>>
>> Can you reply to this email with detail on the compilation errors you were
>> getting. Thanks.
>>
>> Joe Potenza
>>
>> -----Original Message-----
>> From: Tim Bunce [mailto:Tim.Bunce@pobox.com]
>> Sent: Friday, January 23, 2004 2:48 AM
>> To: Potenza, Joe
>> Cc: 'dbi-users@perl.org'
>> Subject: Re: DBD-Oracle-1.14 and Oracle 9i
>>
>> On Thu, Jan 22, 2004 at 05:21:02PM -0700, Potenza, Joe wrote:
>> > Has anyone been able to compile DBD-Oracle-1.14 with Oracle9i under
>> > Solaris8?
>>
>> Have you been able to use google to find out?
>>
>> Tim.
>>
>>
- Next message: Tim Bunce: "Re: $sth->{NAME} doesn't work"
- Previous message: Dominik Stadler: "Re: DBD-Oracle-1.14 and Oracle 9i"
- In reply to: Tim Bunce: "Re: DBD-Oracle-1.14 and Oracle 9i"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
