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
Sent: Wednesday, November 09, 2005 2:03 PM
To: dbi-users@perl.org
Subject: Problem


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!

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
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.

Search Discussions

Discussion Posts


Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 6 of 6 | next ›
Discussion Overview
groupdbi-users @
postedNov 9, '05 at 8:40p
activeNov 10, '05 at 4:12p



site design / logo © 2022 Grokbase