You will need a 64-bit Perl (and 64-bit DBI) to work with 64-bit Oracle and
hence 64-bit DBD::Oracle.
Or you can go 32-bit for everything if there's a 32-bit Oracle client you
can install.
What you can't do is have some 32-bit code and some 64-bit code built into
(or loaded into, since most of this is dynamically loaded) the same
executable. All 32-bit or all 64-bit; not a mixture.
(Addressee list trimmed.)
On Thu, May 23, 2013 at 7:03 AM, Anoop Kumar Paramesweran <
anoop.ku...@nawras.om> wrote:
> 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
>
--
Jonathan Leffler <jonathan.leff...@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
