RE: Oracle RAC listener on a 2nd network
- From: Upendra <nupendra@xxxxxxxxxxx>
- To: "riyaj.shamsudeen@xxxxxxxxx" <riyaj.shamsudeen@xxxxxxxxx>
- Date: Mon, 21 Apr 2014 22:19:51 -0400
Riyaj, Thanks for pointing out about the 12c scan. I will look into it.
My preference would be to find a way to make this work without going through an
upgrade..
Could we bypass the SCAN listeners and connect to the instances directly? What
kind of issues am I inviting?
Thanks much
-Upendra
From: riyaj.shamsudeen@xxxxxxxxx
Date: Mon, 21 Apr 2014 16:53:27 -0700
Subject: Re: Oracle RAC listener on a 2nd network
To: nupendra@xxxxxxxxxxx
CC: andrew.kerber@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Scan listeners in the second network is supported from 12c. So, another option
is to upgrade the clusterware to 12c,create the new database in 12c, and keep
the existing database in 11.2.0.4 for now.
However, i have not tested this configuration and so, YMMV.Cheers
Riyaj Shamsudeen
Principal DBA,
Ora!nternals - http://www.orainternals.com - Specialists in Performance, RAC
and EBS
Blog: http://orainternals.wordpress.com/
Oracle ACE Director and OakTable member
Co-author of the books: Expert Oracle Practices, Pro Oracle SQL, Expert RAC
Practices 12c. Expert PL/SQL practices
On Mon, Apr 21, 2014 at 4:46 PM, Upendra <nupendra@xxxxxxxxxxx> wrote:
Yeah. The second database will be part of the same cluster.
Date: Mon, 21 Apr 2014 18:30:37 -0500
Subject: Re: Oracle RAC listener on a 2nd network
From: andrew.kerber@xxxxxxxxx
To: nupendra@xxxxxxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
Sounds tricky. Is this second database clustered? Failover configuration might
be kind of iffy.
On Mon, Apr 21, 2014 at 5:17 PM, Upendra <nupendra@xxxxxxxxxxx> wrote:
Hello All -
I have a 11.2.0.4 Oracle RAC running on Sparc platform with 3 nodes. I have the
scan listeners configured on Network_A and an application is using the scan
Listeners.
Without impacting the above setup, I would like to create a second database in
the RAC environment and setup access for another set of applications through
another network Network_B. They both are independent networks (its a
requirement based on the legacy networks we have). I need the listener for the
second database to be listening on Network_B.
Example:
Network_A - 192.168.6.x
Network_B - 10.120.2.x
What are my options in creating such a setup and what are the
limitations/constraints in this setup?
I'd assume if I bypass the SCAN listeners and access the database listener
directly, I'd have to keep up with the cluster changes at the application layer
(like node additions/removal etc).. Similar to Oracle 10g RAC - anything else?
Thanks much
-Upendra
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
