* How do I find the home directory of the "oracle" user
* Oracle client installed and I connecting remotely to database using sqlplus
* is there any db driver mismatch
any suggestions?
> From: Hardy Merrill <[EMAIL PROTECTED]>
> Date: 2001/04/18 Wed AM 10:03:22 EDT
> To: Prasanna Gopalakrishna <[EMAIL PROTECTED]>
> CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Re: Error in DBD::Oracle Installation
>
> I haven't been following this thread, but here are my thoughts:
>
> * your environment at the bottom has
> ORACLE_BASE=/home/oracle
> ORACLE_HOME=/home/oracle
>
> those environment variables usually contain values relative to
> where you *installed* oracle - *NOT* relative to the home directory
> of the "oracle" user(which is usually??? /home/oracle). They
> usually(?) start with /u01/app/oracle...
>
> On my machine, these look like this:
> ORACLE_BASE=/u01/app/oracle
> ORACLE_HOME=/u01/app/oracle/product/8.1.7
>
> * I saw a response on the topic of libclntsh.so.8.o a while ago,
> and here's what it said to do:
>
> in /etc/ld.so.conf, add a line for the Oracle library directory
> which for me is /u01/app/oracle/product/8.1.7/lib
>
> and then run "ldconfig". This worked for me when my installation
> had trouble finding libclntsh.so.8.o.
>
> * On the machine where you are installing DBD::Oracle, you DO need
> some form of Oracle product software - either the Oracle server
> install or an Oracle client install. Actually someone once on
> this list went to the trouble of pointing out exactly which files
> were needed from an Oracle install, to keep it as small as possible,
> but you'll have to find that message if that's what you want to
> do. If you have sqlplus installed and working, I think that
> indicates you do have Oracle installed - since you didn't say
> if sqlplus was connecting locally or to a remote db, I can't say
> for sure whether you have the Oracle Server or an Oracle client
> install. But if sqlplus works fine, then you should be able to
> get DBI with DBD::Oracle to work.
>
> HTH.
>
> --
> Hardy Merrill
> Mission Critical Linux, Inc.
> http://www.missioncriticallinux.com
>
>
> Prasanna Gopalakrishna [[EMAIL PROTECTED]] wrote:
> > 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
> > > > #
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
>
