Terry Maragakis wrote: > I just installed DBI and Oracle DBD. Did you also *just* install the Oracle client? Are you able to run sqlplus without problems?
Try this with your own user ID: sqlplus scott/[EMAIL PROTECTED] > 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/sun4-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. My guess is that the Oracle installer set the permissions on the Oracle client needlessly strict. With your own user ID, try to cd into /software/app/oracle/product/10.1.0/db_1/lib32, one directory at a time until you are stopped by permissions, e.g.: [EMAIL PROTECTED]:~> cd /software [EMAIL PROTECTED]:/software> cd app [EMAIL PROTECTED]:/software/app> cd oracle [EMAIL PROTECTED]:/software/app/oracle> cd product [EMAIL PROTECTED]:/software/app/oracle/product> cd 10.1.0 [EMAIL PROTECTED]:/software/app/oracle/product/10.1.0> cd db_1 -bash: cd: db_1: Permission denied If you don't run into problems there, check the permissions on libclntsh.so.10.1 itself. Maybe it's missing the o+r bit. Regards, Philip