DBD::Oracle

[Phil Meyer]

Dave Mitchell wrote:
> On Wed, Nov 08, 2006 at 03:35:30PM -0500, Robert Fausey wrote:
>   
>> I am trying to install DBD::Oracle perl module on FC4.  I can connect to
>> Oracle via sqlplus, and I have ORACLE_HOME, ORACLE_SID, ORACLE_USERID
>> environment variables defined.  When I compile the module I keep getting
>> the following error
>>
>> Permission denied
>> at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.
>>     
>
> Most likely either the oracle library or the DBD driver .so file has got
> bad permissions set on it.
>
> Try whatever command gives you the above, prefixed with
>
> strace -o /tmp/tr.dbd -f 
>
> then look in the file /tmp/tr.dbd for lines containing things like EACCESS
>
>   

Agreed.  Running as a normal user, a perl script with Oracle DBI 
connections will fail if:

$ORACLE is not set

The net libraries and tnsnames.ora are not readable by the user.