DBD::Oracle

[Garry T. Williams]

On Wednesday 08 November 2006 15:35, 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.

Yeah, Oracle, for some inexplicable reason, sets the permissions on
the ORACLE_HOME directory and files to exclude other access (0750 for
directories and 0640 for files).  The fix is to switch to the Oracle
user and reset permissions:

    sudo su - oracle
    find $ORACLE_HOME -type d|xargs chmod o+rx
    find $ORACLE_HOME -type f|xargs chmod o+r

-- 
Garry T. Williams --- +1 678 656-4579