If we have mulitple orainstance resources with similar names running on same node, stop one resource will effect the others.

Solution Unverified - Updated -

Issue

  • There are 2 orainstance resources used by 2 services that are running, and the resource names are "oradb" and "oradb2".
<orainstance home="/home/oracle/product/11.2.0/dbhome_1" listeners="LISTENER2" name="oradb" user="oracle"/>
<orainstance home="/home/oracle/product/11.2.0/dbhome_1" listeners="LISTENER3" name="oradb2" user="oracle"/>
  • When the resource agent "oradb" is failover to another node, "oradb2" will also be stopped:
Jul 30 10:52:44 node42 root[6901]: Not all Oracle processes for oradb exited cleanly, killing
Jul 30 10:52:44 node42 root[6907]: Cleanup oradb Killed PID 26246
Jul 30 10:52:44 node42 root[6908]: Cleanup oradb Killed PID 26248
Jul 30 10:52:44 node42 root[6909]: Cleanup oradb Killed PID 26252
Jul 30 10:52:44 node42 root[6910]: Cleanup oradb Killed PID 26254
Jul 30 10:52:44 node42 root[6911]: Cleanup oradb Killed PID 26256
Jul 30 10:52:44 node42 root[6912]: Cleanup oradb Killed PID 26258
Jul 30 10:52:44 node42 root[6913]: Cleanup oradb Killed PID 26260
Jul 30 10:52:44 node42 root[6914]: Cleanup oradb Killed PID 26262
Jul 30 10:52:44 node42 root[6915]: Cleanup oradb Killed PID 26264
Jul 30 10:52:44 node42 root[6916]: Cleanup oradb Killed PID 26266
Jul 30 10:52:44 node42root[6917]: Cleanup oradb Killed PID 26268
Jul 30 10:52:44 node42 root[6918]: Cleanup oradb Killed PID 26270
Jul 30 10:52:44 node42 root[6919]: Cleanup oradb Killed PID 26272
Jul 30 10:52:44 node42 root[6920]: Cleanup oradb Killed PID 26274
Jul 30 10:52:44 node42 root[6921]: Cleanup oradb Killed PID 26276
Jul 30 10:52:44 node42 root[6922]: Cleanup oradb Killed PID 26278
Jul 30 10:52:44 node42 root[6923]: Cleanup oradb Killed PID 26280
Jul 30 10:52:44 node42 root[6924]: Cleanup oradb Killed PID 26299
Jul 30 10:52:44 node42 root[6925]: Cleanup oradb Killed PID 26662
Jul 30 10:52:44 node42 root[6926]: Cleanup oradb Killed PID 26683
Jul 30 10:52:44 node42 root[6927]: Cleanup oradb Killed PID 26685
Jul 30 10:52:44 node42 root[6928]: Cleanup oradb Killed PID 30146
Jul 30 10:52:44 node42 root[6929]: Cleanup oradb Killed PID 30156
Jul 30 10:52:44 node42 root[6931]: Stopping service oradb succeeded
Jul 30 10:52:45 node42 rgmanager[6971]: [ip] Removing IPv4 address 192.168.0.74/24 from eth2
Jul 30 10:52:55 node42 rgmanager[7101]: [fs] unmounting /db02
Jul 30 10:52:55 node42 rgmanager[7162]: [lvm] Deactivating scsi3pr_ora02/lv00
Jul 30 10:52:55 node42 rgmanager[7184]: [lvm] Making resilient : lvchange -an scsi3pr_ora02/lv00
Jul 30 10:52:55 node42 rgmanager[7209]: [lvm] Resilient command: lvchange -an scsi3pr_ora02/lv00 --config devices{filter=["a|/dev/mapper/mpathj|","a|/dev/mapper/mpath
Jul 30 10:52:56 node42 rgmanager[7239]: [lvm] Removing ownership tag (node42) from scsi3pr_ora02/lv00
Jul 30 10:52:56 node42 rgmanager[23830]: Service service:DB2 is stopped
Jul 30 10:53:12 node42 root[7675]: Restarting Oracle Database oradb2
Jul 30 10:53:12 node42 root[7676]: Stopping Oracle DB oradb2 immediate
Jul 30 10:53:12 node42 root[7681]: Starting Oracle DB oradb2
Jul 30 10:53:12 node42 root[7691]: Starting Oracle DB oradb2 failed, found errors in stdout
Jul 30 10:53:12 node42 root[7692]: Restarting Oracle Database oradb2
Jul 30 10:53:12 node42 root[7693]: Stopping Oracle DB oradb2 immediate
Jul 30 10:53:12 node42 root[7698]: Starting Oracle DB oradb2
Jul 30 10:53:12 node42 root[7708]: Starting Oracle DB oradb2 failed, found errors in stdout
Jul 30 10:53:12 node42 root[7709]: Restarting Oracle Database oradb2
Jul 30 10:53:12 node42 root[7710]: Stopping Oracle DB oradb2 immediate
Jul 30 10:53:12 node42 root[7715]: Starting Oracle DB oradb2
Jul 30 10:53:12 node42 root[7725]: Starting Oracle DB oradb2 failed, found errors in stdout
Jul 30 10:53:12 node42 root[7726]: Failed to restart Oracle DB oradb2 after 3 tries
Jul 30 10:53:12 node42 root[7730]: Error: 0 vs 1 for oradb2 - returning 1
Jul 30 10:53:12 node42 rgmanager[23830]: status on orainstance "oradb2" returned 1 (generic error)
Jul 30 10:53:13 node42 rgmanager[23830]: Stopping service service:DB3
Jul 30 10:53:13 node42 root[7805]: Stopping service oradb2
Jul 30 10:53:13 node42 root[7806]: Stopping Oracle DB oradb2 immediate
Jul 30 10:53:13 node42 root[7811]: Stopping listener LISTENER3 for oradb2
Jul 30 10:53:15 node42 root[7822]: Stopping service oradb2 succeeded

Environment

  • Red Hat Enterprise Linux Server 6 (with the High Availability Add Ons)
  • resource-agents-3.9.5-24.el6

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content