<div id="imcontent"><font face="'Segoe UI'"><br></font></div>Hi,<div>previously I had only added Oracle to the Pacemaker. But it doesn't allow me to get the data from the databases. Then I added Oracle Listeners to the Pacemaker as another resource and now it's perfectly working.This is my complete configuration script.<br>
<div class="gmail_quote"><div class="gmail_quote"><br></div><div class="gmail_quote"><div class="gmail_quote">node node1 \</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>attributes standby="off"</div>
<div class="gmail_quote">node node2 \</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>attributes standby="off"</div><div class="gmail_quote">primitive ClusterIP ocf:heartbeat:IPaddr2 \</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>params ip="10.17.73.191" cidr_netmask="32" \</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>op monitor interval="10s"</div>
<div class="gmail_quote">primitive DrbdData ocf:linbit:drbd \</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>params drbd_resource="OraData" \</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>op monitor interval="12s"</div><div class="gmail_quote">primitive OraLSN ocf:heartbeat:oralsnr \</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>params sid="TestOraCL" \</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>op monitor interval="30" timeout="60" depth="0"</div><div class="gmail_quote">primitive OraServer ocf:heartbeat:oracle \</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>params sid="TestCMBDB" home="/u01/app/oracle/product/11.2.0/dbhome_1" user="oracle" \</div><div class="gmail_quote">
<span class="Apple-tab-span" style="white-space:pre"> </span>op monitor interval="30s"</div><div class="gmail_quote">primitive OracleFS ocf:heartbeat:Filesystem \</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>params device="/dev/drbd/by-res/OraData" directory="/u01" fstype="ext1"</div>
<div class="gmail_quote">ms DrbdDataClone DrbdData \</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true"</div>
<div class="gmail_quote">colocation OracleFS-with-IP inf: ClusterIP OracleFS</div><div class="gmail_quote">colocation OracleLSN-with-FS inf: OracleFS OraLSN</div><div class="gmail_quote">colocation OracleLSN-with-OracleServer inf: OraLSN OraServer</div>
<div class="gmail_quote">colocation fs_on_drbd inf: OracleFS DrbdDataClone:Master</div><div class="gmail_quote">order OraSerever-after-OracleLSN inf: OraLSN OraServer</div><div class="gmail_quote">order OracleFS-after-DrbdData inf: DrbdDataClone:promote OracleFS:start</div>
<div class="gmail_quote">order OracleFS-after-IP inf: ClusterIP OracleFS</div><div class="gmail_quote">order OracleLSN-after-FS inf: OracleFS OraLSN</div><div class="gmail_quote">property $id="cib-bootstrap-options" \</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>dc-version="1.0.9-71392a28b7f31d7ddc86689298bd23111f28978b" \</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>cluster-infrastructure="openais" \</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>expected-quorum-votes="2" \</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>stonith-enabled="false" \</div>
<div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>last-lrm-refresh="1327161392" \</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>no-quorum-policy="ignore"</div>
<div class="gmail_quote">rsc_defaults $id="rsc-options" \</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>resource-stickiness="100"</div><div class="gmail_quote">
<br></div><div class="gmail_quote"><br></div><div class="gmail_quote"><br></div><div class="gmail_quote">Regards,</div><div class="gmail_quote">Ruwan.</div><div class="gmail_quote"><br></div></div></div></div>