RE: Oracle DBD runtime error
- From: Philip.Garrett@xxxxxxxxxxx (Philip Garrett)
- Date: Tue, 30 Jan 2007 09:46:52 -0500
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/tiger@DWHDEVR1
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.:
me@local:~> cd /software
me@local:/software> cd app
me@local:/software/app> cd oracle
me@local:/software/app/oracle> cd product
me@local:/software/app/oracle/product> cd 10.1.0
me@local:/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
.
- References:
- Oracle DBD runtime error
- From: Terry Maragakis
- Oracle DBD runtime error
- Prev by Date: Re: installing DBD-Informix on fedora 6
- Next by Date: Re: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
- Previous by thread: RE: Oracle DBD runtime error
- Next by thread: AW: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
- Index(es):
Relevant Pages
|
