Hi DBI-USERS, Tim, Ilya, ...
I'm trying install DBD::Oracle on Solaris machine and tried all options as mentioned
in the README.xxx files. Still having same problem when running make test.
SQLPLUS works good on this machine. Any suggestions appreciated.
Thanks
Find an log for 'make' and 'make test' follows...
Sun OS 5.7
Perl 5.005_03 (provided by Interwoven Teamsite)
Oracle 8.0.3
DBI-1.15
DBD-Oracle-1.06
# make
mkdir blib
mkdir blib/lib
mkdir blib/lib/DBD
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/DBD
mkdir blib/arch/auto/DBD/Oracle
mkdir blib/lib/auto
mkdir blib/lib/auto/DBD
mkdir blib/lib/auto/DBD/Oracle
mkdir blib/man1
mkdir blib/man3
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
/home/iw-home/iw-perl/bin/perl -p -e "s/~DRIVER~/Oracle/g" <
/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI/Driver.xst >
Oracle.xsi
/home/iw-home/iw-perl/bin/perl -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris
-I/home/iw-home/iw-perl/lib/perl5/5.00503
/home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/xsubpp -typemap
/home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/typemap Oracle.xs >xstmp.c && mv
xstmp.c Oracle.c
gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public
-I/home/oracle/rdbms/demo -I/home/oracle/plsql/public -I/home/oracle/network/public
-I/home/oracle/rdbms/demo -I/home/oracle/rdbms/demo
-I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
-I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fPIC
-I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE -Wall -Wno-comment Oracle.c
/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:41: warning:
`local_patches' defined but not used
gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public
-I/home/oracle/rdbms/demo -I/home/oracle/plsql/public -I/home/oracle/network/public
-I/home/oracle/rdbms/demo -I/home/oracle/rdbms/demo
-I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
-I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fPIC
-I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE -Wall -Wno-comment dbdimp.c
dbdimp.c: In function `ora_db_login6':
dbdimp.c:250: warning: unsigned int format, long unsigned int arg (arg 5)
dbdimp.c: In function `ora_st_destroy':
dbdimp.c:1624: warning: unused variable `imp_dbh'
dbdimp.c: At top level:
/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:41: warning:
`local_patches' defined but not used
gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public
-I/home/oracle/rdbms/demo -I/home/oracle/plsql/public -I/home/oracle/network/public
-I/home/oracle/rdbms/demo -I/home/oracle/rdbms/demo
-I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
-I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fPIC
-I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE -Wall -Wno-comment oci7.c
/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:41: warning:
`local_patches' defined but not used
gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public
-I/home/oracle/rdbms/demo -I/home/oracle/plsql/public -I/home/oracle/network/public
-I/home/oracle/rdbms/demo -I/home/oracle/rdbms/demo
-I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
-I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fPIC
-I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE -Wall -Wno-comment oci8.c
oci8.c: In function `dbd_rebind_ph_rset':
oci8.c:414: warning: implicit declaration of function `pp_rebind_ph_rset_in'
oci8.c: In function `dbd_rebind_ph_lob':
oci8.c:435: warning: unsigned int format, ub4 arg (arg 5)
oci8.c: In function `init_lob_refetch':
oci8.c:1214: warning: value computed is not used
oci8.c: At top level:
/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:41: warning:
`local_patches' defined but not used
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
LD_RUN_PATH="/home/oracle/lib" gcc -o blib/arch/auto/DBD/Oracle/Oracle.so
-R/home/oracle/lib -G -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o
-L/home/oracle/lib/ -lagent -lextp -licx -lndw1 -lnlsrtl3 -lplsf -lserver -lsqlplus
-lepc -lnetv2 -lnttcp -lpsa -lslax -lepcpt -licd -lncr -lnetwork -lplsb -lpsd -lsql
-lclntsh -lcore4 -lclient -lcommon -lgeneric -lmm -lc -laio -lm -lc
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
/home/iw-home/iw-perl/bin/perl -Iblib/arch -Iblib/lib
-I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris
-I/home/iw-home/iw-perl/lib/perl5/5.00503 ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
mkdir blib/script
cp ora_explain blib/script/ora_explain
/home/iw-home/iw-perl/bin/perl -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris
-I/home/iw-home/iw-perl/lib/perl5/5.00503 -MExtUtils::MakeMaker -e "MY->fixin(shift)"
blib/script/ora_explain
Manifying blib/man3/DBD::Oraperl.3
Manifying blib/man3/DBD::Oracle.3
Manifying blib/man1/ora_explain.1
# make test
PERL_DL_NONLAZY=1 /home/iw-home/iw-perl/bin/perl -Iblib/arch -Iblib/lib
-I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris
-I/home/iw-home/iw-perl/lib/perl5/5.00503 -e 'use Test::Harness qw(&runtests
$verbose); $verbose=0; runtests @ARGV;' t/*.t
t/base..............FAILED tests 4-5
Failed 2/5 tests, 60.00% okay
t/general...........install_driver(Oracle) failed: Can't load
'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1:
/home/iw-home/iw-perl/bin/perl: fatal: relocation error: file
blib/arch/auto/DBD/Oracle/Oracle.so: symbol lsfmai: referenced symbol not found at
/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm line 169.
at (eval 1) line 3
Perhaps a required shared library or dll isn't installed where expected
at t/general.t line 20
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/long..............Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module
DBD::Oracle: ld.so.1: /home/iw-home/iw-perl/bin/perl: fatal: relocation error: file
blib/arch/auto/DBD/Oracle/Oracle.so: symbol lsfmai: referenced symbol not found at
/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm line 169.
at t/long.t line 4
BEGIN failed--compilation aborted at t/long.t line 4.
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/plsql.............Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module
DBD::Oracle: ld.so.1: /home/iw-home/iw-perl/bin/perl: fatal: relocation error: file
blib/arch/auto/DBD/Oracle/Oracle.so: symbol lsfmai: referenced symbol not found at
/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm line 169.
at t/plsql.t line 17
BEGIN failed--compilation aborted at t/plsql.t line 17.
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/reauth............skipping test on this platform
Failed Test Status Wstat Total Fail Failed List of failed
-------------------------------------------------------------------------------
t/base.t 5 2 40.00% 4-5
t/general.t 255 65280 ?? ?? % ??
t/long.t 255 65280 ?? ?? % ??
t/plsql.t 255 65280 ?? ?? % ??
1 test skipped.
Failed 4/5 test scripts, 20.00% okay. 2/5 subtests failed, 60.00% okay.
*** Error code 29
make: Fatal error: Command failed for target `test_dynamic'
# make test TEST_VERBOSE=1
PERL_DL_NONLAZY=1 /home/iw-home/iw-perl/bin/perl -Iblib/arch -Iblib/lib
-I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris
-I/home/iw-home/iw-perl/lib/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
FAILED tests 4-5
Failed 2/5 tests, 60.00% okay
t/general...........install_driver(Oracle) failed: Can't load
'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1:
/home/iw-home/iw-perl/bin/perl: fatal: relocation error: file
blib/arch/auto/DBD/Oracle/Oracle.so: symbol lsfmai: referenced symbol not found at
/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm line 169.
at (eval 1) line 3
Perhaps a required shared library or dll isn't installed where expected
at t/general.t line 20
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/long..............Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module
DBD::Oracle: ld.so.1: /home/iw-home/iw-perl/bin/perl: fatal: relocation error: file
blib/arch/auto/DBD/Oracle/Oracle.so: symbol lsfmai: referenced symbol not found at
/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm line 169.
at t/long.t line 4
BEGIN failed--compilation aborted at t/long.t line 4.
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/plsql.............Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module
DBD::Oracle: ld.so.1: /home/iw-home/iw-perl/bin/perl: fatal: relocation error: file
blib/arch/auto/DBD/Oracle/Oracle.so: symbol lsfmai: referenced symbol not found at
/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm line 169.
at t/plsql.t line 17
BEGIN failed--compilation aborted at t/plsql.t line 17.
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/reauth............ORACLE_USERID_2 not defined.
Tests skiped.
1..0
skipping test on this platform
Failed Test Status Wstat Total Fail Failed List of failed
-------------------------------------------------------------------------------
t/base.t 5 2 40.00% 4-5
t/general.t 255 65280 ?? ?? % ??
t/long.t 255 65280 ?? ?? % ??
t/plsql.t 255 65280 ?? ?? % ??
1 test skipped.
Failed 4/5 test scripts, 20.00% okay. 2/5 subtests failed, 60.00% okay.
*** Error code 29
make: Fatal error: Command failed for target `test_dynamic'
My environment variables looks like follows....
# env
AVPAUDIT=/home/taxware/audit
AVPIN=/home/taxware/indata
AVPOUT=/home/taxware/outdata
AVPTEMP=/home/taxware/temp
DISPLAY=inetfwgui5.na.pg.com:0.0
DYNAMO_HOME=/usr/atg/presiva/Dynamo4.5.0:.
ERRMSGPATH=/home/taxware/lang/eng
HOME=/home/tr5271
HZ=100
LD_LIBRARY_PATH=/home/oracle/lib:/usr/lib:/usr/ucblib
LD_RUN_PATH=/home/oracle/lib
LOGNAME=tr5271
MAIL=/var/mail/tr5271
ORACLE_BASE=/home/oracle
ORACLE_HOME=/home/oracle
ORACLE_SID=dev
PATH=/home/iw-home/iw-perl/bin:/opt/NSCPcom:/home/oracle:/usr/openwin:/usr/bin:/usr/ucb:/etc:.:/home/oracle/bin:/usr/sbin:/usr/lib:/usr/xpgr/bin:/usr/xpg4/bin
PS1=#
SHELL=/bin/sh
STEPIN=/home/taxware/indata
STEPOUT=/home/taxware/outdata
TAXHOME=/home
TERM=dtterm
TNS_ADMIN=/home/oracle/network/admin
TOOLKITEXE=/home/taxware/toolkit
TOOLKITOUT=/home/taxware/tkout
TXHOME=/home/taxware
TZ=US/Eastern
WTAUDIT=/home/taxware/audit
WTCOUNTRY=US
WTDB=/home/taxware/outdata
WTHOME=/home/taxware
WTIN=/home/taxware/indata
WTLANG=ENG
WTOUT=/home/taxware/outdata
WTSYSTEM=/home/taxware/indata
WTTEMP=/home/taxware/temp
XUSERFILESEARCHPATH=/home/taxware/lang/eng/%N
ZIPIN=/home/taxware/indata
ZIPOUT=/home/taxware/outdata
ZIPTEMP=/home/taxware/temp
_INIT_PREV_LEVEL=S
_INIT_RUN_LEVEL=3
_INIT_RUN_NPREV=0
_INIT_UTS_ISA=sparc
_INIT_UTS_MACHINE=sun4u
_INIT_UTS_NODENAME=go-ilaunch001
_INIT_UTS_PLATFORM=SUNW,Ultra-4
_INIT_UTS_RELEASE=5.7
_INIT_UTS_SYSNAME=SunOS
_INIT_UTS_VERSION=Generic_106541-11
#
