Trying to set up DBI for oracle

I am trying to set up DBI Oracle stuff on a couple of boxes. One is
Ubuntu Feiesty and the other is running SunOS 5.8.

I have been using the following test script.

#!/usr/bin/perl
use DBI;
$dbh = DBI->connect( "dbi:Oracle:gen3", "user", "pass" );


Linux
-------
I get:
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC
(@INC contains: /etc/perl /usr/local/lib/perl/5.8.8
/usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5
/usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at
(eval 3) line 3.
Perhaps the DBD::Oracle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge.
at ./db.pl line 5

SunOS
----------
I get:
install_driver(Oracle) failed: Can't load
'/opt/local/perl/5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto /DBD/Oracle/Oracle.so'
for module DBD::Oracle: ld.so.1: db.pl: fatal: libclntsh.so.8.0: open
failed: No such file or directory at
/opt/local/perl/5.6.1/lib/5.6.1/sun4-solaris/DynaLoader.pm line 206.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at ./db.pl line 5

Which I guess are both similar errors. Anyone know what the modules I
need and how to add them. I am a perl newbee.

Regards,
Ben
--
Ben Edwards - Bristol, UK
If you have a problem emailing me use
http://www.gurtlush.org.uk/profiles.php?uid=4
(email address this email is sent from may be defunct)

RE: Trying to set up DBI for oracle

Ben,

Do you have at least the Oracle client installed on these boxes? If
not, you need to install Oracle; if so, use CPAN to load the modules:

$ cpan
CPAN> install DBI
CPAN> install DBD::Oracle=20

--
Ron Reidy
Lead DBA=20
Array BioPharma, Inc.

-----Original Message-----
From: Ben Edwards [mailto:funkytwig@gmail.com]=20
Sent: Tuesday, May 01, 2007 9:30 AM
To: dbi-users@perl.org
Subject: Trying to set up DBI for oracle

I am trying to set up DBI Oracle stuff on a couple of boxes. One is
Ubuntu Feiesty and the other is running SunOS 5.8.

I have been using the following test script.

#!/usr/bin/perl
use DBI;
$dbh =3D DBI->connect( "dbi:Oracle:gen3", "user", "pass" );


Linux
-------
I get:
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC
contains: /etc/perl /usr/local/lib/perl/5.8.8
/usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5
/usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at
(eval 3) line 3.
Perhaps the DBD::Oracle perl module hasn't been fully installed, or
perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge.
at ./db.pl line 5

SunOS
----------
I get:
install_driver(Oracle) failed: Can't load
'/opt/local/perl/5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto /DBD/Oracle/
Oracle.so'
for module DBD::Oracle: ld.so.1: db.pl: fatal: libclntsh.so.8.0: open
failed: No such file or directory at
/opt/local/perl/5.6.1/lib/5.6.1/sun4-solaris/DynaLoader.pm line 206.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at ./db.pl line 5

Which I guess are both similar errors. Anyone know what the modules I
need and how to add them. I am a perl newbee.

Regards,
Ben
--
Ben Edwards - Bristol, UK
If you have a problem emailing me use
http://www.gurtlush.org.uk/profiles.php?uid=3D4
(email address this email is sent from may be defunct)

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.