Re: Oracle RAC listener on a 2nd network
- From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
- To: nupendra@xxxxxxxxxxx
- Date: Mon, 21 Apr 2014 16:53:27 -0700
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 <http://www.oaktable.com/>
Co-author of the books: Expert Oracle
Practices<http://tinyurl.com/book-expert-oracle-practices/>
, Pro Oracle SQL, <http://tinyurl.com/ahpvms8>
<http://tinyurl.com/ahpvms8>Expert
RAC Practices 12c. <http://tinyurl.com/expert-rac-12c> Expert PL/SQL
practices <http://tinyurl.com/book-expert-plsql-practices>
<http://tinyurl.com/book-expert-plsql-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:
