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.
>
