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.
