RE: Cluster Interconnects configured in single-instance DB
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 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:Received on Fri Apr 04 2008 - 12:33:52 CDT
> Hmm....does the single instance database use the same $ORACLE_HOME as the RAC database?
> Mark J. Bobak
> Senior Database Administrator, System & Product Technologies
> 789 E. Eisenhower, Parkway, P.O. Box 1346
> Ann Arbor MI 48106-1346
> +1.734.997.4059 or +1.800.521.0600 x 4059
> 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?