[Pacemaker] Pacemaker + Oracle

[Ruwan Fernando]

Hi,
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.

node node1 \
attributes standby="off"
node node2 \
attributes standby="off"
primitive ClusterIP ocf:heartbeat:IPaddr2 \
params ip="10.17.73.191" cidr_netmask="32" \
op monitor interval="10s"
primitive DrbdData ocf:linbit:drbd \
params drbd_resource="OraData" \
op monitor interval="12s"
primitive OraLSN ocf:heartbeat:oralsnr \
params sid="TestOraCL" \
op monitor interval="30" timeout="60" depth="0"
primitive OraServer ocf:heartbeat:oracle \
params sid="TestCMBDB" home="/u01/app/oracle/product/11.2.0/dbhome_1"
user="oracle" \
op monitor interval="30s"
primitive OracleFS ocf:heartbeat:Filesystem \
params device="/dev/drbd/by-res/OraData" directory="/u01" fstype="ext1"
ms DrbdDataClone DrbdData \
meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1"
notify="true"
colocation OracleFS-with-IP inf: ClusterIP OracleFS
colocation OracleLSN-with-FS inf: OracleFS OraLSN
colocation OracleLSN-with-OracleServer inf: OraLSN OraServer
colocation fs_on_drbd inf: OracleFS DrbdDataClone:Master
order OraSerever-after-OracleLSN inf: OraLSN OraServer
order OracleFS-after-DrbdData inf: DrbdDataClone:promote OracleFS:start
order OracleFS-after-IP inf: ClusterIP OracleFS
order OracleLSN-after-FS inf: OracleFS OraLSN
property $id="cib-bootstrap-options" \
dc-version="1.0.9-71392a28b7f31d7ddc86689298bd23111f28978b" \
cluster-infrastructure="openais" \
expected-quorum-votes="2" \
stonith-enabled="false" \
last-lrm-refresh="1327161392" \
no-quorum-policy="ignore"
rsc_defaults $id="rsc-options" \
resource-stickiness="100"



Regards,
Ruwan.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.clusterlabs.org/pipermail/pacemaker/attachments/20120402/1ec32657/attachment-0002.html>