Build error - DBD::Oracle, Oracle 11.2.0.1, 32-bit client, remote DB
"Vaughan, Mark" <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <55BC400CFF41A94AAE7062AB10940B3F022CD0@stntexmb12.cis.neustar.com> |
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.