Re: Oracle & PHP

On 02/27/2007 01:35:49 PM, Mladen Gogala wrote:

> I am not the sharpest knife in the drawer, but I've ran into this
> before. Oracle10R2 has strengthened
> protection of the home directory. After the patchset 1 (10.2.0.2) there
> is a script called changeperm.sh
> in $ORACLE_HOME/install that must be run to fix the problem.
> Essentially, it changes protection for $ORACLE_HOME, $ORACLE_HOME/lib,
> $ORACLE_HOME/network, $ORACLE_HOME/nls and $ORACLE_HOME/oracore to make
> the files world readable. One little "chmod -R 755" on those
> directories should do the trick.

Actually, do not change permissions recursively on $ORACLE_HOME, only on the other listed directories. The $ORACLE_HOME is created with 750 protection and without protection that allows others (Apache usually runs like "nobody" or "apache") processes owned users which are not member of the dba group cannot read it. It is, however, a bad idea to put those users into the dba group.

-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l