Mike:
The following sequence worked for me on IAX 5.1:
-use Perl 5.8.0 (the latest stable from CPAN)
-use the xlc_r version of IBM's compiler and build a 32 bit Perl (which
xlc_r will do by default). All tests should be successfull.
-get and install DBI
-get DBD::Oracle. Edit the Makefile.PL or Makefile for DBD::Oracle,
changing references to Oracle's ../lib to ../lib32. and change crt0_64.o
to crt0_r.o. Remove the -q32 and/or -q64 options from the list of
libraries to link with. Do the make and make test.
-Set up the environment for making DBD::Oracle:
ORACLE_HOME="your oracle home"
ORACCENV = "xlc_r"
ORACLE_USERID..
ORACLE_SID ..
-Run make, all tests should be successfull -against Oracle 9.x at least.
You should have no problems with Oracle 8.1.7, but accessing Oracle 7.x
or previous is not possible (you'll core dump, or simply hang). The same
goes for a Linux build or a Digital build, regarding access of different
Oracle versions.
Rafael Caceres
On Tue, 2003-07-22 at 08:12, [EMAIL PROTECTED] wrote:
>
> I dont believe I compiled Oracle. During the installation it was linked
> but I am not sure it was compiled
>
> I used a xlc compiler to compile PERL.
> Got this message in the Perl Makefile.PL output
>
> Warning: You will may need to rebuild perl using the xlc_r compiler.
> You may also need do: ORACCENV='cc=xlc_r'; export ORACCENV
> Also see the README about the -p option
>
> this probobly means I need to rebuild PERL with xlc_r??
>
> thanx
>
> Mike Paladino
> Database Administrator
> ext. (440)326-3995
>
>
>
>
> Rafael Caceres
>
> <[EMAIL PROTECTED] To: [EMAIL PROTECTED]
>
> sa.com.pe> cc: [EMAIL PROTECTED]
>
> Subject: Re: DBD::Oracle cant make
> with 9.2
> 07/21/2003
>
> 05:16 PM
>
>
>
>
>
>
>
>
>
> Mike:
>
> Make sure you use the same compiler to build Oracle and Perl. We have
> used xlc_r on Aix 5.1 with no problems. Your Perl build is 32 bit, so
> when building DBD::Oracle, you should use the 32bit libraries (change
> references to .../oracle/lib to .../oracle/lib32 in your Makefile).
> Remove the references to the -q64 or -q32 parameters for ld in Makefile,
> as they shouldn't be there.
>
> Rafael Caceres
>
> On Mon, 2003-07-21 at 15:00, [EMAIL PROTECTED] wrote:
> > Hi all
> > I am having real difficulties trying to get DBD to work with Oracle
> 9.2.0.3
> > Every time I try to make I get an error. I understand Oracle has moved
> to
> > default 64 bit libs and PERL needs 32 bit libs. I tried to edit the
> > Makefile to use the lib32 directory in the Oracle installation and still
> > get errors
> >
> > Environment
> > I just installed Perl 5.8
> > DBI 1.37
> > DBD:: Oracle 1.14
> > OS = AIX 4.3.3
> >
> > usaxs02:iwdba:/opt/iw/build/perl/modules/DBD-Oracle-1.14>perl -V
> > Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
> > Platform:
> > osname=aix, osvers=4.3.3.0, archname=aix
> > uname='aix usaxs02 3 4 000a946a4c00 '
> > config_args=''
> > 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='xlc', ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
> > -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -q32 -D_LARG
> > E_FILES -qlonglong',
> > optimize='-O',
> > cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
> -qmaxmem=16384
> > -qnoansialias -DUSE_NATIVE_DLOPEN'
> > ccversion='4.3.0.0', gccversion='', gccosandvers=''
> > intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
> > d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8
> > ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
> > lseeksize=8
> > alignbytes=8, prototype=define
> > Linker and Libraries:
> > ld='ld', ldflags =' -brtl -L/usr/local/lib -b32'
> > libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
> > libs=-lbind -lnsl -ldbm -ldl -lld -lm -lc -lcrypt -lbsd -lPW
> > perllibs=-lbind -lnsl -ldl -lld -lm -lc -lcrypt -lbsd -lPW
> > libc=/lib/libc.a, so=a, useshrplib=false, libperl=libperl.a
> > gnulibc_version=''
> > Dynamic Linking:
> > dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef, ccdlflags='
> > -bE:/usr/local/lib/perl5/5.8.0/aix/CORE/perl.exp'
> > cccdlflags=' ', lddlflags=' -bhalt:4 -bM:SRE -bI:$(PERL_INC)/perl.exp
> > -bE:$(BASEEXT).exp -bnoentry -lc -L/usr/local/lib'
> >
> >
> > Characteristics of this binary (from libperl):
> > Compile-time options: USE_LARGE_FILES
> > Built under aix
> > Compiled at Jul 21 2003 13:52:16
> > @INC:
> > /usr/local/lib/perl5/5.8.0/aix
> > /usr/local/lib/perl5/5.8.0
> > /usr/local/lib/perl5/site_perl/5.8.0/aix
> > /usr/local/lib/perl5/site_perl/5.8.0
> > /usr/local/lib/perl5/site_perl
> >
> >
> > usaxs02:iwdba:/opt/iw/build/perl/modules/DBD-Oracle-1.14>make
> > cp Oracle.pm blib/lib/DBD/Oracle.pm
> > cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
> > cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
> > cp oraperl.ph blib/lib/oraperl.ph
> > cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
> > cp Oraperl.pm blib/lib/Oraperl.pm
> > cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
> > cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
> > /usr/bin/perl -e 'use ExtUtils::Mksymlists; Mksymlists("NAME" =>
> > "DBD::Oracle", "DL_FUNCS" => { }, "FUNCLIST" => [], "DL_V
> > ARS" => []);'
> > /usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" <
> > /usr/local/lib/perl5/site_perl/5.8.0/aix/auto/DBI/Driver.xst > Oracle.xsi
> > /usr/bin/perl /usr/local/lib/perl5/5.8.0/ExtUtils/xsubpp
> -typemap
> > /usr/local/lib/perl5/5.8.0/ExtUtils/typemap Oracle.xs >
> > Oracle.xsc && mv Oracle.xsc Oracle.c
> > xlc -c -I/ORACLE/iwdba/9.2.0/rdbms/demo
> > -I/ORACLE/iwdba/9.2.0/rdbms/public -I/ORACLE/iwdba/9.2.0/plsql/public
> > -I/ORACLE/iwd
> > ba/9.2.0/network/public -I/ORACLE/iwdba/9.2.0/rdbms/demo
> > -I/ORACLE/iwdba/9.2.0/rdbms/public -I/ORACLE/iwdba/9.2.0/rdbms/demo
> -I/usr/
> > local/lib/perl5/site_perl/5.8.0/aix/auto/DBI -D_ALL_SOURCE
> > -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATI
> > VE_DLOPEN -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.14\"
> > -DXS_VERSION=\"1.14\" "-I/usr/local/lib/perl5/5.8.0/aix/CORE" -
> > DUTF8_SUPPORT Oracle.c
> > xlc -c -I/ORACLE/iwdba/9.2.0/rdbms/demo
> > -I/ORACLE/iwdba/9.2.0/rdbms/public -I/ORACLE/iwdba/9.2.0/plsql/public
> > -I/ORACLE/iwd
> > ba/9.2.0/network/public -I/ORACLE/iwdba/9.2.0/rdbms/demo
> > -I/ORACLE/iwdba/9.2.0/rdbms/public -I/ORACLE/iwdba/9.2.0/rdbms/demo
> -I/usr/
> > local/lib/perl5/site_perl/5.8.0/aix/auto/DBI -D_ALL_SOURCE
> > -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATI
> > VE_DLOPEN -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.14\"
> > -DXS_VERSION=\"1.14\" "-I/usr/local/lib/perl5/5.8.0/aix/CORE" -
> > DUTF8_SUPPORT dbdimp.c
> > 1500-030: (I) INFORMATION: dbd_rebind_ph_char: Additional
> optimization
> > may be attained by recompiling and specifying MAXMEM opti
> > on with a value greater than 16384.
> > xlc -c -I/ORACLE/iwdba/9.2.0/rdbms/demo
> > -I/ORACLE/iwdba/9.2.0/rdbms/public -I/ORACLE/iwdba/9.2.0/plsql/public
> > -I/ORACLE/iwd
> > ba/9.2.0/network/public -I/ORACLE/iwdba/9.2.0/rdbms/demo
> > -I/ORACLE/iwdba/9.2.0/rdbms/public -I/ORACLE/iwdba/9.2.0/rdbms/demo
> -I/usr/
> > local/lib/perl5/site_perl/5.8.0/aix/auto/DBI -D_ALL_SOURCE
> > -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATI
> > VE_DLOPEN -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.14\"
> > -DXS_VERSION=\"1.14\" "-I/usr/local/lib/perl5/5.8.0/aix/CORE" -
> > DUTF8_SUPPORT oci7.c
> > xlc -c -I/ORACLE/iwdba/9.2.0/rdbms/demo
> > -I/ORACLE/iwdba/9.2.0/rdbms/public -I/ORACLE/iwdba/9.2.0/plsql/public
> > -I/ORACLE/iwd
> > ba/9.2.0/network/public -I/ORACLE/iwdba/9.2.0/rdbms/demo
> > -I/ORACLE/iwdba/9.2.0/rdbms/public -I/ORACLE/iwdba/9.2.0/rdbms/demo
> -I/usr/
> > local/lib/perl5/site_perl/5.8.0/aix/auto/DBI -D_ALL_SOURCE
> > -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATI
> > VE_DLOPEN -q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.14\"
> > -DXS_VERSION=\"1.14\" "-I/usr/local/lib/perl5/5.8.0/aix/CORE" -
> > DUTF8_SUPPORT oci8.c
> > 1500-030: (I) INFORMATION: ora_blob_read_mb_piece: Additional
> > optimization may be attained by recompiling and specifying MAXMEM
> > option with a value greater than 16384.
> > Running Mkbootstrap for DBD::Oracle ()
> > chmod 644 Oracle.bs
> > rm -f blib/arch/auto/DBD/Oracle/Oracle.so
> > LD_RUN_PATH
> ="/ORACLE/iwdba/9.2.0/lib:/ORACLE/iwdba/9.2.0/rdbms/lib"
> > ld -bhalt:4 -bM:SRE -bI:/usr/local/lib/perl5/5.8.0/aix/
> > CORE/perl.exp -bE:Oracle.exp -bnoentry -lc -L/usr/local/lib Oracle.o
> > dbdimp.o oci7.o oci8.o -q64 -L/ORACLE/iwdba/9.2.0/lib/ -L/OR
> > ACLE/iwdba/9.2.0/rdbms/lib/ -lclntsh -lld -lm /lib/crt0_64.o -ldl -lc
> -lm
> > -lpthreads -lodm -lbsd_r -lld -lm -lpthreads -o blib/arc
> > h/auto/DBD/Oracle/Oracle.so
> > ld: 0706-012 The -q flag is not recognized.
> > ld: 0706-012 The -6 flag is not recognized.
> > ld: 0706-012 The -4 flag is not recognized.
> > make: 1254-004 The error code from the last command is 255.
> >
> >
> > Stop.
> >
> > any ideas?
> >
> > Mike Paladino
> > Database Administrator
> > ext. (440)326-3995
> >
> >
> > -----------------------------------------
> > The contents of this message represent the opinions of the employee
> > and not necessarily the opinions of Invacare Corporation.
> >
>
>
>
>
>
>
>
> -----------------------------------------
> The contents of this message represent the opinions of the employee
> and not necessarily the opinions of Invacare Corporation.
>
