Problem

Hi,

I have the following error message when I try to connect to Oracle 10g DB
from perl in Linux. Could you please help me.

Best Regards
Fuat Anat

install_driver(Oracle) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto /DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.10.1: Kann die Shared-Object-Datei
nicht öffnen: Datei oder Verzeichnis nicht gefunden at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
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 ./conn.pl line 18


My program is like following



#!/usr/bin/perl -w
# the -w turns on various warnings
use strict; # always code strictly or you'll be sorry!
use DBI;

# create a database handle. the syntax for this is very flexible.
# the quoted string second argument is of the form USERNAME/PASSWORD.
# if the username is "scott" and the password is "tiger", then
# the second parameter would be "scott/tiger".
# if you want to connect using OS authentication as the current
# unix id then you can omit the username and the password but
# leave the slash, so the parameter would then be "/" (as shown).

my $data_source = 'dbi:Oracle:myDB';
my $username = 'user';
my $password = 'pwd';

my $dbh = DBI->connect($data_source, $username, $password)
or die "Database connection not made: $DBI::errstr";





__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs

RE: Problem

Is (at least) an Oracle client installed on the computer you are running =
this Perl program from?

If so, did you properly install DBD::Oracle. Did you read the README* =
files that are part of the distro?

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: Fuat Anat [mailto:fuat_anat@yahoo.com]=20
Sent: Wednesday, November 09, 2005 2:03 PM
To: dbi-users@perl.org
Subject: Problem


Hi,

I have the following error message when I try to connect to Oracle 10g =
DB from perl in Linux. Could you please help me.

Best Regards
Fuat Anat

install_driver(Oracle) failed: Can't load =
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto /DBD/Oracle/O=
racle.so'
for module DBD::Oracle: libclntsh.so.10.1: Kann die Shared-Object-Datei =
nicht öffnen: Datei oder Verzeichnis nicht gefunden at =
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230. 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 ./conn.pl line 18


My program is like following



#!/usr/bin/perl -w=20
# the -w turns on various warnings
use strict; # always code strictly or you'll be sorry!
use DBI;

# create a database handle. the syntax for this is very flexible. # the =
quoted string second argument is of the form USERNAME/PASSWORD. # if the =
username is "scott" and the password is "tiger", then # the second =
parameter would be "scott/tiger". # if you want to connect using OS =
authentication as the current # unix id then you can omit the username =
and the password but # leave the slash, so the parameter would then be =
"/" (as shown).

my $data_source =3D 'dbi:Oracle:myDB';
my $username =3D 'user';
my $password =3D 'pwd';

my $dbh =3D DBI->connect($data_source, $username, $password)=20
or die "Database connection not made: $DBI::errstr";




=09
__________________________________=20
Start your day with Yahoo! - Make it your home page!=20
http://www.yahoo.com/r/hs

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.