RE: Cluster Interconnects configured in single-instance DB

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_at_proquest.com
www.proquest.com
www.csa.com

ProQuest...Start here.


-----Original Message-----
From: Jeffery Thomas [mailto:jeffthomas24_at_gmail.com]
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_at_proquest.com> 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_at_proquest.com

>  www.proquest.com

>  www.csa.com

>

>  ProQuest...Start here.

>

>

>

>

>  -----Original Message-----

>  From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

>  --

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

>

>

>

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