If we have mulitple orainstance resources with similar names running on same node, stop one resource will effect the others.
Issue
- There are 2
orainstanceresources 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.