Re: instance running on two nodes

From: Kevin Closson <ora_kclosson_at_yahoo.com>
Date: Mon, 10 Sep 2012 17:52:03 -0700 (PDT)
Message-ID: <1347324723.37256.YahooMailNeo_at_web161702.mail.bf1.yahoo.com>

what sin gv$instance ?

---

 From: "Walker, Jed S" <Jed_Walker_at_cable.comcast.com> To: oracle-l <oracle-l_at_freelists.org> 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

--

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

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 10 2012 - 19:52:03 CDT