I'm trying to build DBI and DBD::Oracle to run on a Linux server
(2.6.18-274.7.1.el5) using the 11g (11.2.0.1) 32-bit client. The database
resides on a remote server and I can get to it just fine using sqlplus.
Here is the output from the make:
mvaughan - ni00 - /u/mvaughan/.cpan/build/DBD-Oracle-1.68-BdHkR5> 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/Hpux.pod
blib/lib/DBD/Oracle/Troubleshooting/Hpux.pod
cp lib/DBD/Oracle/Troubleshooting/Vms.pod
blib/lib/DBD/Oracle/Troubleshooting/Vms.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/Troubleshooting/Aix.pod
blib/lib/DBD/Oracle/Troubleshooting/Aix.pod
cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object.pm
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 -p -e "s/~DRIVER~/Oracle/g"
/u/mvaughan/perl.lib/lib64/perl5/site_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/u01/app/oracle/product/11.2.0/client32/rdbms/public
-I/u01/app/oracle/product/11.2.0/client32/rdbms/demo
-I/u01/app/oracle/product/11.2.0/client32/rdbms/public
-I/u01/app/oracle/product/11.2.0/client32/plsql/public
-I/u01/app/oracle/product/11.2.0/client32/network/public
-I/u/mvaughan/perl.lib/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI
-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.68\"
-DXS_VERSION=\"1.68\" -fPIC
"-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DORA_OCI_102 -DORA_OCI_112
Oracle.c
gcc -c -I/u01/app/oracle/product/11.2.0/client32/rdbms/public
-I/u01/app/oracle/product/11.2.0/client32/rdbms/demo
-I/u01/app/oracle/product/11.2.0/client32/rdbms/public
-I/u01/app/oracle/product/11.2.0/client32/plsql/public
-I/u01/app/oracle/product/11.2.0/client32/network/public
-I/u/mvaughan/perl.lib/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI
-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.68\"
-DXS_VERSION=\"1.68\" -fPIC
"-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DORA_OCI_102 -DORA_OCI_112
dbdimp.c
dbdimp.c: In function 'fb_ary_cb_alloc':
dbdimp.c:324: warning: comparison is always false due to limited range of data
type
dbdimp.c:325: warning: comparison is always false due to limited range of data
type
dbdimp.c:326: warning: comparison is always false due to limited range of data
type
dbdimp.c:327: warning: comparison is always false due to limited range of data
type
dbdimp.c:328: warning: comparison is always false due to limited range of data
type
dbdimp.c: In function 'fb_ary_alloc':
dbdimp.c:344: warning: comparison is always false due to limited range of data
type
dbdimp.c:345: warning: comparison is always false due to limited range of data
type
dbdimp.c:346: warning: comparison is always false due to limited range of data
type
dbdimp.c:347: warning: comparison is always false due to limited range of data
type
gcc -c -I/u01/app/oracle/product/11.2.0/client32/rdbms/public
-I/u01/app/oracle/product/11.2.0/client32/rdbms/demo
-I/u01/app/oracle/product/11.2.0/client32/rdbms/public
-I/u01/app/oracle/product/11.2.0/client32/plsql/public
-I/u01/app/oracle/product/11.2.0/client32/network/public
-I/u/mvaughan/perl.lib/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI
-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.68\"
-DXS_VERSION=\"1.68\" -fPIC
"-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DORA_OCI_102 -DORA_OCI_112 oci8.c
oci8.c: In function 'ora_blob_read_mb_piece':
oci8.c:1802: warning: comparison is always false due to limited range of data
type
oci8.c: In function 'describe_obj_by_tdo':
oci8.c:3254: warning: comparison is always false due to limited range of data
type
oci8.c: In function 'ora_describe':
oci8.c:3478: 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/u01/app/oracle/product/11.2.0/client32/lib/ -lclntsh -ldl -lm
-lpthread -lnsl -lirc -lipgo -ldl -lm \
/usr/bin/ld: skipping incompatible
/u01/app/oracle/product/11.2.0/client32/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
No matter what I've tried, I cannot get the linking to complete successfully.
I've been successful in getting this to work in a similar environment but with
a local DB.
Thank you in advance for all responses.
