what sin gv$instance ? ________________________________ From: "Walker, Jed S" <Jed_Walker@xxxxxxxxxxxxxxxxx> To: oracle-l <oracle-l@xxxxxxxxxxxxx> Sent: Monday, September 10, 2012 8:41 AM Subject: instance running on two nodes 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 -- //www.freelists.org/webpage/oracle-l