---------- Forwarded message ----------
From: Meryem Belhadj <[email protected]>
Date: 2009/11/4
Subject: Re: [Linux-HA] Running multiple Oracle Database Instances on
active/active Linux-HA cluster
To: General Linux-HA mailing list <[email protected]>
Hello,
Thanks for the reply.
I had a look to the link you provided but it's not the same issue because in
our configuration we use resource groups ans don't use clones which is quite
different.
I attached our cib.xml file.
Best regards,
Meryem Belhadj.
System Engineer.
2009/11/3 Wojciech Gumularz <[email protected]>
2009/11/3 Meryem Belhadj <[email protected]>
>
> > Hello,
> >
> > We have a two nodes active/active heartbeat cluster. We configured two
> > resource groups containing all necessary volume group, file system, ip
> > address, database instance and listener resources. We run a resource
> group
> > on each node. Heartbeat package version is: heartbeat-2.1.3-0.9 installed
> > on
> > SLES 10 SP2 ppc.
> > The issue we are facing is when we try to run the two resource groups on
> > one
> > single node simulating a failover. In fact, when a node (node 1 for
> > example)
> > fails, the resource group that it owns is migrated to the second node
> (node
> > 2 for example) but we noticed that the database instance that is running
> on
> > this node (node 2) is retarted! Which means that we have both database
> > instances retarted.
> >
>
> Your problem seems to be related to this topic:
> http://lists.linux-ha.org/pipermail/linux-ha/2008-December/035684.html
>
> Regards,
> Wojciech Gumularz
>
> >
> > Is that normal? And how avoid that running database is restarted?
> > We tried two configuration methods using OCF and LSB Oracle resources but
> > we
> > face the same problem.
> >
> > We can attach logs or configuration files if needed.
> >
> > Please help us.
> >
> > Best regards.
> >
> > Meryem Belhadj.
> > System Engineer.
> > _______________________________________________
> > 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
>
<cib generated="true" admin_epoch="0" epoch="10" num_updates="1"
have_quorum="true" ignore_dtd="false" num_peers="2" ccm_transition="2"
cib_feature_revision="2.0" crm_feature_set="2.0"
dc_uuid="e3b0cf04-e13c-43d5-9cff-3d7b1aac8538" cib-last-written="Wed Sep 23
16:11:14 2009">
<configuration>
<crm_config>
<cluster_property_set id="cib-bootstrap-options">
<attributes>
<nvpair id="cib-bootstrap-options-dc-version" name="dc-version"
value="2.1.3-node: a3184d5240c6e7032aef9cce6e5b7752ded544b3"/>
</attributes>
</cluster_property_set>
</crm_config>
<nodes>
<node id="581661ec-ce3e-4a75-b29f-6a12dbc8f03e" uname="ttndb1"
type="normal"/>
<node id="e3b0cf04-e13c-43d5-9cff-3d7b1aac8538" uname="ttndb2"
type="normal"/>
</nodes>
<resources>
<group id="liasse-srv" ordered="true" collocated="true">
<primitive id="liasse-vg" class="ocf" type="LVM" provider="heartbeat">
<instance_attributes id="liasse-vg_instance_attrs">
<attributes>
<nvpair id="liasse-vg-volgrpname" name="volgrpname"
value="liasse-vg"/>
</attributes>
</instance_attributes>
<operations>
<op id="liasse-vg-monitor" name="monitor" interval="10"
timeout="30" start_delay="10"/>
</operations>
</primitive>
<primitive id="liasse-fs" class="ocf" type="Filesystem"
provider="heartbeat">
<instance_attributes id="liasse-fs_instance_attrs">
<attributes>
<nvpair id="liasse-fs-fstype" name="fstype" value="reiserfs"/>
<nvpair id="liasse-fs-device" name="device"
value="/dev/liasse-vg/liasse-lv"/>
<nvpair id="liasse-fs-directory" name="directory"
value="/liasse"/>
<nvpair id="liasse-fs-options" name="options"
value="acl,user_xattr"/>
</attributes>
</instance_attributes>
<operations>
<op id="liasse-fs-monitor" name="monitor" interval="20"
timeout="40" start_delay="10"/>
</operations>
</primitive>
<primitive id="fb-liasse-vg" class="ocf" type="LVM"
provider="heartbeat">
<instance_attributes id="fb-liasse-vg_instance_attrs">
<attributes>
<nvpair id="fb-liasse-vg-volgrpname" name="volgrpname"
value="fb-liasse-vg"/>
</attributes>
</instance_attributes>
<operations>
<op id="fb-liasse-vg-monitor" name="monitor" interval="10"
timeout="30" start_delay="10"/>
</operations>
</primitive>
<primitive id="fb-liasse-fs" class="ocf" type="Filesystem"
provider="heartbeat">
<instance_attributes id="fb-liasse-fs_instance_attrs">
<attributes>
<nvpair id="fb-liasse-fs-fstype" name="fstype" value="reiserfs"/>
<nvpair id="fb-liasse-fs-device" name="device"
value="/dev/fb-liasse-vg/fb-liasse-lv"/>
<nvpair id="fb-liasse-fs-directory" name="directory"
value="/flashback_liasse"/>
<nvpair id="fb-liasse-fs-options" name="options"
value="acl,user_xattr"/>
</attributes>
</instance_attributes>
<operations>
<op id="fb-liasse-fs-monitor" name="monitor" interval="20"
timeout="40" start_delay="10"/>
</operations>
</primitive>
<primitive id="liasse-ip" class="ocf" type="IPaddr2"
provider="heartbeat">
<instance_attributes id="liasse-ip_instance_attrs">
<attributes>
<nvpair id="liasse-ip-ip" name="ip" value="10.150.3.8"/>
<nvpair id="liasse-ip-nic" name="nic" value="bond0"/>
<nvpair id="liasse-ip-cidr_netmask" name="cidr_netmask"
value="255.255.255.0"/>
<nvpair id="liasse-ip-iflabel" name="iflabel" value="liasse"/>
</attributes>
</instance_attributes>
<operations>
<op id="liasse-ip-monitor" name="monitor" interval="10s"
timeout="20s" start_delay="5s"/>
</operations>
</primitive>
<primitive id="liasse-db" class="lsb" type="liassedb"
provider="heartbeat"/>
<primitive id="liasse-lsnr" class="lsb" type="liasselsnr"
provider="heartbeat"/>
<instance_attributes id="liasse-srv_instance_attrs">
<attributes/>
</instance_attributes>
</group>
<group id="web-srv" ordered="true" collocated="true">
<primitive id="web-vg" class="ocf" type="LVM" provider="heartbeat">
<instance_attributes id="web-vg_instance_attrs">
<attributes>
<nvpair id="web-vg-volgrpname" name="volgrpname" value="web-vg"/>
</attributes>
</instance_attributes>
<operations>
<op id="web-vg-monitor" name="monitor" interval="10" timeout="30"
start_delay="10"/>
</operations>
</primitive>
<primitive id="web-fs" class="ocf" type="Filesystem"
provider="heartbeat">
<instance_attributes id="web-fs_instance_attrs">
<attributes>
<nvpair id="web-fs-fstype" name="fstype" value="reiserfs"/>
<nvpair id="web-fs-device" name="device"
value="/dev/web-vg/web-lv"/>
<nvpair id="web-fs-directory" name="directory" value="/web"/>
<nvpair id="web-fs-options" name="options"
value="acl,user_xattr"/>
</attributes>
</instance_attributes>
<operations>
<op id="web-fs-monitor" name="monitor" interval="20" timeout="40"
start_delay="10"/>
</operations>
</primitive>
<primitive id="fb-web-vg" class="ocf" type="LVM" provider="heartbeat">
<instance_attributes id="fb-web-vg_instance_attrs">
<attributes>
<nvpair id="fb-web-vg-volgrpname" name="volgrpname"
value="fb-web-vg"/>
</attributes>
</instance_attributes>
<operations>
<op id="fb-web-vg-monitor" name="monitor" interval="10"
timeout="30" start_delay="10"/>
</operations>
</primitive>
<primitive id="fb-web-fs" class="ocf" type="Filesystem"
provider="heartbeat">
<instance_attributes id="fb-web-fs_instance_attrs">
<attributes>
<nvpair id="fb-web-fs-fstype" name="fstype" value="reiserfs"/>
<nvpair id="fb-web-fs-device" name="device"
value="/dev/fb-web-vg/fb-web-lv"/>
<nvpair id="fb-web-fs-directory" name="directory"
value="/flashback_web"/>
<nvpair id="fb-web-fs-options" name="options"
value="acl,user_xattr"/>
</attributes>
</instance_attributes>
<operations>
<op id="fb-web-fs-monitor" name="monitor" interval="20"
timeout="40" start_delay="10"/>
</operations>
</primitive>
<primitive id="web-ip" class="ocf" type="IPaddr2" provider="heartbeat">
<instance_attributes id="web-ip_instance_attrs">
<attributes>
<nvpair id="web-ip-ip" name="ip" value="10.150.3.9"/>
<nvpair id="web-ip-nic" name="nic" value="bond0"/>
<nvpair id="web-ip-cidr_netmask" name="cidr_netmask"
value="255.255.255.0"/>
<nvpair id="web-ip-iflabel" name="iflabel" value="web"/>
</attributes>
</instance_attributes>
<operations>
<op id="web-ip-monitor" name="monitor" interval="10s"
timeout="20s" start_delay="5s"/>
</operations>
</primitive>
<primitive id="web-db" class="lsb" type="webdb" provider="heartbeat"/>
<primitive id="web-lsnr" class="lsb" type="weblsnr"
provider="heartbeat"/>
<instance_attributes id="web-srv_instance_attrs">
<attributes/>
</instance_attributes>
</group>
</resources>
<constraints>
<rsc_location id="liasse-srv-prefer-node1" rsc="liasse-srv">
<rule id="liasse-srv-prefer-node1-rule" score="1000">
<expression id="liasse-srv-prefer-node1-rule-exp" attribute="#uname"
operation="eq" value="ttndb1"/>
</rule>
</rsc_location>
<rsc_location id="liasse-srv-connected" rsc="liasse-srv">
<rule id="liasse-srv-IS-connected" score="-INFINITY" boolean_op="or">
<expression id="liasse-srv-IS-connected-not_defined"
attribute="pingd" operation="not_defined"/>
<expression id="liasse-srv-IS-connected-lte-0" attribute="pingd"
operation="lte" value="0"/>
</rule>
</rsc_location>
<rsc_location id="web-srv-prefer-node2" rsc="web-srv">
<rule id="web-srv-prefer-node2-rule" score="1000">
<expression id="web-srv-prefer-node2-rule-exp" attribute="#uname"
operation="eq" value="ttndb2"/>
</rule>
</rsc_location>
<rsc_location id="web-srv-connected" rsc="web-srv">
<rule id="web-srv-IS-connected" score="-INFINITY" boolean_op="or">
<expression id="web-srv-IS-connected-not_defined" attribute="pingd"
operation="not_defined"/>
<expression id="web-srv-IS-connected-lte-0" attribute="pingd"
operation="lte" value="0"/>
</rule>
</rsc_location>
<rsc_location id="cli-prefer-liasse-srv" rsc="liasse-srv">
<rule id="prefered_cli-prefer-liasse-srv" score="INFINITY">
<expression attribute="#uname"
id="bee1cb05-7a7a-4ac1-a88f-758add54c335" operation="eq" value="ttndb2"/>
</rule>
</rsc_location>
</constraints>
</configuration>
</cib>
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems
