RE: Cluster Interconnects configured in single-instance DB
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: Jeffery Thomas <jeffthomas24@xxxxxxxxx>
- Date: Fri, 4 Apr 2008 13:33:52 -0400
Well, it can't be really *using* it, in the sense that it's got no other nodes
to talk to, but perhaps the RAC-aware binaries have a code path that detects
the interconnects (apparently by reading the OCR?) and lists them in that V$
view?
-Mark
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxx
www.proquest.com
www.csa.com
ProQuest...Start here.
-----Original Message-----
From: Jeffery Thomas [mailto:jeffthomas24@xxxxxxxxx]
Sent: Friday, April 04, 2008 1:27 PM
To: Bobak, Mark
Cc: oracle-l
Subject: Re: Cluster Interconnects configured in single-instance DB
Yes it does -- and in fact, I thought of that 5 seconds after I sent
this email. I guess then, it is actually *using* it?
On Fri, Apr 4, 2008 at 1:18 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx> wrote:
> Hmm....does the single instance database use the same $ORACLE_HOME as the RAC
> database?
>
> -Mark
>
> --
> Mark J. Bobak
> Senior Database Administrator, System & Product Technologies
> ProQuest
> 789 E. Eisenhower, Parkway, P.O. Box 1346
> Ann Arbor MI 48106-1346
> +1.734.997.4059 or +1.800.521.0600 x 4059
> mark.bobak@xxxxxxxxxxxx
> www.proquest.com
> www.csa.com
>
> ProQuest...Start here.
>
>
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Jeffery Thomas
> Sent: Friday, April 04, 2008 12:56 PM
> To: oracle-l
> Subject: Cluster Interconnects configured in single-instance DB
>
> We have a two-node 10.2.0.3 RAC system on Solaris 10 using Oracle
> Clusterware and ASM that is being used for our test
> database.. We also have a single-instance database on one node of
> this cluster being used for development.
>
> The dev database is using ASM, sharing the same data disk group as
> the RAC database.
>
> I noticed on startup in the alert.log that it is configuring
> interconnects; in addition, when I perform this query in the
> single-instance database:
>
> SQL> select * from v$cluster_interconnects;
>
> NAME IP_ADDRESS IS_ SOURCE
> --------------- ---------------- --- -------------------------------
> e1000g2 192.168.1.103 NO Oracle Cluster Repository
> e1000g5 192.168.1.102 NO Oracle Cluster Repository
>
> The question I have is: why? Is it because it is accessing a
> disk group maintained by a clustered ASM?
>
> Thanks,
> Jeff
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
