[Linux-HA] Working with heartbeat::ocf:oracle

[Andreas Mock]

> -----Ursprüngliche Nachricht-----
> Von: linux-ha-bounces at lists.linux-ha.org 
> [mailto:linux-ha-bounces at lists.linux-ha.org] Im Auftrag von 
> Dejan Muhamedagic
> Gesendet: Montag, 4. Februar 2008 13:04
> An: General Linux-HA mailing list
> Betreff: Re: [Linux-HA] Working with heartbeat::ocf:oracle
> 
> AFAIK, all Oracle programs are run as oracle user. That'd include
> sqlplus. Can you please post the output of the script when run as
> root.


Hi Dejan,

it's exactly as you said.
All startup scripts change the user ID to the "oracle"-user which
is almost always 'oracle'. The RA should/must respect this and
has to be run as 'oracle'. E.g. SuSE SLES does provide rc-scripts
for starting single instance Oracle databases and they always
do a 'su - oracle -c "whatever"'.

Oracle db processes do not drop their rights to the oracle user.
So don't use root as process owner. 
But if you want to do that: Set ORACLE_HOME and LD_LIBRARY_PATH.

Best regards
Andreas Mock