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