<p dir="ltr">I suggest to remove mon* variables (monuser, monprofil, monpassword) if they don't already exist in data base.</p>
<p dir="ltr">Then, make sure that you point on the right Oracle Home where the tool were installed (sqlplus and tnslsnr).</p>
<p dir="ltr">Finally, use pcs resource debug-start testdbc --full<br></p>
<br><div class="gmail_quote"><div dir="ltr">On Wed, Apr 5, 2017, 10:32 SAYED, MAJID ALI SYED AMJAD ALI <<a href="mailto:sayedma2@ngha.med.sa">sayedma2@ngha.med.sa</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="white" lang="EN-US" link="blue" vlink="purple" class="gmail_msg">
<div class="m_-4606394194127705247WordSection1 gmail_msg">
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg">Thank you,<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg">We tried getting resource out of group.<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg">But unfortunately the resource which is not corrupted still does not start<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg">In Logs we see the following error<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg">warning: Forcing testdbc away from krplporacle001 after 1000000 failures (max=1000000)<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg">Apr 5 11:24:00 krplporacle001 pengine[2800]: warning: Forcing testdbc away from krplporacle002 after 1000000 failures (max=1000000)<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg">Seems that if the testdbc does not start it fails and then tries on node 2 and fails it<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg">How can we make it start<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg">pcs resource show testdbc<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg">Resource: testdbc (class=ocf provider=heartbeat type=oracle)<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg"> Attributes: sid=testdbc home=/u01/app/oracle/product/<a href="http://12.1.0.2/db_1" class="gmail_msg" target="_blank">12.1.0.2/db_1</a> user=oracle monuser=C##OCFMON1 monpassword=C##OCFMON1 monprofile=C##OCFMONPROFILE1<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg"> Operations: start interval=0s timeout=500 on-fail=restart (testdbc-start-interval-0s)<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg"> stop interval=0s timeout=500 on-fail=ignore (testdbc-stop-interval-0s)<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg"> monitor interval=60s timeout=500 on-fail=restart (testdbc-monitor-interval-60s)<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="color:#1f497d" class="gmail_msg">[root@krplporacle001 ~]#<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<div class="gmail_msg">
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in" class="gmail_msg">
<p class="MsoNormal gmail_msg"><b class="gmail_msg"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext" class="gmail_msg">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext" class="gmail_msg"> Muhammad Sharfuddin [mailto:<a href="mailto:M.Sharfuddin@nds.com.pk" class="gmail_msg" target="_blank">M.Sharfuddin@nds.com.pk</a>]
<br class="gmail_msg">
<b class="gmail_msg">Sent:</b> Wednesday, April 05, 2017 8:53 AM<br class="gmail_msg">
<b class="gmail_msg">To:</b> <a href="mailto:users@clusterlabs.org" class="gmail_msg" target="_blank">users@clusterlabs.org</a>; SAYED, MAJID ALI SYED AMJAD ALI<br class="gmail_msg">
<b class="gmail_msg">Subject:</b> Re: [ClusterLabs] Oracle resource agent failure<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
</div>
</div></div></div><div bgcolor="white" lang="EN-US" link="blue" vlink="purple" class="gmail_msg"><div class="m_-4606394194127705247WordSection1 gmail_msg">
<p class="MsoNormal gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></p>
<div class="gmail_msg">
<p class="MsoNormal gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></p>
</div>
<div class="gmail_msg">
<p class="MsoNormal gmail_msg">On 04/05/2017 09:53 AM, SAYED, MAJID ALI SYED AMJAD ALI wrote:<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt" class="gmail_msg">
<p class="MsoNormal gmail_msg">Hello,<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg">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
<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg">We have build LVM resource, Filesystem resource and Virtual IP.<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg">The database administrator has build couple of oracle db and oracle listener resources.<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg">All these resources are in group<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"> <u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg">Resource Group: oraclegrp<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"> vgres (ocf::heartbeat:LVM): Started krplporacle001<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"> Cluster_ip (ocf::heartbeat:IPaddr2): Started krplporacle001<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"> u02 (ocf::heartbeat:Filesystem): Started krplporacle001<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"> u03 (ocf::heartbeat:Filesystem): Started krplporacle001<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"> u04 (ocf::heartbeat:Filesystem): Started krplporacle001<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"> ls_testdbc (ocf::heartbeat:oralsnr): Started krplporacle001<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"> testdbc (ocf::heartbeat:oracle): Stopped<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"> ls_samtest (ocf::heartbeat:oralsnr): Stopped<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"> samtest (ocf::heartbeat:oracle): Stopped<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"> <u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg">For testing purpose he has purposely corrupted testdbc oracle resource and transferred the resource to passive node.<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg">But we are not sure if one oracle resource in group why the other is not starting after transferring the service<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg">Any help would be much appreciated<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg">The logs only specify that oracle resource for testdbc is not running , but it does not even attempt to start samtest?<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"> <u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</blockquote>
<p class="MsoNormal gmail_msg"><span style="font-size:12.0pt;font-family:"Times New Roman","serif"" class="gmail_msg">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 class="gmail_msg">
<br class="gmail_msg">
Hope this helps. <br class="gmail_msg">
<br class="gmail_msg">
</span><span style="font-size:10.0pt;font-family:"Times New Roman","serif"" class="gmail_msg">--<br class="gmail_msg">
Regards,<br class="gmail_msg">
<br class="gmail_msg">
Muhammad Sharfuddin<br class="gmail_msg">
Cell: +92-3332144823 | UAN: +92(21) 111-111-142 ext: 112 | <a href="http://www.nds.com.pk" class="gmail_msg" target="_blank">
NDS.COM.PK</a></span><span style="font-size:12.0pt;font-family:"Times New Roman","serif"" class="gmail_msg"><u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
</div></div><div bgcolor="white" lang="EN-US" link="blue" vlink="purple" class="gmail_msg">
<hr class="gmail_msg">
<font face="Arial" color="Gray" size="1" class="gmail_msg">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 class="gmail_msg">
</font>
</div>
_______________________________________________<br class="gmail_msg">
Users mailing list: <a href="mailto:Users@clusterlabs.org" class="gmail_msg" target="_blank">Users@clusterlabs.org</a><br class="gmail_msg">
<a href="http://lists.clusterlabs.org/mailman/listinfo/users" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.clusterlabs.org/mailman/listinfo/users</a><br class="gmail_msg">
<br class="gmail_msg">
Project Home: <a href="http://www.clusterlabs.org" rel="noreferrer" class="gmail_msg" target="_blank">http://www.clusterlabs.org</a><br class="gmail_msg">
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" class="gmail_msg" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br class="gmail_msg">
Bugs: <a href="http://bugs.clusterlabs.org" rel="noreferrer" class="gmail_msg" target="_blank">http://bugs.clusterlabs.org</a><br class="gmail_msg">
</blockquote></div><div dir="ltr">-- <br></div><div data-smartmail="gmail_signature"><div dir="ltr"><div><div><br><br></div><div>Jihed MSELMI<br></div><div><span>RHCE, </span>RHCSA, VCP4 <br></div>10 Villa Stendhal, 75020 Paris France<br></div>Mobile: +33 (0) 753768653</div></div>