That will be a bit of a problem and a bugger to fix.
I can only offer a general solution as each case is different but the short
answer is yes you can run 32bit perl and 64 bit oracle together.
1) you have to get the 32bit oracle instant client for the version of oracle
you want to use
2) that 32 bit client has to work on the 32 bit platform (test this with the
sqlplus that come with it)
3) you will have to recompile reinstall your DBD for the 32 bit instanctclient
with 'make'
4) when you run your perl make sure it uses the ORACLE_HOME of the 32 bit
instant client
cheers
John
From: anoop.ku...@nawras.om
To: dbi-users@perl.org
CC: go...@bildbasen.kiruna.se; jlip...@coefmd3.uswc.uswest.com;
z50...@mip.lasc.lockheed.com; verb...@be.oracle.com; mou...@hometown.com;
stephen.zan...@mckesson.com; earle.niet...@es.unisys.com;
desca...@hermetica.com; carl...@tis.llnl.gov; d...@fndapl.fnal.gov;
asloo...@alfabank.ru; t...@cpan.org; byter...@cpan.org; yan...@cpan.org;
mjev...@cpan.org
Subject: RE: DBD installtion 11G R2 (64Bit) & 32 bit perl version
Date: Thu, 23 May 2013 14:03:09 +0000
Hi Support,
Please help me to solve this..
LD_RUN_PATH="/u01/app/oracle/product/11.2.0/dbhome_1/lib:/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib"
ld -bhalt:4 -G -bI:/usr/opt/perl5/lib/5.10.1/aix-thread-multi/CORE/perl.exp
-bE:Oracle.exp -bnoentry -lpthreads -lc -lm -L/usr/local/lib Oracle.o dbdimp.o
oci8.o /lib/crt0_64.o -o blib/arch/auto/DBD/Oracle/Oracle.so
-L/u01/app/oracle/product/11.2.0/dbhome_1/lib/ -lclntsh -lld -lm -ldl -lc -lm
-lpthreads -lodm -lbsd_r -lld -lperfstat -lm -lpthreads
ld: 0711-736 ERROR: Input file /lib/crt0_64.o:
XCOFF64 object files are not allowed in 32-bit mode.
make: 1254-004 The error code from the last command is 8.
Stop.
After researching I could find this ,, But issue is that with 11gR2 onwards
lib32 is not installing by default so need to install and configure seperatly
its very difficuilt task for DBA..
Is DBD 64bit is available??
The problem looks like Perl and DBI run in 32-bit mode, but Oracle 9i
installs
as
64-bit. (Oracle 8 installed as 32-bit.) I saved the following email
with the
solution
in my bag of tricks. This message was for Solaris, which is what I am
using.
A
week or so ago, it also worked for hpux. Hopefully it will work for you
on
AIX.
=================================
Our solution: <bit-time-kludge>
afer Makefile.PL creates the makefile, edit it in vi.
Replace '911/lib' with '911/lib32' everywhere
Replace 'rdbms/lib' with 'rdbms/lib32' everywhere.
Then do your make.
To really fix this will take someone who knows Makefile.PL to apply a
patch
detect the 64bit version of Oracle9i(the presense of lib32's is a tip
off).
In the mean time we applied a quick script to do it in our
install/distribution scripts.
From: Anoop Kumar Paramesweran
Sent: Thursday, May 23, 2013 4:25 PM
To: 'dbi-users@perl.org'
Subject: DBD error
Hi Support,
I am receiving following error while installing DBD Perl module on IBM AIX 7.1
.Please help me to solve this..
bash-3.2# perl Makefile.PL
Using DBI 1.625 (for perl 5.010001 on aix-thread-multi) installed in
/usr/opt/perl5/lib/site_perl/5.10.1/aix-thread-multi/auto/DBI/
Configuring DBD::Oracle for perl 5.010001 on aix (aix-thread-multi)
Remember to actually *READ* the README file! Especially if you have any
problems.
Installing on a aix, Ver#5.3
Using Oracle in /u01/app/oracle/product/11.2.0/dbhome_1
DEFINE _SQLPLUS_RELEASE = "1102000300" (CHAR)
Oracle version 11.2.0.3 (11.2)
Found /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk
Using /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk
Your LIBPATH env var is set to '/u01/app/oracle/product/11.2.0/dbhome_1/lib'
Reading /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk
Reading /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/env_rdbms.mk
Deleting -b64 from COMPOBJS because -b64 doesn't exist.
WARNING: Oracle /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk
doesn't define a 'build' rule.
WARNING: I will now try to guess how to build and link DBD::Oracle for you.
This kind of guess work is very error prone and Oracle-version
sensitive.
It is possible that it won't be supported in future versions of
DBD::Oracle.
*PLEASE* notify dbi-users about exactly _why_ you had to build it this
way.
Found header files in /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/public.
client_version=11.2
DEFINE= -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.3\" -DORA_OCI_102
-DORA_OCI_112
Checking for functioning wait.ph
System: perl5.010001 aix dennis01 3 5 00c72e9a4c00
Compiler: xlc_r -q32 -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT
-qlanglvl=extended -I/usr/local/include -q32 -D_LARGE_FILES -qlonglong
Linker: /usr/bin/ld
Sysliblist: /lib/crt0_64.o -ldl -lc -lm -lpthreads -lodm -lbsd_r -lld -lperfstat
Oracle makefiles would have used these definitions but we override them:
CC: $(ORACLE_HOME)/bin/oraxlc $(ORAXLCFLAGS)
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -O3 $(CDEBUG) -q64 -DSS_64BIT_SERVER -qwarn64 -qinfo=uni
-DAIXRIOS -qflag=s:s -I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/demo
-I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/public
-I/u01/app/oracle/product/11.2.0/dbhome_1/plsql/public
-I/u01/app/oracle/product/11.2.0/dbhome_1/network/public -DLDAP_CM $(LPFLAGS)
$(PLSQLNCGFLAGS) $(USRFLAGS)]
LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
[-o $@ -L/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/
-L$(LIBHOME)]
Linking with /lib/crt0_64.o -lclntsh -brtl -lld -lm -ldl -lc -lm -lpthreads
-lodm -lbsd_r -lld -lperfstat -lm -lpthreads [from $(OCISHAREDLIBS)]
WARNING: You will may need to rebuild perl using the xlc_r compiler.
The important thing is that perl and DBD::Oracle be built with the
same compiler.
You may also need to: ORACCENV='cc=xlc_r'; export ORACCENV
Also see README.aix for gcc instructions and read about the -p option.
Unrecognized argument in LIBS ignored: '-brtl'
LD_RUN_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib:/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib
Using DBD::Oracle 1.62.
Using DBD::Oracle 1.62.
Using DBI 1.625 (for perl 5.010001 on aix-thread-multi) installed in
/usr/opt/perl5/lib/site_perl/5.10.1/aix-thread-multi/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?)
bash-3.2# make
cp lib/DBD/Oracle/Troubleshooting/Cygwin.pod
blib/lib/DBD/Oracle/Troubleshooting/Cygwin.pod
cp lib/DBD/Oracle.pm blib/lib/DBD/Oracle.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/Troubleshooting/Vms.pod
blib/lib/DBD/Oracle/Troubleshooting/Vms.pod
cp lib/DBD/Oracle/Troubleshooting/Hpux.pod
blib/lib/DBD/Oracle/Troubleshooting/Hpux.pod
cp lib/DBD/Oracle/Troubleshooting/Linux.pod
blib/lib/DBD/Oracle/Troubleshooting/Linux.pod
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
cp lib/DBD/Oracle/Troubleshooting.pod blib/lib/DBD/Oracle/Troubleshooting.pod
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp lib/DBD/Oracle/Troubleshooting/Sun.pod
blib/lib/DBD/Oracle/Troubleshooting/Sun.pod
cp lib/DBD/Oracle/Troubleshooting/Macos.pod
blib/lib/DBD/Oracle/Troubleshooting/Macos.pod
cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object.pm
cp lib/DBD/Oracle/Troubleshooting/Aix.pod
blib/lib/DBD/Oracle/Troubleshooting/Aix.pod
cp lib/DBD/Oracle/Troubleshooting/Win64.pod
blib/lib/DBD/Oracle/Troubleshooting/Win64.pod
cp lib/DBD/Oracle/Troubleshooting/Win32.pod
blib/lib/DBD/Oracle/Troubleshooting/Win32.pod
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
/usr/bin/perl -e 'use ExtUtils::Mksymlists; Mksymlists("NAME" =>
"DBD::Oracle", "DL_FUNCS" => { }, "FUNCLIST" => [], "DL_VARS" => []);'
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g"
/usr/opt/perl5/lib/site_perl/5.10.1/aix-thread-multi/auto/DBI/Driver.xst >
Oracle.xsi
/usr/bin/perl /usr/opt/perl5/lib/5.10.1/ExtUtils/xsubpp -typemap
/usr/opt/perl5/lib/5.10.1/ExtUtils/typemap -typemap typemap Oracle.xs >
Oracle.xsc && mv Oracle.xsc Oracle.c
xlc_r -q32 -c -I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/public
-I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/demo
-I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/public
-I/u01/app/oracle/product/11.2.0/dbhome_1/plsql/public
-I/u01/app/oracle/product/11.2.0/dbhome_1/network/public
-I/usr/opt/perl5/lib/site_perl/5.10.1/aix-thread-multi/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -qlanglvl=extended -I/usr/local/include
-q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.62\" -DXS_VERSION=\"1.62\"
"-I/usr/opt/perl5/lib/5.10.1/aix-thread-multi/CORE" -DUTF8_SUPPORT
-DORA_OCI_VERSION=\"11.2.0.3\" -DORA_OCI_102 -DORA_OCI_112 Oracle.c
xlc_r -q32 -c -I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/public
-I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/demo
-I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/public
-I/u01/app/oracle/product/11.2.0/dbhome_1/plsql/public
-I/u01/app/oracle/product/11.2.0/dbhome_1/network/public
-I/usr/opt/perl5/lib/site_perl/5.10.1/aix-thread-multi/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -qlanglvl=extended -I/usr/local/include
-q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.62\" -DXS_VERSION=\"1.62\"
"-I/usr/opt/perl5/lib/5.10.1/aix-thread-multi/CORE" -DUTF8_SUPPORT
-DORA_OCI_VERSION=\"11.2.0.3\" -DORA_OCI_102 -DORA_OCI_112 dbdimp.c
xlc_r -q32 -c -I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/public
-I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/demo
-I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/public
-I/u01/app/oracle/product/11.2.0/dbhome_1/plsql/public
-I/u01/app/oracle/product/11.2.0/dbhome_1/network/public
-I/usr/opt/perl5/lib/site_perl/5.10.1/aix-thread-multi/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -qlanglvl=extended -I/usr/local/include
-q32 -D_LARGE_FILES -qlonglong -O -DVERSION=\"1.62\" -DXS_VERSION=\"1.62\"
"-I/usr/opt/perl5/lib/5.10.1/aix-thread-multi/CORE" -DUTF8_SUPPORT
-DORA_OCI_VERSION=\"11.2.0.3\" -DORA_OCI_102 -DORA_OCI_112 oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/u01/app/oracle/product/11.2.0/dbhome_1/lib:/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib"
ld -bhalt:4 -G -bI:/usr/opt/perl5/lib/5.10.1/aix-thread-multi/CORE/perl.exp
-bE:Oracle.exp -bnoentry -lpthreads -lc -lm -L/usr/local/lib Oracle.o dbdimp.o
oci8.o /lib/crt0_64.o -o blib/arch/auto/DBD/Oracle/Oracle.so
-L/u01/app/oracle/product/11.2.0/dbhome_1/lib/ -lclntsh -lld -lm -ldl -lc -lm
-lpthreads -lodm -lbsd_r -lld -lperfstat -lm -lpthreads
ld: 0711-736 ERROR: Input file /lib/crt0_64.o:
XCOFF64 object files are not allowed in 32-bit mode.
make: 1254-004 The error code from the last command is 8.
Stop.
bash-3.2# echo $ LD_RUN_PATH
$ LD_RUN_PATH
bash-3.2# echo $LD_RUN_PATH
bash-3.2#
This e-mail including any attachment is intended only for the recipient(s)
named. It may contain confidential information and should not be read, copied
or otherwise used by any other person. If you are not a named recipient, please
contact the sender and delete
the e-mail from your system. The sender does not accept any liability for
errors or omissions in the content of this message or for viruses, or any
damage due to the e-mail. The recipient is advised to have appropriate virus
check software
