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:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 2:03 PM To: [email protected] 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/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 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.
