Hi,
I installed perl modules DBI-1.32 & DBD::Oracle 1.09. I had chosen these
versions b'coz they were already running perfectly on another machine with
same environment(Linux 7.2, Perl 5.6.0 Oracle-8.1.7). After installation i
ran my perl-script that connects to oracle db. It ran perfectly if user was
either root or oracle but it couldn't with others. The error it was showing
me is:
install_driver(Oracle) failed: Can't load
'/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/Oracle/Oracle.so' for
module DBD::Oracle: libclntsh.so.8.0: cannot open shared object file: No
such file or directory at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line
200.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at orc.pl line 9
What i did during installation is:
set ORACLE_HOME & ORACLE_SID variables
tar -zxvf DBI-1.32.tar.gz
cd DBI-1.32
perl Makefile.PL (ok)
make (ok)
make test (make: *** [test_dynamic] Error 11)
make install
cd ..
rm -Rf DBI-1.32
tar -zxvf DBD-Oracle-1.09.tar.gz
cd DBD-Oracle-1.09
perl Makefile (ok)
make (ok)
make test (make: *** [test_dynamic] Error 255)
make install
The output of DBI:make test:
PERL_DL_NONLAZY=1
/usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux -I/us
r/lib/perl5/5.6.0 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0;
runtests @ARGV;' t/*.t
t/01basics.............ok
t/02dbidrv.............ok
t/03hleak..............ok
t/04mods...............ok
t/05thrclone...........skipped
all skipped: perl 5.006 not configured to support iThreads
t/06attrs..............ok
t/07kids...............ok
t/10examp..............ok 103/245Insecure dependency in parameter 1 of
DBI::st=HASH(0x8286230)->FETCH method call while running with -T switch at
t/10examp.t line 320.
DBI handle cleared whilst still active.
dbih_clearcom (sth 0x8287298 0x819eb00, com 0x8289950, imp
DBD::ExampleP::st):
FLAGS 0x60011: COMSET Warn TaintIn TaintOut
PARENT DBI::db=HASH(0x8277e20)
KIDS 0 (0 Active)
IMP_DATA ARRAY(0x82874d8)
NUM_OF_FIELDS 3
NUM_OF_PARAMS 1
t/10examp..............dubious
Test returned status 20 (wstat 5120, 0x1400)
DIED. FAILED tests 104-245
Failed 142/245 tests, 42.04% okay
t/15array..............ok
t/20meta...............ok
t/30subclass...........ok
t/40profile............Can't locate Time/HiRes.pm in @INC (@INC contains:
blib/arch blib/lib /usr/lib/perl5/5.6.0/i386-linux
/usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0/i386-linux
/usr/lib/perl5/5.6.0 /usr/lib/perl5/5.6.0/i386-linux
/usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0
/usr/lib/perl5/site_perl/5.6.0/i386-linux
/usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl . /usr/lib/perl5/5.6.0/i386-linux
/usr/lib/perl5/5.6.0 /usr/lib/perl5/site_perl/5.6.0/i386-linux
/usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .) at t/40profile.t
line 183.
BEGIN failed--compilation aborted at t/40profile.t line 183.
t/40profile............dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-56
Failed 56/56 tests, 0.00% okay
t/41prof_dump..........ok
t/42prof_data..........ok
t/60preparse...........ok
t/70shell..............ok
t/80proxy..............skipped
all skipped: modules required for proxy are probably not installed
t/zz_01basics_pp....... Using DBI::PurePerl (DBI_PUREPERL=2)
t/zz_01basics_pp.......ok
t/zz_02dbidrv_pp.......ok
t/zz_03hleak_pp........ok
t/zz_04mods_pp.........ok
t/zz_05thrclone_pp.....skipped
all skipped: perl 5.006 not configured to support iThreads
t/zz_06attrs_pp........ok
t/zz_07kids_pp.........skipped
all skipped: $h->{Kids} attribute not supported for DBI::PurePerl
t/zz_10examp_pp........ok 52/245 Taint mode switching tests skipped
t/zz_10examp_pp........ok 74/245 Taint attribute tests skipped
t/zz_10examp_pp........ok
t/zz_15array_pp........ok
t/zz_20meta_pp.........ok
t/zz_30subclass_pp.....ok
t/zz_40profile_pp......skipped
all skipped: profiling not supported for DBI::PurePerl
t/zz_41prof_dump_pp....skipped
all skipped: profiling not supported for DBI::PurePerl
t/zz_42prof_data_pp....skipped
all skipped: profiling not supported for DBI::PurePerl
t/zz_60preparse_pp.....skipped
all skipped: preparse not supported for DBI::PurePerl
t/zz_70shell_pp........ok
t/zz_80proxy_pp........skipped
all skipped: modules required for proxy are probably not installed
Failed Test Stat Wstat Total Fail Failed List of Failed
----------------------------------------------------------------------------
---
t/10examp.t 20 5120 245 284 115.92% 104-245
t/40profile.t 2 512 56 112 200.00% 1-56
9 tests skipped.
Failed 2/34 test scripts, 94.12% okay. 198/1108 subtests failed, 82.13%
okay.
make: *** [test_dynamic] Error 11
output of DBD:make test:
PERL_DL_NONLAZY=1
/usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux -I/us
r/lib/perl5/5.6.0 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0;
runtests @ARGV;' t/*.t
t/base.......ok
t/general....DBI connect('','scott/tiger',...) failed: ORA-12546:
TNS:permission denied (DBD ERROR: OCIServerAttach) at t/general.t line 20
Unable to connect to Oracle (ORA-12546: TNS:permission denied (DBD ERROR:
OCIServerAttach))
Tests skiped.
skipped
all skipped: no reason given
t/long.......Unable to connect to Oracle (ORA-12546: TNS:permission denied
(DBD ERROR: OCIServerAttach))
Tests skiped.
skipped
all skipped: no reason given
t/ph_type....DBI connect('','scott/tiger',...) failed: ORA-12546:
TNS:permission denied (DBD ERROR: OCIServerAttach) at t/ph_type.t line 24
Unable to connect to Oracle (ORA-12546: TNS:permission denied (DBD ERROR:
OCIServerAttach))
Tests skipped.
skipped
all skipped: no reason given
t/plsql......Unable to connect to Oracle (ORA-12546: TNS:permission denied
(DBD ERROR: OCIServerAttach))
Tests skiped.
skipped
all skipped: no reason given
t/reauth.....skipped
all skipped: no reason given
All tests successful, 5 tests skipped.
Files=6, Tests=5, 0 wallclock secs ( 0.40 cusr + 0.02 csys = 0.42 CPU)
PERL_DL_NONLAZY=1
/usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux -I/us
r/lib/perl5/5.6.0 test.pl
Oraperl test application $Revision: 1.4
Oraperl emulation interface version 1.41
DBD::Oracle 1.09 using OCI8 by Tim Bunce
DBI 1.32 by Tim Bunce
Data sources:
dbi:Oracle:EXTPROC_CONNECTION_DATA
Connecting
to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended)
as 'scott/tiger' (via ORACLE_USERID env var or default - recommend
name/[EMAIL PROTECTED])
(ORACLE_SID='ora8ilnx', TWO_TASK='')
ora_login: 12546: ORA-12546: TNS:permission denied (DBD ERROR:
OCIServerAttach)
Generally set TWO_TASK or ORACLE_SID but not both at the same time.
Try to connect to the database using an oracle tool like sqlplus
only if that works should you suspect problems with DBD::Oracle.
Try leaving dbname value empty and set dbuser to name/[EMAIL PROTECTED]
Test aborted.
make: *** [test_dynamic] Error 255
I also changed permission of /usr/oracle/product/8.1.7/ directory
chmod 755 -R /usr/oracle/product/8.1.7
Then i reinstalled modules but could not make out.Kindly help me.
Thanks in advance.
Mital.
