Has anyone had any success installing DBD::Oracle 1.22 on Solaris 10
with Perl 5.8.4? I have tried a number of times from CPAN and also
downloaded it and have tried modifying the Makefile to no avail. I've
pasted the most relevant output below. Thanks in advance!
uname -a:
SunOS kennemo02d 5.10 Generic_127111-11 sun4v sparc SUNW,Sun-Fire-T200
perl -V:
Summary of my perl5 (revision 5 version 8 subversion 4) configuration:
Platform:
osname=solaris, osvers=2.10, archname=sun4-solaris-64int
uname='sunos localhost 5.10 sun4u sparc SUNW,Ultra-2'
config_args=''
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=define use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -
xarch=v8 -D_TS_ERRNO',
optimize='-xO3 -xspace -xildoff',
cppflags=''
ccversion='Sun WorkShop', gccversion='', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=87654321
d_longlong=define, longlongsize=8, d_longdbl=define,
longdblsize=16
ivtype='long long', ivsize=8, nvtype='double', nvsize=8,
Off_t='off_t', lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='cc', ldflags =''
libpth=/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lc
perllibs=-lsocket -lnsl -ldl -lm -lc
libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-R /usr/
perl5/5.8.4/lib/sun4-solaris-64int/CORE'
cccdlflags='-KPIC', lddlflags='-G'
Characteristics of this binary (from libperl):
Compile-time options: USE_64_BIT_INT USE_LARGE_FILES
Locally applied patches:
22667 The optree builder was looping when constructing the
ops ...
22715 Upgrade to FileCache 1.04
22733 Missing copyright in the README.
22746 fix a coredump caused by rv2gv not fully converting a
PV ...
22755 Fix 29149 - another UTF8 cache bug hit by substr.
22774 [perl #28938] split could leave an array without ...
22775 [perl #29127] scalar delete of empty slice returned
garbage
22776 [perl #28986] perl -e "open m" crashes Perl
22777 add test for change #22776 ("open m" crashes Perl)
22778 add test for change #22746 ([perl #29102] Crash on
assign ...
22781 [perl #29340] Bizarre copy of ARRAY make sure a pad
op's ...
22796 [perl #29346] Double warning for int(undef) and abs
(undef) ...
22818 BOM-marked and (BOMless) UTF-16 scripts not working
22823 [perl #29581] glob() misses a lot of matches
22827 Smoke [5.9.2] 22818 FAIL(F) MSWin32 WinXP/.Net SP1
(x86/1 cpu)
22830 [perl #29637] Thread creation time is hypersensitive
22831 improve hashing algorithm for ptr tables in
perl_clone: ...
22839 [perl #29790] Optimization busted: '@a = "b", sort
@a' ...
22850 [PATCH] 'perl -v' fails if local_patches contains code
snippets
22852 TEST needs to ignore SCM files
22886 Pod::Find should ignore SCM files and dirs
22888 Remove redundant %SIG assignments from FileCache
23006 [perl #30509] use encoding and "eq" cause memory leak
23074 Segfault using HTML::Entities
23106 Numeric comparison operators mustn't compare addresses
of ...
23320 [perl #30066] Memory leak in nested shared data
structures ...
23321 [perl #31459] Bug in read()
27722 perlio.c breaks on Solaris/gcc when > 256 FDs are
available
SPRINTF0 - fixes for sprintf formatting issues - CVE-2005-3962
Built under solaris
Compiled at Aug 8 2007 19:08:30
@INC:
/usr/perl5/5.8.4/lib/sun4-solaris-64int
/usr/perl5/5.8.4/lib
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int
/usr/perl5/site_perl/5.8.4
/usr/perl5/site_perl
/usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int
/usr/perl5/vendor_perl/5.8.4
/usr/perl5/vendor_perl
# /usr/perl5/5.8.4/bin/perlgcc -MCPAN -e shell
cpan> install DBD::Oracle
[snip]
CPAN.pm: Going to build P/PY/PYTHIAN/DBD-Oracle-1.22.tar.gz
Using DBI 1.607 (for perl 5.008004 on sun4-solaris-64int) installed
in /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/
Configuring DBD::Oracle for perl 5.008004 on solaris (sun4-
solaris-64int)
Remember to actually *READ* the README file! Especially if you have
any problems.
Installing on a solaris, Ver#2.10
Using Oracle in /vendor/oracle/client/orabase/product/10.2.0
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found /vendor/oracle/client/orabase/product/10.2.0/rdbms/lib/
ins_rdbms.mk
Using /vendor/oracle/client/orabase/product/10.2.0/rdbms/lib/
ins_rdbms.mk
Your LD_LIBRARY_PATH env var is set to '/vendor/oracle/client/orabase/
product/10.2.0/lib:/vendor/oracle/client/orabase/product/10.2.0/perl/
lib/5.6.1'
WARNING: Your LD_LIBRARY_PATH env var doesn't include '/vendor/oracle/
client/orabase/product/10.2.0/lib32' but probably needs to.
Reading /vendor/oracle/client/orabase/product/10.2.0/rdbms/lib/
ins_rdbms.mk
Reading /vendor/oracle/client/orabase/product/10.2.0/rdbms/lib/
env_rdbms.mk
WARNING: Oracle /vendor/oracle/client/orabase/product/10.2.0/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 /vendor/oracle/client/orabase/product/10.2.0/
plsql/public.
*********************************************************
I can't find the header files I need in your Oracle installation.
You probably need to install some more Oracle components.
For Instant Client that means the SDK package.
I'll keep going, but the compile will probably fail.
See the appropriate README file for your OS for more information.
*********************************************************
Checking for functioning wait.ph
System: perl5.008004 sunos localhost 5.10 sun4u sparc SUNW,Ultra-2
Compiler: gcc -O2 -fno-strict-aliasing -D_LARGEFILE_SOURCE -
D_FILE_OFFSET_BITS=64 -D_TS_ERRNO
Linker: /usr/ccs/bin/ld
Sysliblist: -lkstat -lnsl -lsocket -lgen -ldl -lsched
Oracle makefiles would have used these definitions but we override
them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -xO3 $(CDEBUG) -Xa $(PROFILE) -xstrconst -dalign -
xF $(XS) $(MR) -xildoff -errtags=yes -v -xarch=v9 -xchip=ultra3 -W2,-
AKNR_S -Wd,-xsafe=unboundsym -Wc,-Qiselect-funcalign=32 -xcode=abs44 -
Wc,-Qgsched-trace_late=1 -Wc,-Qgsched-T5 -xalias_level=weak -
D_REENTRANT -DSS_64BIT_SERVER -DBIT64 -DMACHINE64 -K PIC -I/vendor/
oracle/client/orabase/product/10.2.0/rdbms/demo -I/vendor/oracle/
client/orabase/product/10.2.0/rdbms/public -I/vendor/oracle/client/
orabase/product/10.2.0/plsql/public -I/vendor/oracle/client/orabase/
product/10.2.0/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -
D_SVID_GETTOD -D_REENTRANT $(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
[-o $@ -L/vendor/oracle/client/orabase/product/10.2.0/rdbms/
lib/ -L$(LIBHOME)]
Linking with /vendor/oracle/client/orabase/product/10.2.0/rdbms/lib32/
defopt.o -lclntsh -lkstat -lnsl -lsocket -lgen -ldl -lsched -R/vendor/
oracle/client/orabase/product/10.2.0/lib32 -laio -lposix4 -lkstat -lm -
lthread -lpthread [from $(DEF_OPT) $(OCISHAREDLIBS)]
WARNING: If you have problems you may need to rebuild perl with
threading enabled.
Checking if your kit is complete...
Warning: the following files are missing in your kit:
META.yml
Please inform the author.
LD_RUN_PATH=/vendor/oracle/client/orabase/product/10.2.0/lib32:/lib
Using DBD::Oracle 1.22.
Using DBD::Oracle 1.22.
Using DBI 1.607 (for perl 5.008004 on sun4-solaris-64int) installed
in /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/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/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
/usr/perl5/5.8.4/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/perl5/
site_perl/5.8.4/sun4-solaris-64int/auto/DBI/Driver.xst > Oracle.xsi
/usr/perl5/5.8.4/bin/perl /usr/perl5/5.8.4/lib/ExtUtils/xsubpp -
typemap /usr/perl5/5.8.4/lib/ExtUtils/typemap -typemap typemap
Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
gcc -c -I/vendor/oracle/client/orabase/product/10.2.0/plsql/public -I/
vendor/oracle/client/orabase/product/10.2.0/rdbms/demo -I/vendor/
oracle/client/orabase/product/10.2.0/rdbms/public -I/vendor/oracle/
client/orabase/product/10.2.0/plsql/public -I/vendor/oracle/client/
orabase/product/10.2.0/network/public -I/usr/perl5/site_perl/5.8.4/
sun4-solaris-64int/auto/DBI -D_LARGEFILE_SOURCE -
D_FILE_OFFSET_BITS=64 -D_TS_ERRNO -O2 -fno-strict-aliasing -
DVERSION=\"1.22\" -DXS_VERSION=\"1.22\" -fPIC "-I/usr/perl5/5.8.4/lib/
sun4-solaris-64int/CORE" -DUTF8_SUPPORT -DNEW_OCI_INIT -
DORA_OCI_VERSION=\"10.2.0.1\" Oracle.c
In file included from Oracle.xs:1:
Oracle.h:37:17: oci.h: No such file or directory
Oracle.h:39:20: ocidfn.h: No such file or directory
Oracle.h:40:18: orid.h: No such file or directory
Oracle.h:41:17: ori.h: No such file or directory
In file included from Oracle.h:53,
from Oracle.xs:1:
[snip]
Oracle.xsi:21: error: invalid application of `sizeof' to incomplete
type `/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/DBIXS.h'
Oracle.xsi:22: error: invalid application of `sizeof' to incomplete
type `/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/DBIXS.h'
Oracle.xsi:23: error: invalid application of `sizeof' to incomplete
type `/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/DBIXS.h'
*** Error code 1
make: Fatal error: Command failed for target `Oracle.o'
/usr/ccs/bin/make -- NOT OK
Many Thanks,
Jacob
