Installing DBD::Oracle for 11gR2
- From: Janine Sisk <janine@xxxxxxxxxx>
- To: oracle-l L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Apr 2010 12:10:07 -0700
First time I'm trying to do this, and it is fighting me every step of the way...
I got through the easy problems (the test account was locked and had an expired
password), but these look like more substantial errors. Yet I don't find *any*
posts about this in Google, so is it just me? Does no-one use this anymore?
I'm installing this so I can use the check_oracle_health Nagios plugin - if
there is a better way to go, I'm all ears.
Full install log is below...
thanks,
janine
[root@internal pam.d]# perl -MCPAN -e 'install DBD::Oracle'
CPAN: Storable loaded ok (v2.21)
Going to read '/root/.cpan/Metadata'
Database was generated on Tue, 23 Feb 2010 15:04:12 GMT
Running install for module 'DBD::Oracle'
Running make for P/PY/PYTHIAN/DBD-Oracle-1.24a.tar.gz
CPAN: Digest::SHA loaded ok (v5.48)
CPAN: Compress::Zlib loaded ok (v2.024)
Checksum for
/root/.cpan/sources/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.24a.tar.gz ok
CPAN: Archive::Tar loaded ok (v1.58)
DBD-Oracle-1.24/
DBD-Oracle-1.24/README.java.txt
DBD-Oracle-1.24/t/
DBD-Oracle-1.24/t/55nested.t
DBD-Oracle-1.24/t/23wide_db.t
DBD-Oracle-1.24/t/10general.t
DBD-Oracle-1.24/t/80ora_charset.t
DBD-Oracle-1.24/t/31lob_extended.t
DBD-Oracle-1.24/t/58object.t
DBD-Oracle-1.24/t/26exe_array.t
DBD-Oracle-1.24/t/22nchar_utf8.t
DBD-Oracle-1.24/t/40ph_type.t
DBD-Oracle-1.24/t/21nchar.t
DBD-Oracle-1.24/t/22nchar_al32utf8.t
DBD-Oracle-1.24/t/14threads.t
DBD-Oracle-1.24/t/56embbeded.t
DBD-Oracle-1.24/t/51scroll.t
DBD-Oracle-1.24/t/15nls.t
DBD-Oracle-1.24/t/60reauth.t
DBD-Oracle-1.24/t/25plsql.t
DBD-Oracle-1.24/t/34pres_lobs.t
DBD-Oracle-1.24/t/23wide_db_8bit.t
DBD-Oracle-1.24/t/28array_bind.t
DBD-Oracle-1.24/t/24implicit_utf8.t
DBD-Oracle-1.24/t/nchar_test_lib.pl
DBD-Oracle-1.24/t/50cursor.t
DBD-Oracle-1.24/t/32xmltype.t
DBD-Oracle-1.24/t/23wide_db_al32utf8.t
DBD-Oracle-1.24/t/20select.t
DBD-Oracle-1.24/t/12impdata.t
DBD-Oracle-1.24/t/70meta.t
DBD-Oracle-1.24/t/31lob.t
DBD-Oracle-1.24/t/30long.t
DBD-Oracle-1.24/t/01base.t
DBD-Oracle-1.24/Oracle.ex/
DBD-Oracle-1.24/Oracle.ex/README
DBD-Oracle-1.24/Oracle.ex/sql
DBD-Oracle-1.24/Oracle.ex/bind.pl
DBD-Oracle-1.24/Oracle.ex/commit.pl
DBD-Oracle-1.24/Oracle.ex/tabinfo.pl
DBD-Oracle-1.24/Oracle.ex/ex.pl
DBD-Oracle-1.24/Oracle.ex/curref.pl
DBD-Oracle-1.24/Oracle.ex/japh
DBD-Oracle-1.24/Oracle.ex/proc.pl
DBD-Oracle-1.24/Oracle.ex/mktable.pl
DBD-Oracle-1.24/Oracle.ex/oradump.pl
DBD-Oracle-1.24/Changes
DBD-Oracle-1.24/Oracle.h
DBD-Oracle-1.24/MANIFEST
DBD-Oracle-1.24/typemap
DBD-Oracle-1.24/README-files/
DBD-Oracle-1.24/README-files/hpux/
DBD-Oracle-1.24/README-files/hpux/Conf-Merijn-588-11.11-gcc64
DBD-Oracle-1.24/README-files/hpux/Conf-Mike
DBD-Oracle-1.24/README-files/hpux/Conf-Merijn-588-10.20-gcc
DBD-Oracle-1.24/README-files/hpux/Conf-Lincoln-1.06
DBD-Oracle-1.24/README-files/hpux/Conf-Merijn-588-11.11-gcc32
DBD-Oracle-1.24/README-files/hpux/Makefile-Lincoln
DBD-Oracle-1.24/README-files/hpux/Conf-Merijn-585-11.00-cc
DBD-Oracle-1.24/README-files/hpux/Conf-Roger
DBD-Oracle-1.24/README-files/hpux/Conf-Merijn-588-11.00-gcc64
DBD-Oracle-1.24/README-files/hpux/Conf-Lincoln-1.07
DBD-Oracle-1.24/README-files/hpux/libjava.eml
DBD-Oracle-1.24/README-files/hpux/Conf-Merijn-580-10.20-cc
DBD-Oracle-1.24/README-files/hpux/Conf-Merijn-588-11.00-gcc32
DBD-Oracle-1.24/README-files/hpux/Conf-Merijn-587-11.23-cc
DBD-Oracle-1.24/README-files/hpux/Conf-Merijn-585-11.11-cc
DBD-Oracle-1.24/README-files/hpux/Conf-Merijn-588-11.23-gcc64
DBD-Oracle-1.24/README.hpux.txt
DBD-Oracle-1.24/lib/
DBD-Oracle-1.24/lib/DBD/
DBD-Oracle-1.24/lib/DBD/Oracle/
DBD-Oracle-1.24/lib/DBD/Oracle/GetInfo.pm
DBD-Oracle-1.24/lib/DBD/Oracle/Object.pm
DBD-Oracle-1.24/dbdimp.c
DBD-Oracle-1.24/README.login.txt
DBD-Oracle-1.24/README.linux.txt
DBD-Oracle-1.24/README.vms.txt
DBD-Oracle-1.24/README.win32.txt
DBD-Oracle-1.24/hints/
DBD-Oracle-1.24/hints/macos_syms.pl
DBD-Oracle-1.24/hints/svr4.pl
DBD-Oracle-1.24/hints/macos_bundle.syms
DBD-Oracle-1.24/hints/dgux.pl
DBD-Oracle-1.24/hints/macos_lib.syms
DBD-Oracle-1.24/oraperl.ph
DBD-Oracle-1.24/README.longs.txt
DBD-Oracle-1.24/README.macosx.txt
DBD-Oracle-1.24/README.win64.txt
DBD-Oracle-1.24/test.pl
DBD-Oracle-1.24/oci.def
DBD-Oracle-1.24/Todo
DBD-Oracle-1.24/Oraperl.pm
DBD-Oracle-1.24/README.help.txt
DBD-Oracle-1.24/README.explain.txt
DBD-Oracle-1.24/README
DBD-Oracle-1.24/ora_explain.PL
DBD-Oracle-1.24/README.sec.txt
DBD-Oracle-1.24/oci8.c
DBD-Oracle-1.24/META.yml
DBD-Oracle-1.24/README.wingcc.txt
DBD-Oracle-1.24/dbdimp.h
DBD-Oracle-1.24/ocitrace.h
DBD-Oracle-1.24/Oracle.xs
DBD-Oracle-1.24/README.sun.txt
DBD-Oracle-1.24/Oracle.pm
DBD-Oracle-1.24/dbivport.h
DBD-Oracle-1.24/README.clients.txt
DBD-Oracle-1.24/mkta.pl
DBD-Oracle-1.24/README.aix.txt
DBD-Oracle-1.24/Makefile.PL
DBD-Oracle-1.24/README.64bit.txt
CPAN: File::Temp loaded ok (v0.22)
CPAN: YAML loaded ok (v0.71)
CPAN.pm: Going to build P/PY/PYTHIAN/DBD-Oracle-1.24a.tar.gz
Using DBI 1.609 (for perl 5.008008 on x86_64-linux-thread-multi) installed in
/usr/lib64/perl5/site_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 /u01/app/oracle/product/11.2.0/dbhome_1
DEFINE _SQLPLUS_RELEASE = "1102000100" (CHAR)
Oracle version 11.2.0.1 (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 LD_LIBRARY_PATH 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
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.
Checking for functioning wait.ph
System: perl5.008008 linux builder10.centos.org 2.6.18-53.el5 #1 smp mon nov 12
02:14:55 est 2007 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 -lipgo -lsvml
Oracle makefiles would have used these definitions but we override them:
CC: $(COMPDIR)/bin/gcc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -O3 $(CDEBUG) -m32 -trigraphs -fPIC
-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 -DLINUX -D_GNU_SOURCE
-D_LARGEFILE64_SOURCE=1 -D_LARGEFILE_SOURCE=1 -DSLTS_ENABLE -DSLMXMX_ENABLE
-D_REENTRANT -DNS_THREADS -D__NO_CTYPE=1 -DLDAP_CM $(LPFLAGS) $(PLSQLNCGFLAGS)
$(USRFLAGS)]
LDFLAGS: $(LDFLAGS32)
[-m32 -o $@ -L/u01/app/oracle/product/11.2.0/dbhome_1/rdbms//lib32/
-L/u01/app/oracle/product/11.2.0/dbhome_1/lib32/
-L/u01/app/oracle/product/11.2.0/dbhome_1/lib32/stubs/]
Linking with -lclntsh -ldl -lm -lpthread -lnsl -lirc -lipgo -lsvml -ldl -lm
-lpthread [from $(OCISHAREDLIBS)]
Checking if your kit is complete...
Looks good
LD_RUN_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib
Using DBD::Oracle 1.24.
Using DBD::Oracle 1.24.
Using DBI 1.609 (for perl 5.008008 on x86_64-linux-thread-multi) installed in
/usr/lib64/perl5/site_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/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/Driver.xst
> Oracle.xsi
/usr/bin/perl /usr/lib/perl5/site_perl/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/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/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.24\"
-DXS_VERSION=\"1.24\" -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=\"11.2.0.1\" Oracle.c
gcc -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/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.24\"
-DXS_VERSION=\"1.24\" -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=\"11.2.0.1\" dbdimp.c
dbdimp.c: In function 'fb_ary_cb_alloc':
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:300: warning: comparison is always false due to limited range of data
type
dbdimp.c:301: warning: comparison is always false due to limited range of data
type
dbdimp.c:302: warning: comparison is always false due to limited range of data
type
dbdimp.c: In function 'fb_ary_alloc':
dbdimp.c:318: warning: comparison is always false due to limited range of data
type
dbdimp.c:319: warning: comparison is always false due to limited range of data
type
dbdimp.c:320: warning: comparison is always false due to limited range of data
type
dbdimp.c:321: warning: comparison is always false due to limited range of data
type
gcc -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/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.24\"
-DXS_VERSION=\"1.24\" -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=\"11.2.0.1\" oci8.c
oci8.c: In function 'ora_blob_read_mb_piece':
oci8.c:1597: warning: comparison is always false due to limited range of data
type
oci8.c: In function 'describe_obj_by_tdo':
oci8.c:2957: warning: comparison is always false due to limited range of data
type
oci8.c: In function 'ora_describe':
oci8.c:3158: 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
LD_RUN_PATH="/u01/app/oracle/product/11.2.0/dbhome_1/lib" 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/dbhome_1/lib/ -lclntsh -ldl -lm
-lpthread -lnsl -lirc -lipgo -lsvml -ldl -lm -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
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/ora_explain
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oracle.3pm
Manifying blib/man3/DBD::Oraperl.3pm
PYTHIAN/DBD-Oracle-1.24a.tar.gz
/usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
t/01base.t .............. # Test loading DBI, DBD::Oracle and version
t/01base.t .............. ok
t/10general.t ........... ok
t/12impdata.t ........... ok
t/14threads.t ........... ok
t/15nls.t ............... ok
t/20select.t ............ ok
t/21nchar.t ............. ok
t/22nchar_al32utf8.t .... ok
t/22nchar_utf8.t ........ ok
t/23wide_db.t ........... ok
t/23wide_db_8bit.t ...... ok
t/23wide_db_al32utf8.t .. ok
t/24implicit_utf8.t ..... ok
t/25plsql.t ............. ok
t/26exe_array.t ......... ok
t/28array_bind.t ........ ok
t/30long.t .............. ok
t/31lob.t ............... 1/11 DBD::Oracle::st execute failed: ORA-24813:
cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute) [for
Statement "BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;" with ParamValues:
:p1=undef, :p2=OCILobLocatorPtr=SCALAR(0xb84990)] at t/31lob.t line 123.
t/31lob.t ............... Dubious, test returned 1 (wstat 256, 0x100)
Failed 4/11 subtests
t/31lob_extended.t ...... ok
t/32xmltype.t ........... ok
t/34pres_lobs.t ......... ok
t/40ph_type.t ........... 1/19 Placeholder behaviour for ora_type=1 VARCHAR2
(the default) varies with Oracle version.
Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
Your system doesn't. If that seems odd, let us know.
t/40ph_type.t ........... ok
t/50cursor.t ............ Can't determine open_cursors from v$parameter, so
using default
t/50cursor.t ............ ok
t/51scroll.t ............ ok
t/55nested.t ............ ok
t/56embbeded.t .......... ok
t/58object.t ............ ok
t/60reauth.t ............ skipped: ORACLE_USERID_2 not defined.
t/70meta.t .............. ok
t/80ora_charset.t ....... ok
Test Summary Report
-------------------
t/31lob.t (Wstat: 256 Tests: 8 Failed: 1)
Failed test: 8
Non-zero exit status: 1
Parse errors: Bad plan. You planned 11 tests but ran 8.
Files=30, Tests=1280, 28 wallclock secs ( 0.15 usr 0.06 sys + 4.34 cusr 0.83
csys = 5.38 CPU)
Result: FAIL
Failed 1/30 test programs. 1/1280 subtests failed.
make: *** [test_dynamic] Error 255
PYTHIAN/DBD-Oracle-1.24a.tar.gz
/usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
reports PYTHIAN/DBD-Oracle-1.24a.tar.gz
Running make install
make test had returned bad status, won't install without force
--
//www.freelists.org/webpage/oracle-l
Other related posts:
