Search for Oracle.pm file then print out @INC and see if the @INC contains
that directory.
Also, though this is not a problem at this time, but
my($db_type, $db_name, $hostname, $port, $dbh, $sth,$user,$passwd);
$db_type = 'Oracle';
$db_name = 'rdw';
chop($hostname = 'gcclo19');
##What does chop do for you, are you trying to chop of the 9 at the end??
$port = 1521;
$user=bbxadmin;
##what is bbxadmin did you mean $bbxadmin unless bbxadmin or "bbxadmin" is a
const this would cause an error.
$passwd=bbxadm0;
###Same as above with this. If its a string you must enclose in ""
$dbh = DBI->connect("dbi:$db_type:$db_name:$hostname:$port", $user,
$passwd);
###Your connect string is wrong, see perldoc DBD::Oracle for the correct way
to connect.
Ilya
print "connection ok";
ERROR:
-----Original Message-----
From: Wesley STROOP
To: Sterin, Ilya
Cc: dbi
Sent: 06/15/2001 8:39 AM
Subject: Re: install_driver(Oracle) failed:
Hi,
Do you know what I do wrong?
The installation details you can found below.
I will appriciate every information.
Thanks.
Environment:
OS : HP-UX 11
Oracle : 8.1.6.1
Perl : 5.6
C-compiler: B3901BA B.11.01.06 HP C/ANSI C Developer's Bundle for
HP-UX 11.00 (S800)
INSTALLATION OF DBI 1.16 AND DBD:ORACLE 1.07 on HP-UX
************************************************************************
****
*config Perl
*
*adjust /opt/perl5/lib/5.6.0/PA-RISC1.1/Config.pm
*
* ccdlflags=''
* cccdlflags='+z'
*! ldflags= ' -L/usr/local/lib'
* ld='ld'
* libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
*! libs='-lnsl_s -lndbm -ldld -lm -lc -lndir -lcrypt -lsec -lcl
-lpthread'
* libc=/lib/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
*
***********
*extract DBI-1.16.tar.gz
*cd DBI-1.14/
*perl Makefile.PL
*make
*make test
*make install
*OK
*
************
*extract DBD-Oracle-1.06.tar.gz
*cd Oracle-1.06/
*
*export ORACLE_HOME = /u01/app/oracle/product/8.1.6
*export LD_LIBRARY_PATH = $ORACLE_HOME/lib
*export SHLIB_PATH = $ORACLE_HOME/lib:/usr/lib
*
*perl Makefile.PL LINKTYPE=static
*
*## remove the following parameters "-Wl,+s" and "-Wl,+n"
*
*cat Makefile | sed 's/-Wl,+s//' > Makefile.tmp
*cat Makefile.tmp | sed 's/-Wl,+n//' > Makefile
*
*cat Makefile | sed 's/\(OTHERLDFLAGS=.*$\)/\1 -lqsmashr/' >
Makefile.tmp
*mv Makefile.tmp Makefile
*
*make
*
*make perl
*make test
*make -f Makefile.aperl inst_perl MAP_TARGET=Perl
*make install
*
*******
*remark
******
*
*For the test env this is OK
*But for production we have to use shared libraries. (this means perl
Makefile.PL without the LINKTYPE=static)
*
************************************************************************
************
THE TEST
************************************************************************
************
ORACLE_BASE=/u1/app/oracle
ORACLE_HOME=/u1/app/oracle/product/8.1.6
ORACLE_PATH=/u1/app/oracle/product/8.1.6/bin
ORACLE_USERID=bbxadm/bbxadm0
ORACLE_SID=rdw
/usr/ccs/bin/make -f Makefile.aperl perl
`perl' is up to date.
PERL_DL_NONLAZY=1 ./perl -Iblib/arch -Iblib/lib
-I/opt/perl5/lib/5.6.0/PA-RISC1.1 -I/opt/perl5/lib/5.6.0 -e 'use
Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;'
t/*.t
t/base..............ok
t/general...........ok 13/16DBD::Oracle::db do failed:
ORA-00900: invalid SQL statement (DBD ERROR: OCIStmtExecute)
[for statement ``some invalid sql statement'']) at t/general.t line
66.
t/long..............ok
t/plsql.............ok
t/reauth............skipped test on this platform
All tests successful, 1 test skipped.
Files=5, Tests=224, 11 wallclock secs ( 2.67 cusr + 0.98 csys = 3.65
CPU)
PERL_DL_NONLAZY=1 ./perl -Iblib/arch -Iblib/lib
-I/opt/perl5/lib/5.6.0/PA-RISC1.1 -I/opt/perl5/lib/5.6.0 test.pl
Oraperl test application $Revision: 1.2 $
Oraperl emulation interface version 1.39
DBD::Oracle 1.06 using OCI8 by Tim Bunce
DBI 1.16 by Tim Bunce
Data sources:
dbi:Oracle:
dbi:Oracle:
dbi:Oracle:
dbi:Oracle:
dbi:Oracle:
dbi:Oracle:
dbi:Oracle:
dbi:Oracle:
Connecting
to '' (from command line, else uses ORACLE_SID or TWO_TASK -
recommended)
as 'bbxadm/bbxadm0' (via ORACLE_USERID env var or default - recommend
name/passwd@dbname)
(ORACLE_SID='rdw', TWO_TASK='')
Testing internal row fetch overhead.
50000 fetches: 2 wallclock secs ( 2.19 usr + 0.01 sys = 2.20 CPU)
25000 per clock second, 22727 per cpu second
Fields: 5
Names: 'NUM_T' 'DATE_T' 'CHAR_T' 'ROWID_T'
'NULL_T'
Lengths: 134 76 31 21 1
OraTypes: 2 12 1 104 1
SQLTypes: 3 9 12 -9104 12
Scale: 0 0 0 0 0
Precision: 38 75 30 20 0
Nullable: 1 1 1 1 1
Est row width: 45
Data rows:
fetch: '7.2', '15-JUN-01', 'BBXADM', 'AAAADDAABAAAAMAAAA', undef
csr reassigned (forces destruction)...
Fetch list of tables:
Fetched: X
Test ora_do with harmless non-select statement (set transaction read
only)
Expect an 'ORA-01453' error message:
ora_do: 1453: ORA-01453: SET TRANSACTION must be first statement of
transaction
(DBD ERROR:
OCIStmtExecute)
csr out of scope...
ora_logoff...
lda out of scope...
Testing repetitive connect/open/close/disconnect:
Expect sequence of digits, no other messages:
1 2 3 4 5
Test interaction of explicit close/logoff and implicit DESTROYs
Expect just 'done.', no other messages:
done.
Testing row cache (5).
Test completed in 1 seconds.
Test complete (9 seconds).
If the tests above have produced the 'expected' output then they have
passed.
************************************************************************
******
Test seems ok except one error at line 5
Now executing a program:
use DBI;
use strict;
my($db_type, $db_name, $hostname, $port, $dbh, $sth,$user,$passwd);
$db_type = 'Oracle';
$db_name = 'rdw';
chop($hostname = 'gcclo19');
$port = 1521;
$user=bbxadmin;
$passwd=bbxadm0;
$dbh = DBI->connect("dbi:$db_type:$db_name:$hostname:$port", $user,
$passwd);
print "connection ok";
ERROR:
install_driver(Oracle) failed: Can't locate loadable object for module
DBD::Oracle
\in @INC (@INC contains:
/opt/perl5/lib/5.6.0/PA-RISC1.1
/opt/perl5/lib/5.6.0
/opt/perl5/lib/site_perl/5.6.0/PA-RISC1.1
/opt/perl5/lib/site_perl/5.6.0
/opt/perl5/lib/site_perl .) at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a module that DBD::Oracle requires hasn't been fully installed
at database.pm line
13
"Sterin, Ilya" wrote:
>
> Try reinstalling. Did you get errors when installing? Do you have
another
> perl installation that this could of been installed with. Your @INC
does
> not contain the necassary info, you can try pushing the necessary dir
into
> it, but that should of been done when you installed perl, unless
DBD::Oracle
> was installed under a non standard directory.
>
> Ilya
>
> -----Original Message-----
> From: Wesley STROOP
> To: dbi
> Sent: 06/15/2001 5:37 AM
> Subject: install_driver(Oracle) failed:
>
> Hi guys,
>
> I have a problem with compling, he can not find a module.
> Is it because I installed the DBD::Oracle 1.06 wrong or something
> else?
> error message:
>
> install_driver(Oracle) failed:
> \Can't locate loadable object for module DBD::Oracle in @INC
> (@INC contains: /opt/perl5/lib/5.6.0/PA-RISC1.1
> /opt/perl5/lib/5.6.0
> /opt/perl5/lib/site_perl/5.6.0/PA-RISC1.1
> /opt/perl5/lib/site_perl/5.6.0 /opt/perl5/lib/site_perl .)
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a module that DBD::Oracle requires hasn't been fully installed
> at database.pm line 5
>
> Environment:
>
> OS : HP-UX 11
> Oracle : 8.1.6.1
> Perl : 5.6
> C-compiler: B3901BA B.11.01.06 HP C/ANSI C Developer's Bundle for
> HP-UX 11.00 (S800)
<<Card for Wesley STROOP>>
