instance running on two nodes

From: Walker, Jed S <Jed_Walker_at_cable.comcast.com>
Date: Mon, 10 Sep 2012 15:41:21 +0000
Message-ID: <BAA6E28B6241F046AED1E62D8697516C6F48CAAA_at_COPDCEXMB08.cable.comcast.com>

11.2.0.3.0, RHEL5.6, RAC 8 nodes
Has anyone seen it happen where an instance is running on two nodes (at least, the same instance name).

We're been doing firmware upgrades. As I brought up nodes I noticed that I had two instances running on multiple nodes. I wouldn't have thought that was possible? I shut them down and wish I had done a sqlplus to see what v$instance/v$database showed.

When I shut down the instance on the second node it was, the instance shutdown on both nodes. These seems like it shouldn't be able to happen, and the fact that it did seems a bit scary.

Node4:

oracle   16560     1  0 Sep07 ?        00:01:27 asm_pmon_+ASM4
oracle   18338     1  0 Sep07 ?        00:01:32 ora_pmon_rdvrprd_4

(oracle) flux-rac-node-ch2-04:rdvrprd_4:/home/oracle
(here is where I did the stop instance on node6)
->pmons
oracle 16560 1 0 Sep07 ? 00:01:27 asm_pmon_+ASM4
(oracle) flux-rac-node-ch2-04:rdvrprd_4:/home/oracle
 ->srvctl start instance -d rdvrprd -i rdvrprd_4 -n flux-rac-node-ch2-04
(oracle) flux-rac-node-ch2-04:rdvrprd_4:/home/oracle
 ->pmons

oracle     679     1  0 15:31 ?        00:00:00 ora_pmon_rdvrprd_4
oracle   16560     1  0 Sep07 ?        00:01:27 asm_pmon_+ASM4

(oracle) flux-rac-node-ch2-04:rdvrprd_4:/home/oracle

Node6:

oracle   17218     1  0 15:20 ?        00:00:00 asm_pmon_+ASM6
oracle   18216     1  0 15:21 ?        00:00:00 ora_pmon_rdvrprd_4

(oracle) flux-rac-node-ch2-06:rdvrprd_6:/home/oracle
 ->srvctl stop instance -d rdvrprd -i rdvrprd_4
(oracle) flux-rac-node-ch2-06:rdvrprd_6:/home/oracle
->pmons
oracle 17218 1 0 15:20 ? 00:00:00 asm_pmon_+ASM6
(oracle) flux-rac-node-ch2-06:rdvrprd_6:/home/oracle
 ->srvctl start instance -d rdvrprd -i rdvrprd_6 -n flux-rac-node-ch2-06
(oracle) flux-rac-node-ch2-06:rdvrprd_6:/home/oracle
 ->pmons

oracle   17218     1  0 15:20 ?        00:00:00 asm_pmon_+ASM6
oracle   19458     1  0 15:32 ?        00:00:00 ora_pmon_rdvrprd_6

(oracle) flux-rac-node-ch2-06:rdvrprd_6:/home/oracle
 ->

-Jed

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 10 2012 - 10:41:21 CDT