Hi,
On Tue, Jun 23, 2009 at 02:23:44PM +0200, teck wrote:
> Hi, i'm using Dejan Muhamedagic oracle script for HA.
>
> Reading the script i notice this:
>
> # An example usage in /etc/ha.d/haresources:
> # node1 10.0.0.170 oracle::RK1::/oracle/10.2::orark1
>
> But when i tried to run script from haresources on this way, oracle database
> doesn?t start.
Is there anything in the logs? Is there
/etc/ha.d/resource.d/oracle resource agent (script)? I don't have
it here.
> I also tried to verify the script by typing
> /usr/lib/ocf/resources.d/heartbeat/oracle start but this method fails too.
> In the mentioned script there's a step who consists in run sqlplus / as
> sysdba, wich cannot be run as root.
True, but the script should use su(1) to switch to the oracle
user.
> Running from command line (/usr/lib/ocf/resources.d/heartbeat/oracle start)
> with oracle user, the script works.
OK, so it seems like for some reason su doesn't work. From the RA
meta-data:
<parameter name="user" unique="0">
<longdesc lang="en">
The Oracle owner (aka ORACLE_OWNER).
If not specified, then it is set to the owner of
file \$ORACLE_HOME/dbs/*\${ORACLE_SID}.ora.
If this does not work for you, just set it explicitely.
</longdesc>
<shortdesc lang="en">user</shortdesc>
<content type="string" default="" />
</parameter>
Do you have that set? Do you have the .ora file with proper
permissions?
Thanks,
Dejan
> How can resolve this?
>
> Any help would be very appreciated.
>
> Regards,
>
> Damian.
> _______________________________________________
> Linux-HA mailing list
> [email protected]
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems