My organization is strict about adding “un-supported” software. Since Sun includes Perl 5.005 03 with Solaris 8, I can add the DBI 1.30 and the DBD::Oracle 1.12 modules but I can’t install gcc on that system. One other thing, this is all for Oracle 9.2.0.
I plan to build these Perl modules on another Solaris 8 system where gcc is installed and then move the modules to the production system.
MY QUESTION IS; Is this possible?
I've included the output of perl -V, output of the DBD::Oracle-1.12 'make test' that had errors and the files I tar'ed up and moved to the production system.
First, to get things working, I needed to make changes to Config.pm to use ‘–fPIC’ instead of ‘–KPIC’
and ‘–xnone’ instead of '-xO3 -xdepend'
Also had to hand edited the Makefile for DBD::Oracle 1.12 to change all the references to the Oracle libraries from /lib to /lib32 to get this far.
Here is the output of perl –V which is identical on both systems except for the changes made to Config.pm on the system with gcc installed;
# perl -V
Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
Platform:
osname=solaris, osvers=2.8, archname=sun4-solaris
uname='sunos localhost 5.8 sun4u sparc sunw,ultra-1 '
hint=previous, useposix=true, d_sigaction=define
usethreads=undef useperlio=undef d_sfio=undef
Compiler:
cc='cc', optimize='-xnone', gccversion=
cppflags=''
ccflags =''
stdchar='char', d_stdstdio=define, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
alignbytes=8, usemymalloc=n, prototype=define
Linker and Libraries:
ld='cc', ldflags =''
libpth=/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lc -lcrypt
libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-R /usr/perl5/5.00503/sun4-solaris/CORE'
cccdlflags='-fPIC', lddlflags='-G'
Characteristics of this binary (from libperl): Built under solaris Compiled at Dec 22 1999 00:00:57 @INC: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .
The built of the DBI 1.30 module went OK.
These are the errors during ‘make test’ for the DBD::Oracle-1.12 module. Most of the errors are “ORA-01950: no privileges on tablespace 'USERS'” or “ORA-00942: table or view does not exist”
Looks like the test account I ask to be set up doesn’t permission to do those functions.
Script started on Wed Sep 17 10:06:05 2003
# ksh
# pwd /tmp/work/DBD-Oracle-1.12
# echo $ORACLE_USERID alheidgj/********
# echo $TWO_TASK hsrc.world
# echo $ORACLE_HOME /hsrc/oracle/app/oracle/product/9.2
# make test TEST_VERBOSE=1 PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib \ -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503 \ -e 'use Test::Harness qw(&runtests $verbose); $verbose=1; \ runtests @ARGV;' t/*.t
t/base.......1..5 ok 1 ok 2 ok 3 ok 4 ok 5 ok
t/general....1..17 ok 1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 ok
t/long.......Unable to create test table (ORA-01950: no privileges on tablespace 'USERS' (DBD ERROR: OCIStmtExecute))
Tests skiped.
1..0
skipped
all skipped: no reason given
t/ph_type....1..53
DBD::Oracle::db do failed: ORA-01950: no privileges on tablespace 'USERS' (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 51.
# failed test 1 at line 51
not ok 1
#
# testing VARCHAR2 (ora_type 1) ...
#
ok 2
ok 3
ok 4
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 78.
# failed test 5 at line 78
not ok 5
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 79.
# failed test 6 at line 79
not ok 6
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 80.
# failed test 7 at line 80
not ok 7
DBD::Oracle::db selectall_hashref failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute/Describe) at t/ph_type.t line 82.
# failed test 8 at line 82
not ok 8
# failed test 9 at line 86
not ok 9
# failed test 10 at line 87
not ok 10
# failed test 11 at line 88
not ok 11
ok 12
Use of uninitialized value at t/ph_type.t line 102.
# failed test 13 at line 107
not ok 13
expected 'trailing' but got undef for VARCHAR2
Use of uninitialized value at t/ph_type.t line 112.
# failed test 14 at line 112
not ok 14
expected 'embedded.nul' but got undef for VARCHAR2
#
# testing STRING (ora_type 5) ...
#
# skipping tests
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
#
# testing CHAR (ora_type 96) ...
#
ok 27
ok 28
ok 29
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 78.
# failed test 30 at line 78
not ok 30
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 79.
# failed test 31 at line 79
not ok 31
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 80.
# failed test 32 at line 80
not ok 32
DBD::Oracle::db selectall_hashref failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute/Describe) at t/ph_type.t line 82.
# failed test 33 at line 82
not ok 33
# failed test 34 at line 86
not ok 34
# failed test 35 at line 87
not ok 35
# failed test 36 at line 88
not ok 36
ok 37
Use of uninitialized value at t/ph_type.t line 102.
# failed test 38 at line 107
not ok 38
expected 'trailing ' but got undef for CHAR
Use of uninitialized value at t/ph_type.t line 112.
# failed test 39 at line 112
not ok 39
expected 'embedded.nul' but got undef for CHAR
#
# testing CHARZ (ora_type 97) ...
#
# skipping tests
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
DBD::Oracle::db do failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 118.
# failed test 52 at line 118
not ok 52
ok 53
FAILED tests 1, 5-11, 13-14, 30-36, 38-39, 52
Failed 20/53 tests, 62.26% okay
t/plsql......1..63 ok 1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 ok 18 ok 19 ok 20 ok 21 ok 22 ok 23 ok 24 ok 25 ok 26 ok 27 ok 28 ok 29 ok 30 ok 31 ok 32 ok 33 ok 34 ok 35 ok 36 ok 37 ok 38 ok 39 ok 40 ok 41 ok 42 ok 43 ok 44 ok 45 ok 46 ok 47 ok 48 ok 49 ok 50 ok 51 ok 52 ok 53 ok 54 ok 55 ok 56 ok 57 ok 58 ok 59 ok 60 ok 61 ok 62 ok 63 ok
t/reauth.....ORACLE_USERID_2 not defined.
Tests skiped.
1..0
skipped
all skipped: no reason givenFailed Test Stat Wstat Total Fail Failed List of Failed ----------------------------------------------------------------------- t/ph_type.t 53 20 37.74% 1 5-11 13-14 30-36 38-39 52 2 tests skipped. Failed 1/6 test scripts, 83.33% okay. 20/138 subtests failed, 85.51% okay. *** Error code 11 make: Fatal error: Command failed for target `test_dynamic'
# script done on Wed Sep 17 10:08:41 2003
Here is the list of files tar'ed up on the test system and moved to the production system.
# tar xvf dbi-dbd.tar
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBI/Driver_xst.h, 3034 bytes, 6 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBI/DBIXS.h, 17685 bytes, 35 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBI/dbd_xsh.h, 2050 bytes, 5 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBI/dbi_sql.h, 3475 bytes, 7 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBI/Driver.xst, 14408 bytes, 29 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBI/dbipport.h, 14789 bytes, 29 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBI/DBI.so, 157164 bytes, 307 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBI/DBI.bs, 0 bytes, 0 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI/Changes.pm, 49999 bytes, 98 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI/Profile.pm, 19437 bytes, 38 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI/W32ODBC.pm, 4594 bytes, 9 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI/FAQ.pm, 36024 bytes, 71 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI/Shell.pm, 29171 bytes, 57 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI/ProxyServer.pm, 17296 bytes, 34 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI/Const/GetInfo/ANSI.pm, 9173 bytes, 18 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI/Const/GetInfo/ODBC.pm, 65721 bytes, 129 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI/Const/GetInfoReturn.pm, 2130 bytes, 5 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI/Const/GetInfoType.pm, 852 bytes, 2 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI/Format.pm, 14439 bytes, 29 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI/DBD.pm, 62818 bytes, 123 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI/PurePerl.pm, 24369 bytes, 48 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBD/ExampleP.pm, 10384 bytes, 21 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBD/Proxy.pm, 21718 bytes, 43 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBD/NullP.pm, 2933 bytes, 6 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBD/Sponge.pm, 5350 bytes, 11 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/Bundle/DBI.pm, 1205 bytes, 3 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBI.pm, 205155 bytes, 401 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/Win32/DBIODBC.pm, 4532 bytes, 9 tape blocks
x /usr/perl5/5.00503/man/man1/dbish.1, 4607 bytes, 9 tape blocks
x /usr/perl5/5.00503/man/man1/dbiproxy.1, 9947 bytes, 20 tape blocks
x /usr/perl5/5.00503/man/man3/DBI::Profile.3, 21493 bytes, 42 tape blocks
x /usr/perl5/5.00503/man/man3/DBI::W32ODBC.3, 5069 bytes, 10 tape blocks
x /usr/perl5/5.00503/man/man3/DBI::Shell.3, 10463 bytes, 21 tape blocks
x /usr/perl5/5.00503/man/man3/DBI::FAQ.3, 45083 bytes, 89 tape blocks
x /usr/perl5/5.00503/man/man3/DBI::ProxyServer.3, 14259 bytes, 28 tape blocks
x /usr/perl5/5.00503/man/man3/Bundle::DBI.3, 5449 bytes, 11 tape blocks
x /usr/perl5/5.00503/man/man3/DBI::Const::GetInfo::ANSI.3, 5373 bytes, 11 tape blocks
x /usr/perl5/5.00503/man/man3/DBD::Proxy.3, 13313 bytes, 27 tape blocks
x /usr/perl5/5.00503/man/man3/DBI::Const::GetInfoReturn.3, 4575 bytes, 9 tape blocks
x /usr/perl5/5.00503/man/man3/DBI::Const::GetInfoType.3, 4773 bytes, 10 tape blocks
x /usr/perl5/5.00503/man/man3/DBI::Const::GetInfo::ODBC.3, 5229 bytes, 11 tape blocks
x /usr/perl5/5.00503/man/man3/DBI::Format.3, 8005 bytes, 16 tape blocks
x /usr/perl5/5.00503/man/man3/DBI::DBD.3, 70447 bytes, 138 tape blocks
x /usr/perl5/5.00503/man/man3/Win32::DBIODBC.3, 4957 bytes, 10 tape blocks
x /usr/perl5/5.00503/man/man3/DBI.3, 190367 bytes, 372 tape blocks
x /usr/perl5/5.00503/man/man3/DBI::PurePerl.3, 9865 bytes, 20 tape blocks
x /usr/perl5/5.00503/bin/dbiproxy, 5389 bytes, 11 tape blocks
x /usr/perl5/5.00503/bin/dbish, 494 bytes, 1 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/ocitrace.h, 11204 bytes, 22 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/mk.pm, 14434 bytes, 29 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/Oracle.h, 2402 bytes, 5 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/dbdimp.h, 9868 bytes, 20 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/Oracle.so, 179180 bytes, 350 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/Oracle.bs, 0 bytes, 0 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/DBD/Oracle.pm, 42814 bytes, 84 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/Oraperl.pm, 27606 bytes, 54 tape blocks
x /usr/perl5/site_perl/5.005/sun4-solaris/oraperl.ph, 1292 bytes, 3 tape blocks
x /usr/perl5/5.00503/man/man1/ora_explain.1, 13989 bytes, 28 tape blocks
x /usr/perl5/5.00503/man/man3/DBD::Oraperl.3, 28243 bytes, 56 tape blocks
x /usr/perl5/5.00503/man/man3/DBD::Oracle.3, 34932 bytes, 69 tape blocks
x /usr/perl5/5.00503/bin/ora_explain, 62012 bytes, 122 tape blocks
Thanks before hand for any and all help;
Greg
