Re: DBD installtion 11G R2 (64Bit) & 32 bit perl version
Jonathan Leffler <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <CAH+RLGGM1PJjFEaP7M9TxYN3h3zZ9vD2i5kaws621diN9sMT2w@mail.gmail.com> |
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 < [email protected]> 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:* '[email protected]' > *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 <[email protected]> #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."