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 build the Perl modules on another Solaris 8 system where gcc is
installed and I attempted to move the modules to the production system.
MY QUESTION IS; Is this possible?
I've included the output of
1) perl -V
2) output of the DBD::Oracle-1.12 'make test' that had errors
3) output of the DBD::Oracle-1.12 'make install'
4) the files I tar'ed up and moved to the production system
5) the error the user is getting.
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 edit the DBD::Oracle 1.12 Makefile for change all
the references to the Oracle libraries from /lib to /lib32 to
get this far.
1) 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.
2) These are the errors during 'make test' for the
DBD::Oracle-1.12 module. Most of the errors are
either "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
# 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 given
Failed 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
3) It is the following three lines in the 'make install' output
for the DBD::Oracle module that I'm not sure what to do with;
Files found in blib/arch --> Installing files in blib/lib into
architecture dependend library tree!
Writing /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/.packlist
Appending installation info to
/usr/perl5/5.00503/sun4-solaris/perllocal.pod
Script started on Wed Sep 17 12:40:05 2003
# make install
Installing
/usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/ocitrace.h
Installing /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/mk.pm
Installing /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/Oracle.h
Installing /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/dbdimp.h
Installing /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/Oracle.so
Installing /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/Oracle.bs
Files found in blib/arch --> Installing files in blib/lib into architecture
dependend library tree!
Installing /usr/perl5/site_perl/5.005/sun4-solaris/DBD/Oracle.pm
Installing /usr/perl5/site_perl/5.005/sun4-solaris/Oraperl.pm
Installing /usr/perl5/site_perl/5.005/sun4-solaris/oraperl.ph
Installing /usr/perl5/5.00503/man/man1/ora_explain.1
Installing /usr/perl5/5.00503/man/man3/DBD::Oraperl.3
Installing /usr/perl5/5.00503/man/man3/DBD::Oracle.3
Installing /usr/perl5/5.00503/bin/ora_explain
Writing /usr/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/.packlist
Appending installation info to /usr/perl5/5.00503/sun4-solaris/perllocal.pod
script done on Wed Sep 17 12:41:09 2003
4) 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
5) Here is the error the user is getting;
perl> perl -c SampleOracleConnection.pl
Can't locate loadable object for module DBI in @INC (@INC contains:
/usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503
/usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .) at
/usr/perl5/site_perl/5.005/sun4-solaris/DBI.pm line 243
BEGIN failed--compilation aborted at
/usr/perl5/site_perl/5.005/sun4-solaris/DBI.pm line 243.
BEGIN failed--compilation aborted at SampleOracleConnection.pl line 8.
Thanks for any and all help;
Greg
