Hi,
We have the following installed on our Sun Solaris Server [SunOS 5.8]:
1. Perl 5.8.0
2. Perl DBI Module - Version 1.43
We are trying to install DBD (DBD-Oracle-1.15) Installation in Solaris [SunOS 5.8].
We are facing issues while executing "make test" after completing perl Makefile.PL,
followed by make. Any advise would be helpful in sorting this problem out. All the
details that we use are enclosed herewith. Thanks.
START of Extract perl Makefile.PL
=======================================================================================================================
perl Makefile.PL
Multiple copies of Driver.xst found in: /opt/perl/5.8.0/lib/sun4-solaris/auto/DBI
/opt/perl/5.8.0/lib/sun4-solaris/auto/DBI at Makefile.PL line 37
Using DBI 1.43 (for perl 5.008 on sun4-solaris) installed in
/opt/perl/5.8.0/lib/sun4-solaris/auto/DBI
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in /optware/oracle/9.2.0.4_64
Oracle version 9.2.0.0.0 (9.200)
Found /optware/oracle/9.2.0.4_64/rdbms/demo/demo_rdbms.mk
Found /optware/oracle/9.2.0.4_64/otrace/demo/atmoci.mk
Using /optware/oracle/9.2.0.4_64/rdbms/demo/demo_rdbms.mk
Reading /optware/oracle/9.2.0.4_64/rdbms/demo/demo_rdbms.mk
Reading /optware/oracle/9.2.0.4_64/rdbms/lib/env_rdbms.mk
Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/
because it is not already set in the environment
and it can cause ORA-01019 errors.
Deleting ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/
because it is not already set in the environment
and it can cause ORA-01019 errors.
Attempting to discover Oracle OCI build rules
cc -c -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/optware/oracle/9.2.0.4_64/rdbms/public -I/optware/oracle/9.2.0.4_64/plsql/public
-I/optware/oracle/9.2.0.4_64/network/public -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/optware/oracle/9.2.0.4_64/rdbms/public -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/opt/perl/5.8.0/lib/sun4-solaris/auto/DBI -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -KPIC
"-I/opt/perl/5.8.0/lib/sun4-solaris/CORE" -DUTF8_SUPPORT DBD_ORA_OBJ.c
by executing: [make -f /optware/oracle/9.2.0.4_64/rdbms/demo/demo_rdbms.mk build
ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=echo OPTIMIZE= CCFLAGS=
EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
Oracle oci build command:
[-L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build
-L/optware/oracle/9.2.0.4_64/rdbms/lib/ -L/optware/oracle/9.2.0.4_64/lib/ -o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9
-lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 -lnsl -lsocket
-lgen -ldl -R/optware/oracle/9.2.0.4_64/lib -laio -lposix4 -lkstat -lm -lthread]
Found header files in rdbms/public rdbms/demo.
Checking for functioning wait.ph
System: perl5.008 sunos guegs2 5.5.1p6a purecross sun4u sparc
Compiler: cc -O -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/ucb/ld
Sysliblist: -lnsl -lsocket -lgen -ldl
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/optware/oracle/9.2.0.4_64/rdbms/demo -I/optware/oracle/9.2.0.4_64/rdbms/public
-I/optware/oracle/9.2.0.4_64/plsql/public -I/optware/oracle/9.2.0.4_64/network/public
-DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD -D_REENTRANT $(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
[-o $@ -L/optware/oracle/9.2.0.4_64/rdbms/lib/ -L$(LIBHOME)]
Linking with OTHERLDFLAGS = -L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib
-L/optware/oracle/9.2.0.4_64/rdbms/lib/ -L/optware/oracle/9.2.0.4_64/lib/ -lclntsh
-lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9
-lntcps9 -lnsslb9 -lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl
-R/optware/oracle/9.2.0.4_64/lib -laio -lposix4 -lkstat -lm -lthread [from 'build'
rule]
Warning: If you have problems you may need to rebuild perl with threading enabled.
LD_RUN_PATH=/optware/oracle/9.2.0.4_64/lib32:/optware/oracle/9.2.0.4_64/rdbms/lib32
Using DBD::Oracle 1.15.
Using DBD::Oracle 1.15.
Multiple copies of Driver.xst found in: /opt/perl/5.8.0/lib/sun4-solaris/auto/DBI
/opt/perl/5.8.0/lib/sun4-solaris/auto/DBI at Makefile.PL line 1328
Using DBI 1.43 (for perl 5.008 on sun4-solaris) installed in
/opt/perl/5.8.0/lib/sun4-solaris/auto/DBI
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help files.
(Of course, you have read README by now anyway, haven't you?)
=======================================================================================================================
END of Extract perl Makefile.PL
START of Extract make
=======================================================================================================================
make
Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged)
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
cc -c -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/optware/oracle/9.2.0.4_64/rdbms/public -I/optware/oracle/9.2.0.4_64/plsql/public
-I/optware/oracle/9.2.0.4_64/network/public -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/optware/oracle/9.2.0.4_64/rdbms/public -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/opt/perl/5.8.0/lib/sun4-solaris/auto/DBI -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -KPIC
"-I/opt/perl/5.8.0/lib/sun4-solaris/CORE" -DUTF8_SUPPORT Oracle.c
cc -c -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/optware/oracle/9.2.0.4_64/rdbms/public -I/optware/oracle/9.2.0.4_64/plsql/public
-I/optware/oracle/9.2.0.4_64/network/public -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/optware/oracle/9.2.0.4_64/rdbms/public -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/opt/perl/5.8.0/lib/sun4-solaris/auto/DBI -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -KPIC
"-I/opt/perl/5.8.0/lib/sun4-solaris/CORE" -DUTF8_SUPPORT dbdimp.c
cc -c -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/optware/oracle/9.2.0.4_64/rdbms/public -I/optware/oracle/9.2.0.4_64/plsql/public
-I/optware/oracle/9.2.0.4_64/network/public -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/optware/oracle/9.2.0.4_64/rdbms/public -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/opt/perl/5.8.0/lib/sun4-solaris/auto/DBI -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -KPIC
"-I/opt/perl/5.8.0/lib/sun4-solaris/CORE" -DUTF8_SUPPORT oci7.c
cc -c -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/optware/oracle/9.2.0.4_64/rdbms/public -I/optware/oracle/9.2.0.4_64/plsql/public
-I/optware/oracle/9.2.0.4_64/network/public -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/optware/oracle/9.2.0.4_64/rdbms/public -I/optware/oracle/9.2.0.4_64/rdbms/demo
-I/opt/perl/5.8.0/lib/sun4-solaris/auto/DBI -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -KPIC
"-I/opt/perl/5.8.0/lib/sun4-solaris/CORE" -DUTF8_SUPPORT oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/optware/oracle/9.2.0.4_64/lib32:/optware/oracle/9.2.0.4_64/rdbms/lib32"
cc -G Oracle.o dbdimp.o oci7.o oci8.o -L/opt/SUNWcluster/lib
-R/opt/SUNWcluster/lib -L/optware/oracle/9.2.0.4_64/rdbms/lib/
-L/optware/oracle/9.2.0.4_64/lib/ -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9
-lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 -lnsl
-lsocket -lgen -ldl -R/optware/oracle/9.2.0.4_64/lib -laio -lposix4 -lkstat -lm
-lthread -o blib/arch/auto/DBD/Oracle/Oracle.so
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
cp ora_explain blib/script/ora_explain
/usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
Manifying blib/man3/DBD::Oracle.3
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oraperl.3
=======================================================================================================================
END of Extract make
START of Extract make test
=======================================================================================================================
make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
t/base.......ok
t/cursor.....ok
t/general....ok 3/24Can't get DBI::st=HASH(0x311fc)->{NUM_OFFIELDS_typo}: unrecognised
attribute at t/general.t line 41.
t/general....FAILED test 5
Failed 1/24 tests, 95.83% okay
t/long.......ok 145/372# failed test 146 at line 308.
# failed test 147 at line 309.
t/long.......NOK 146Use of uninitialized value in length at t/long.t line 311.
# failed test 148 at line 311.
Use of uninitialized value in substr at t/long.t line 315.
# failed test 149 at line 315.
t/long.......NOK 149# failed test 150 at line 319.
t/long.......NOK 150Use of uninitialized value in numeric eq (==) at t/long.t line 320.
# failed test 151 at line 320.
t/long.......NOK 151# failed test 152 at line 324.
t/long.......NOK 152# failed test 153 at line 328.
t/long.......NOK 153# failed test 154 at line 308.
# failed test 155 at line 309.
Use of uninitialized value in length at t/long.t line 311.
t/long.......NOK 154# failed test 156 at line 311.
Use of uninitialized value in substr at t/long.t line 315.
# failed test 157 at line 315.
t/long.......NOK 155# failed test 158 at line 319.
Use of uninitialized value in numeric eq (==) at t/long.t line 320.
# failed test 159 at line 320.
t/long.......NOK 156# failed test 160 at line 324.
t/long.......NOK 160# failed test 161 at line 328.
t/long.......NOK 161# failed test 162 at line 308.
# failed test 163 at line 309.
Use of uninitialized value in length at t/long.t line 311.
# failed test 164 at line 311.
t/long.......NOK 162Use of uninitialized value in substr at t/long.t line 315.
# failed test 165 at line 315.
# failed test 166 at line 319.
t/long.......NOK 163Use of uninitialized value in numeric eq (==) at t/long.t line 320.
# failed test 167 at line 320.
# failed test 168 at line 324.
t/long.......NOK 168# failed test 169 at line 328.
t/long.......ok 179/372# failed test 181 at line 348.
t/long.......NOK 181# failed test 183 at line 348.
t/long.......dubious
Test returned status 0 (wstat 138, 0x8a)
DIED. FAILED tests 146-169, 181, 183, 187-372
Failed 212/372 tests, 43.01% okay
t/meta.......ok
t/ph_type....ok 11/19 Placeholder behaviour for ora_type=1 (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/ph_type....ok
t/plsql......ok
t/reauth.....skipped
all skipped: no reason given
t/select.....Unexpectedly had to drop old test table 'dbd_ora__drop_me'
t/select.....ok
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/general.t 24 1 4.17% 5
t/long.t 0 138 372 212 56.99% 146-169 181 183 187-372
1 test skipped.
Failed 2/9 test scripts, 77.78% okay. 213/1535 subtests failed, 86.12% okay.
*** Error code 29
make: Fatal error: Command failed for target `test_dynamic'
=======================================================================================================================
END of Extract make test
START of Extract perl -V
=======================================================================================================================
perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
Platform:
osname=solaris, osvers=2.5.1p6a, archname=sun4-solaris
uname='sunos guegs2 5.5.1p6a purecross sun4u sparc '
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=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O',
cppflags=''
ccversion='WorkShop Compilers 4.2 30 Oct 1996 C 4.2', gccversion='',
gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=4
alignbytes=8, prototype=define
Linker and Libraries:
ld='cc', ldflags =' '
libpth=/usr/lib /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
/opt/perl/5.8.0/lib/sun4-solaris/CORE'
cccdlflags='-KPIC', lddlflags='-G'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under solaris
Compiled at Jan 14 2003 23:31:22
@INC:
/opt/perl/5.8.0/lib/sun4-solaris
/opt/perl/5.8.0/lib
/opt/perl/5.8.0/lib/sun4-solaris
/opt/perl/5.8.0/lib
/opt/perl/5.8.0/lib
.
=======================================================================================================================
END of Extract perl -V: Command failed for target `test_dynamic'
Best Regards
Shanmugam
