Home » Open Source » Programming Interfaces » DBD::Oracle install problem on 64-bit RHEL51
DBD::Oracle install problem on 64-bit RHEL51 [message #431326] Mon, 16 November 2009 17:38 Go to next message
clim
Messages: 1
Registered: November 2009
Junior Member
I'm having problem installing DBD::Oracle for perl in RHEL5.1 64-bit. If some one can shed some light it'd be much appreciated. I tried perl MakeFile.PL, make ends up with errors.

On the same machine I installed:
[root@dev2 Oracle_Binaries]# rpm -qa|grep -i oracle
oracle-instantclient-basic-10.2.0.4-1
oracle-xe-univ-10.2.0.1-1.0
oracle-instantclient-devel-10.2.0.4-1
oracle-instantclient-sqlplus-10.2.0.4-1

Environment vars are:

[root@dev2 Oracle_Binaries]# set|grep -i oracle
LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib:
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
PERL5LIB=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/perl/lib
PWD=/buildc/chlim/MySql2Oracle/Oracle_Binaries


Sqlplus is fine. Can connect to local database. XE instance looks fine.

[root@dev2 Oracle_Binaries]# uname -a
Linux dev2 2.6.18-53.el5 #1 SMP Wed Oct 10 16:34:19 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux


Here's the CPAN install log:

[root@dev2 Oracle_Binaries]# perl -MCPAN -e "install DBD::Oracle"
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Mon, 16 Nov 2009 11:27:04 GMT
Running install for module DBD::Oracle
Running make for P/PY/PYTHIAN/DBD-Oracle-1.23.tar.gz
CPAN: Digest::MD5 loaded ok
CPAN: Compress::Zlib loaded ok
Checksum for /root/.cpan/sources/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.23.tar.gz ok
Scanning cache /root/.cpan/build for sizes
DBD-Oracle-1.23/
DBD-Oracle-1.23/README.java.txt
DBD-Oracle-1.23/t/
DBD-Oracle-1.23/t/55nested.t
DBD-Oracle-1.23/t/23wide_db.t
DBD-Oracle-1.23/t/10general.t
DBD-Oracle-1.23/t/80ora_charset.t
DBD-Oracle-1.23/t/31lob_extended.t
DBD-Oracle-1.23/t/58object.t
DBD-Oracle-1.23/t/26exe_array.t
DBD-Oracle-1.23/t/22nchar_utf8.t
DBD-Oracle-1.23/t/40ph_type.t
DBD-Oracle-1.23/t/21nchar.t
DBD-Oracle-1.23/t/22nchar_al32utf8.t
DBD-Oracle-1.23/t/14threads.t
DBD-Oracle-1.23/t/56embbeded.t
DBD-Oracle-1.23/t/51scroll.t
DBD-Oracle-1.23/t/15nls.t
DBD-Oracle-1.23/t/60reauth.t
DBD-Oracle-1.23/t/25plsql.t
DBD-Oracle-1.23/t/34pres_lobs.t
DBD-Oracle-1.23/t/23wide_db_8bit.t
DBD-Oracle-1.23/t/28array_bind.t
DBD-Oracle-1.23/t/24implicit_utf8.t
DBD-Oracle-1.23/t/nchar_test_lib.pl
DBD-Oracle-1.23/t/50cursor.t
DBD-Oracle-1.23/t/32xmltype.t
DBD-Oracle-1.23/t/23wide_db_al32utf8.t
DBD-Oracle-1.23/t/20select.t
DBD-Oracle-1.23/t/12impdata.t
DBD-Oracle-1.23/t/70meta.t
DBD-Oracle-1.23/t/31lob.t
DBD-Oracle-1.23/t/30long.t
DBD-Oracle-1.23/t/01base.t
DBD-Oracle-1.23/Oracle.ex/
DBD-Oracle-1.23/Oracle.ex/README
DBD-Oracle-1.23/Oracle.ex/sql
DBD-Oracle-1.23/Oracle.ex/bind.pl
DBD-Oracle-1.23/Oracle.ex/commit.pl
DBD-Oracle-1.23/Oracle.ex/tabinfo.pl
DBD-Oracle-1.23/Oracle.ex/ex.pl
DBD-Oracle-1.23/Oracle.ex/curref.pl
DBD-Oracle-1.23/Oracle.ex/japh
DBD-Oracle-1.23/Oracle.ex/proc.pl
DBD-Oracle-1.23/Oracle.ex/mktable.pl
DBD-Oracle-1.23/Oracle.ex/oradump.pl
DBD-Oracle-1.23/Changes
DBD-Oracle-1.23/Oracle.h
DBD-Oracle-1.23/MANIFEST
DBD-Oracle-1.23/typemap
DBD-Oracle-1.23/README-files/
DBD-Oracle-1.23/README-files/hpux/
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-588-11.11-gcc64
DBD-Oracle-1.23/README-files/hpux/Conf-Mike
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-588-10.20-gcc
DBD-Oracle-1.23/README-files/hpux/Conf-Lincoln-1.06
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-588-11.11-gcc32
DBD-Oracle-1.23/README-files/hpux/Makefile-Lincoln
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-585-11.00-cc
DBD-Oracle-1.23/README-files/hpux/Conf-Roger
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-588-11.00-gcc64
DBD-Oracle-1.23/README-files/hpux/Conf-Lincoln-1.07
DBD-Oracle-1.23/README-files/hpux/libjava.eml
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-580-10.20-cc
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-588-11.00-gcc32
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-587-11.23-cc
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-585-11.11-cc
DBD-Oracle-1.23/README-files/hpux/Conf-Merijn-588-11.23-gcc64
DBD-Oracle-1.23/README.hpux.txt
DBD-Oracle-1.23/lib/
DBD-Oracle-1.23/lib/DBD/
DBD-Oracle-1.23/lib/DBD/Oracle/
DBD-Oracle-1.23/lib/DBD/Oracle/GetInfo.pm
DBD-Oracle-1.23/lib/DBD/Oracle/Object.pm
DBD-Oracle-1.23/dbdimp.c
DBD-Oracle-1.23/README.login.txt
DBD-Oracle-1.23/README.linux.txt
DBD-Oracle-1.23/README.vms.txt
DBD-Oracle-1.23/README.win32.txt
DBD-Oracle-1.23/hints/
DBD-Oracle-1.23/hints/macos_syms.pl
DBD-Oracle-1.23/hints/svr4.pl
DBD-Oracle-1.23/hints/macos_bundle.syms
DBD-Oracle-1.23/hints/dgux.pl
DBD-Oracle-1.23/hints/macos_lib.syms
DBD-Oracle-1.23/oraperl.ph
DBD-Oracle-1.23/README.longs.txt
DBD-Oracle-1.23/README.macosx.txt
DBD-Oracle-1.23/README.win64.txt
DBD-Oracle-1.23/test.pl
DBD-Oracle-1.23/oci.def
DBD-Oracle-1.23/Todo
DBD-Oracle-1.23/Oraperl.pm
DBD-Oracle-1.23/README.help.txt
DBD-Oracle-1.23/README.explain.txt
DBD-Oracle-1.23/README
DBD-Oracle-1.23/ora_explain.PL
DBD-Oracle-1.23/README.sec.txt
DBD-Oracle-1.23/oci8.c
DBD-Oracle-1.23/README.wingcc.txt
DBD-Oracle-1.23/dbdimp.h
DBD-Oracle-1.23/ocitrace.h
DBD-Oracle-1.23/Oracle.xs
DBD-Oracle-1.23/README.sun.txt
DBD-Oracle-1.23/Oracle.pm
DBD-Oracle-1.23/dbivport.h
DBD-Oracle-1.23/README.clients.txt
DBD-Oracle-1.23/mkta.pl
DBD-Oracle-1.23/README.aix.txt
DBD-Oracle-1.23/Makefile.PL
DBD-Oracle-1.23/README.64bit.txt
DBD-Oracle-1.23/META.yml
Removing previously used /root/.cpan/build/DBD-Oracle-1.23

CPAN.pm: Going to build P/PY/PYTHIAN/DBD-Oracle-1.23.tar.gz

Using DBI 1.52 (for perl 5.008008 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/

Configuring DBD::Oracle for perl 5.008008 on linux (x86_64-linux-thread-multi)

Remember to actually *READ* the README file! Especially if you have any problems.

Installing on a linux, Ver#2.6
Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Looks like Oracle XE (/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk)
Reading /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Your LD_LIBRARY_PATH env var is set to '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib:'

Checking for functioning wait.ph


System: perl5.008008 linux hs20-bc1-5.build.redhat.com 2.6.9-34.elsmp #1 smp fri feb 24 16:56:28 est 2006 x86_64 x86_64 x86_64 gnulinux
Compiler: gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
Linker: /usr/bin/ld
Sysliblist: -ldl -lm -lpthread -lnsl -lirc
Oracle makefiles would have used these definitions but we override them:
CC: /usr/bin/gcc
LDFLAGS: -g
[-g]
Linking with -L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/ -lclntsh -lpthread

Checking if your kit is complete...
Looks good
LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib
Using DBD::Oracle 1.23.
Using DBD::Oracle 1.23.
Using DBI 1.52 (for perl 5.008008 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-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?)

cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object.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 -p -e "s/~DRIVER~/Oracle/g" /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/Driver.xst > Oracle.xsi
/usr/bin/perl /usr/lib/perl5/5.8.8/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.8.8/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
gcc -c -I/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -DVERSION=\"1.23\" -DXS_VERSION=\"1.23\" -fPIC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" Oracle.c
gcc -c -I/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -DVERSION=\"1.23\" -DXS_VERSION=\"1.23\" -fPIC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" dbdimp.c
dbdimp.c: In function âfb_ary_cb_allocâ:
dbdimp.c:295: warning: comparison is always false due to limited range of data type
dbdimp.c:296: warning: comparison is always false due to limited range of data type
dbdimp.c:297: warning: comparison is always false due to limited range of data type
dbdimp.c:298: warning: comparison is always false due to limited range of data type
dbdimp.c:299: warning: comparison is always false due to limited range of data type
dbdimp.c: In function âfb_ary_allocâ:
dbdimp.c:315: warning: comparison is always false due to limited range of data type
dbdimp.c:316: warning: comparison is always false due to limited range of data type
dbdimp.c:317: warning: comparison is always false due to limited range of data type
dbdimp.c:318: warning: comparison is always false due to limited range of data type
gcc -c -I/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/ -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -DVERSION=\"1.23\" -DXS_VERSION=\"1.23\" -fPIC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" oci8.c
oci8.c: In function âora_blob_read_mb_pieceâ:
oci8.c:1235: warning: comparison is always false due to limited range of data type
oci8.c: In function âdescribe_obj_by_tdoâ:
oci8.c:2481: warning: comparison is always false due to limited range of data type
oci8.c: In function âora_describeâ:
oci8.c:2680: warning: comparison is always false due to limited range of data type
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
gcc -shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so \
-L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/ -lclntsh -lpthread \

/usr/bin/ld: skipping incompatible /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib//libclntsh.so when searching for -lclntsh
/usr/bin/ld: cannot find -lclntsh
collect2: ld returned 1 exit status
make: *** [blib/arch/auto/DBD/Oracle/Oracle.so] Error 1
/usr/bin/make -- NOT OK
Running make test
Can't test without successful make
Running make install
make had returned bad status, install seems impossible

Re: DBD::Oracle install problem on 64-bit RHEL51 [message #431327 is a reply to message #431326] Mon, 16 November 2009 19:17 Go to previous message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well. There is no 64 bit Oracle XE version, only a 32bit version.

And you can't link a 64 bit Perl to a 32bit Oracle. So you would need to run a 32bit version of Perl.

Or, you could install an additional 64bit Instantclient, and link Perl to that client's libraries.

Previous Topic: Unable to change Oracle SID with Net::SSH::Perl
Next Topic: Nested Tables with JDBC
Goto Forum:
  


Current Time: Thu Mar 28 04:31:51 CDT 2024