Thanks!
I don't where I have to put Oracle.so file
Please let me know to which directory I supposed to put from where??
Thanks again
>
> From: Jayanta Banerjee <[EMAIL PROTECTED]>
> Date: 2001/04/17 Tue AM 09:33:29 EDT
> To: 'Prasanna Gopalakrishna' <[EMAIL PROTECTED]>
> Subject: RE: Error in DBD::Oracle Installation
>
> Where is your Oracle.so file ? It is not finding that file in the proper
> location. Try to put it in the appropriate directory.
>
> Thanks
>
> Jayanta Banerjee
> Phone : 503-466-3151
> Email : [EMAIL PROTECTED]
> Fax : 503-533-7001
>
>
> -----Original Message-----
> From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 17, 2001 9:30 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Error in DBD::Oracle Installation
> Sensitivity: Confidential
>
>
> 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/b
> in:/usr/ucb:/etc:.:/home/oracle/bin:/usr/sbin:/usr/lib:/usr/xpgr/bin:/usr/xp
> g4/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
> #
>
>
>
>
>
>
>
>
>
>
>
>
>
