<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="white" lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Thank you,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">We tried getting resource out of group.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">But unfortunately the resource which is not corrupted still does not start<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">In Logs we see the following error<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">warning: Forcing testdbc away from krplporacle001 after 1000000 failures (max=1000000)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Apr 5 11:24:00 krplporacle001 pengine[2800]: warning: Forcing testdbc away from krplporacle002 after 1000000 failures (max=1000000)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Seems that if the testdbc does not start it fails and then tries on node 2 and fails it<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">How can we make it start<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">pcs resource show testdbc<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Resource: testdbc (class=ocf provider=heartbeat type=oracle)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> Attributes: sid=testdbc home=/u01/app/oracle/product/12.1.0.2/db_1 user=oracle monuser=C##OCFMON1 monpassword=C##OCFMON1 monprofile=C##OCFMONPROFILE1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> Operations: start interval=0s timeout=500 on-fail=restart (testdbc-start-interval-0s)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> stop interval=0s timeout=500 on-fail=ignore (testdbc-stop-interval-0s)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> monitor interval=60s timeout=500 on-fail=restart (testdbc-monitor-interval-60s)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">[root@krplporacle001 ~]#<o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"> Muhammad Sharfuddin [mailto:M.Sharfuddin@nds.com.pk]
<br>
<b>Sent:</b> Wednesday, April 05, 2017 8:53 AM<br>
<b>To:</b> users@clusterlabs.org; SAYED, MAJID ALI SYED AMJAD ALI<br>
<b>Subject:</b> Re: [ClusterLabs] Oracle resource agent failure<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">On 04/05/2017 09:53 AM, SAYED, MAJID ALI SYED AMJAD ALI wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Hello,<o:p></o:p></p>
<p class="MsoNormal">We are trying to build a 2 node Active/Passive Linux HA cluster using pacemaker and corosync on RHEL 7.2 using shared storage (SAN) that will be used for oracle database
<o:p></o:p></p>
<p class="MsoNormal">We have build LVM resource, Filesystem resource and Virtual IP.<o:p></o:p></p>
<p class="MsoNormal">The database administrator has build couple of oracle db and oracle listener resources.<o:p></o:p></p>
<p class="MsoNormal">All these resources are in group<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Resource Group: oraclegrp<o:p></o:p></p>
<p class="MsoNormal"> vgres (ocf::heartbeat:LVM): Started krplporacle001<o:p></o:p></p>
<p class="MsoNormal"> Cluster_ip (ocf::heartbeat:IPaddr2): Started krplporacle001<o:p></o:p></p>
<p class="MsoNormal"> u02 (ocf::heartbeat:Filesystem): Started krplporacle001<o:p></o:p></p>
<p class="MsoNormal"> u03 (ocf::heartbeat:Filesystem): Started krplporacle001<o:p></o:p></p>
<p class="MsoNormal"> u04 (ocf::heartbeat:Filesystem): Started krplporacle001<o:p></o:p></p>
<p class="MsoNormal"> ls_testdbc (ocf::heartbeat:oralsnr): Started krplporacle001<o:p></o:p></p>
<p class="MsoNormal"> testdbc (ocf::heartbeat:oracle): Stopped<o:p></o:p></p>
<p class="MsoNormal"> ls_samtest (ocf::heartbeat:oralsnr): Stopped<o:p></o:p></p>
<p class="MsoNormal"> samtest (ocf::heartbeat:oracle): Stopped<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">For testing purpose he has purposely corrupted testdbc oracle resource and transferred the resource to passive node.<o:p></o:p></p>
<p class="MsoNormal">But we are not sure if one oracle resource in group why the other is not starting after transferring the service<o:p></o:p></p>
<p class="MsoNormal">Any help would be much appreciated<o:p></o:p></p>
<p class="MsoNormal">The logs only specify that oracle resource for testdbc is not running , but it does not even attempt to start samtest?<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
</blockquote>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif"">resources in the resource group started in the sequence, so in your case if testdbc is stopped(for any reason) cluster wouldn't even attempt to start the "ls_samtest"
and "samtest", because they are dependent upon successful startup of 'testdbc'.<br>
<br>
Hope this helps. <br>
<br>
</span><span style="font-size:10.0pt;font-family:"Times New Roman","serif"">--<br>
Regards,<br>
<br>
Muhammad Sharfuddin<br>
Cell: +92-3332144823 | UAN: +92(21) 111-111-142 ext: 112 | <a href="http://www.nds.com.pk">
NDS.COM.PK</a></span><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><o:p></o:p></span></p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1">This Email and any files transmitted may contain confidential and/or privileged information and is intended solely for the addressee(s) named. If you have received this information in error, or are being posted by accident,
please notify the sender by return Email, do not redistribute this email message, delete it immediately and keep no copies of it. All opinions and/or views expressed in this email are solely those of the author and do not necessarily represent those of NGHA.
Any purchase order, purchase advice or legal commitment is only valid once backed by the signed hardcopy by the authorized person from NGHA.<br>
</font>
</body>
</html>