Re: Oracle RAC listener on a 2nd network
- From: Stalin <stalinsk@xxxxxxxxx>
- To: "nupendra@xxxxxxxxxxx" <nupendra@xxxxxxxxxxx>
- Date: Mon, 21 Apr 2014 19:38:55 -0700
We are running most of our RAC installs in two network setup using
listener_networks in 11gR2 without issues.
Scan listens on public network and a dedicated listener on 2nd network where
our back office application connects to DB using 10g version of connect string.
Stalin
Sent from my Mobile
> On Apr 21, 2014, at 7:19 PM, Upendra <nupendra@xxxxxxxxxxx> wrote:
>
> 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:
