I just installed DBI and Oracle DBD.
I can run the following program without error as root:
#!/bin/perl -w
use DBI;
use DBD::Oracle;
my $dbh=DBI->connect("dbi:Oracle:DWHDEVR1","scott","tiger");
$dbh->disconnect();
But when I try to run it under my own user ID I get the following error:
Can't load
'/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle
.so' for module DBD::Oracle: ld.so.1: perl: fatal:
/software/app/oracle/product/
10.1.0/db_1/lib32/libclntsh.so.10.1: Permission denied at
/usr/perl5/5.8.4/lib/s
un4-solaris-64int/DynaLoader.pm line 230.
at ./test.pl line 4
Compilation failed in require at ./test.pl line 4.
BEGIN failed--compilation aborted at ./test.pl line 4.
It looks like a permissions problem but I cannot figure out where.
The Oracle version is 10.1 on Solaris 10.
Thanks,
Terry Maragakis
