zjzc01:/usr/bin# mv perl.bak perlold zjzc01:/usr/bin# cd zjzc01:/root# cd DBD-Oracle-1.36 zjzc01:/root/DBD-Oracle-1.36# perlold Makefile.PL -m /usr/share/oracle/11.2/client64/demo.mk Using DBI 1.609 (for perl 5.010001 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/auto/DBI/ Configuring DBD::Oracle for perl 5.010001 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 /u01/app/oracle/product/11.2.0.4/db_1 Can't find sqlplus. Pity, it would have helped. I'm having trouble finding your Oracle version number... trying harder Oracle version 11.2.0.4 (11.2) Found /usr/share/oracle/11.2/client64/demo.mk Using /usr/share/oracle/11.2/client64/demo.mk Your LD_LIBRARY_PATH env var is set to '/u01/app/oracle/product/11.2.0.4/db_1/lib:/lib:/usr/lib' Reading /usr/share/oracle/11.2/client64/demo.mk WARNING: Oracle /usr/share/oracle/11.2/client64/demo.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 /usr/include/oracle/11.2/client64. client_version=11.2 DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION="11.2.0.4" -DORA_OCI_102 -DORA_OCI_112 Checking for functioning wait.ph System: perl5.010001 linux c6b8.bsys.dev.centos.org 2.6.32-220.el6.x86_64 #1 smp tue dec 6 19:48:22 gmt 2011 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 -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 Linker: /usr/bin/ld Sysliblist: Oracle makefiles would have used these definitions but we override them: CC: /usr/bin/gcc LDFLAGS: -g [-g] Linking with -L../../ -locci -lclntsh -lpthread [from $(CCLIB)] Warning: -L../../ changed to -L/root/DBD-Oracle-1.36/../../ LD_RUN_PATH=/u01/app/oracle/product/11.2.0.4/db_1/lib Using DBD::Oracle 1.36. Using DBD::Oracle 1.36. Using DBI 1.609 (for perl 5.010001 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/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?) zjzc01:/root/DBD-Oracle-1.36# make Skip blib/lib/DBD/Oracle.pm (unchanged) Skip blib/lib/oraperl.ph (unchanged) Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged) Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged) Skip blib/lib/Oraperl.pm (unchanged) Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged) Skip blib/lib/DBD/Oracle/Troubleshooting.pm (unchanged) Skip blib/lib/DBD/Oracle/Object.pm (unchanged) Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged) cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm gcc -c -I/usr/include/oracle/11.2/client64 -I/usr/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -DVERSION="1.36" -DXS_VERSION="1.36" -fPIC "-I/usr/lib64/perl5/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION="11.2.0.4" -DORA_OCI_102 -DORA_OCI_112 Oracle.c gcc -c -I/usr/include/oracle/11.2/client64 -I/usr/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -DVERSION="1.36" -DXS_VERSION="1.36" -fPIC "-I/usr/lib64/perl5/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION="11.2.0.4" -DORA_OCI_102 -DORA_OCI_112 dbdimp.c dbdimp.c: In function ‘ora_db_login6’: dbdimp.c:765: warning: format ‘%d’ expects type ‘int’, but argument 12 has type ‘size_t’ dbdimp.c:765: warning: format ‘%d’ expects type ‘int’, but argument 14 has type ‘size_t’ gcc -c -I/usr/include/oracle/11.2/client64 -I/usr/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -DVERSION="1.36" -DXS_VERSION="1.36" -fPIC "-I/usr/lib64/perl5/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION="11.2.0.4" -DORA_OCI_102 -DORA_OCI_112 oci8.c oci8.c: In function ‘ora_blob_read_mb_piece’: oci8.c:1786: warning: format ‘%lu’ expects type ‘long unsigned int’, but argument 6 has type ‘ub4’ oci8.c: In function ‘ora_st_fetch’: oci8.c:3746: warning: unused variable ‘imp_xxh’ 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.4/db_1/lib -L/root/DBD-Oracle-1.36/../.. -locci -lclntsh -lpthread chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs Manifying blib/man3/DBD::Oracle.3pm Manifying blib/man3/DBD::Oracle::Troubleshooting.3pm Manifying blib/man3/DBD::Oraperl.3pm zjzc01:/root/DBD-Oracle-1.36# make install Files found in blib/arch: installing files in blib/lib into architecture dependent library tree Installing /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so Installing /usr/local/lib64/perl5/auto/DBD/Oracle/ocitrace.h Installing /usr/local/lib64/perl5/auto/DBD/Oracle/dbdimp.h Installing /usr/local/lib64/perl5/auto/DBD/Oracle/mk.pm Installing /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.bs Installing /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.h Installing /usr/local/lib64/perl5/Oraperl.pm Installing /usr/local/lib64/perl5/oraperl.ph Installing /usr/local/lib64/perl5/DBD/Oracle.pm Installing /usr/local/lib64/perl5/DBD/Oracle/Object.pm Installing /usr/local/lib64/perl5/DBD/Oracle/GetInfo.pm Installing /usr/local/lib64/perl5/DBD/Oracle/Troubleshooting.pm Installing /usr/local/share/man/man3/DBD::Oracle.3pm Installing /usr/local/share/man/man3/DBD::Oracle::Troubleshooting.3pm Installing /usr/local/share/man/man3/DBD::Oraperl.3pm Appending installation info to /usr/lib64/perl5/perllocal.pod zjzc01:/root/DBD-Oracle-1.36# perlold -v This is perl, v5.10.1 (*) built for x86_64-linux-thread-multi