Yes. I do have following links in $ORACLE_HOME/lib
any suggestion?
-rwxr-xr-x 1 oracle 800 6721160 Apr 20 2000 libclntsh.so
-rwxr-xr-x 1 oracle 800 6796000 Mar 29 09:24 libclntsh.so.1.0
-rwxr-xr-x 1 root other 6721160 Mar 29 09:21 libclntsh.so.1.0.tmp
-rw-r--r-- 1 oracle staff 9255260 Jun 22 2000 libclntsh.so.8.0
>
> From: Mohanjit Singh <[EMAIL PROTECTED]>
> Date: 2001/04/17 Tue PM 01:42:49 EDT
> To: Prasanna Gopalakrishna <[EMAIL PROTECTED]>
> Subject: RE: RE: Error in DBD::Oracle Installation
>
> Do u have following symbolic links under $ORACLE_HOME/lib
>
> lrwxrwxrwx 1 root monitor 16 Jul 12 2000 libclntsh.so ->
> libclntsh.so.8.0
> -rwxr-xr-x 1 root monitor 9828696 Jul 12 2000 libclntsh.so.8.0
>
>
>
> -----Original Message-----
> From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 17, 2001 1:32 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: RE: Error in DBD::Oracle Installation
> Sensitivity: Confidential
>
>
> Still running around with the same problem. I wonder this could be the
> problem! not sure...
>
> i) Do I need to set ORACLE_USER along with ORACLE_HOME, ORACLE_SID,
> LD_LIBRARY_PATH environment before install DBD::Oracle
> If yes who? admin or any db-user?
>
>
> ii) also, do need to install any other Oracle client libraries. (Sqlplus
> works though!)
>
>
>
>
> >
> > From: "Sterin, Ilya" <[EMAIL PROTECTED]>
> > Date: 2001/04/17 Tue AM 10:50:11 EDT
> > To: 'Prasanna Gopalakrishna ' <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '"
> > <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]>
> > Subject: RE: Error in DBD::Oracle Installation
> >
> > Make sure your LD_LIBRARY_PATH is set correctly for the username which is
> > installing DBD::Oracle
> >
> > Ilya Sterin
> >
> > -----Original Message-----
> > From: Prasanna Gopalakrishna
> > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Sterin, Ilya
> > Sent: 04/17/2001 10:29 AM
> > 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/Dr
> > iver.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:4
> > 1: 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:4
> > 1: 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:4
> > 1: 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:4
> > 1: 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:/u
> > sr/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
> > #
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
