instance running on two nodes
- From: "Walker, Jed S" <Jed_Walker@xxxxxxxxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 10 Sep 2012 15:41:21 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
