RE: oracle-l Digest V11 #115 / Re: Oracle RAC listener on a 2nd network

From: Luca Canali <Luca.Canali_at_cern.ch>
Date: Tue, 22 Apr 2014 10:05:12 +0000
Message-ID: <65B60DE2172D714C844C84BEA3346893CC7BDF62_at_CERNXCHG43.cern.ch>



Hi Markus,

Welcome to posting to oracle-l and thumbs up to the new feature of 'support for SCAN in multiple subnets'. I just wanted to add that the new feature works very well for us, currently deployed in a 'mixed environment' with 12c Grid Infrastructure and 11.2.0.4 RDBMS (on Linux).

Regards,
Luca

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Markus Michalewicz Sent: 22 April 2014 08:01
To: andrew.kerber_at_gmail.com; nupendra_at_hotmail.com Cc: oracle-l_at_freelists.org
Subject: Re: oracle-l Digest V11 #115 / Re: Oracle RAC listener on a 2nd network

Dear all, 

        This is my first attempt to post to this list, so bear with me, please. 

This paper http://www.oracle.com/technetwork/database/options/clustering/overview/scan-129069.pdf describes "Enabling Multiple-Subnet Support for SCAN" on pages 7ff, which involves the following steps:

  1. Create additional subnet(s) on the (public) network(s) 
  2. Assign node VIPs to newly created subnet(s) 
  3. Create a node Listener for newly created subnet(s) 
  4. Create (a) SCAN(s) using the option one or two 

On Grid Infrastructure 11.2.0.4, steps 1-3 should be pretty much the same as in Oracle Grid Infrastructure 12c. The support for SCAN in multiple subnets is an Oracle 12c new feature.

However, as you can see, steps 1-3 are non-disruptive for the first network, especially as it is assumed that the second subnet uses a different of NICs. Based on this assumption you can create a second subnet on a second set of NICs without impacting the first subnet. However, SCAN support on the second subnet can only be enabled with Oracle Grid Infrastructure (GI)12c. With GI 11.2.0.4, your clients accessing the second subnet would need to use the node listeners directly, as the paper also explains. 

Hope that helps. Thanks,
        Markus

Markus Michalewicz | Director of Product Management Oracle Real Application Clusters (RAC) 
Phone: +16505065444 | Mobile: +16502937832  500 Oracle Parkway M/S 4OP840 | Redwood Shores, CA 94065 

On Apr 21, 2014, at 10:05 PM, FreeLists Mailing List Manager wrote:

oracle-l Digest Mon, 21 Apr 2014 Volume: 11  Issue: 115

In This Issue:

		Oracle RAC listener on a 2nd network
		Re: Oracle RAC listener on a 2nd network
		RE: Oracle RAC listener on a 2nd network
		Re: Oracle RAC listener on a 2nd network
		RE: Oracle RAC listener on a 2nd network
		Re: Oracle RAC listener on a 2nd network
		Re: Oracle RAC listener on a 2nd network


----------------------------------------------------------------------

From: Upendra <nupendra_at_hotmail.com>
Subject: Oracle RAC listener on a 2nd network Date: Mon, 21 Apr 2014 18:17:02 -0400

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

                            


Date: Mon, 21 Apr 2014 18:30:37 -0500
Subject: Re: Oracle RAC listener on a 2nd network From: Andrew Kerber <andrew.kerber_at_gmail.com>

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_at_hotmail.com> 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.'


From: Upendra <nupendra_at_hotmail.com>
Subject: RE: Oracle RAC listener on a 2nd network Date: Mon, 21 Apr 2014 19:46:21 -0400

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_at_gmail.com
To: nupendra_at_hotmail.com
CC: oracle-l_at_freelists.org

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_at_hotmail.com> 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.'

                            


From: Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com> Date: Mon, 21 Apr 2014 16:53:27 -0700
Subject: Re: Oracle RAC listener on a 2nd network

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_at_hotmail.com> 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_at_gmail.com
To: nupendra_at_hotmail.com
CC: oracle-l_at_freelists.org

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_at_hotmail.com> 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.'


From: Upendra <nupendra_at_hotmail.com>
Subject: RE: Oracle RAC listener on a 2nd network 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_at_gmail.com
Date: Mon, 21 Apr 2014 16:53:27 -0700
Subject: Re: Oracle RAC listener on a 2nd network To: nupendra_at_hotmail.com
CC: andrew.kerber_at_gmail.com; oracle-l_at_freelists.org

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_at_hotmail.com> 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_at_gmail.com
To: nupendra_at_hotmail.com
CC: oracle-l_at_freelists.org

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_at_hotmail.com> 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.'

                            

                            


From: Stalin <stalinsk_at_gmail.com>
Subject: Re: Oracle RAC listener on a 2nd network 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_at_hotmail.com> 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_at_gmail.com
Date: Mon, 21 Apr 2014 16:53:27 -0700
Subject: Re: Oracle RAC listener on a 2nd network To: nupendra_at_hotmail.com
CC: andrew.kerber_at_gmail.com; oracle-l_at_freelists.org

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_at_hotmail.com> 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_at_gmail.com
To: nupendra_at_hotmail.com
CC: oracle-l_at_freelists.org

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_at_hotmail.com> 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.'


From: Jared Still <jkstill_at_gmail.com> Date: Mon, 21 Apr 2014 20:25:50 -0700
Subject: Re: Oracle RAC listener on a 2nd network

On Mon, Apr 21, 2014 at 3:17 PM, Upendra <nupendra_at_hotmail.com> wrote:

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.

I've done something quite similar to this in 11.2.0.x RAC.

The same databases were involved, but two different networks, internal and external.

That was a couple years ago, just looked up my notes and found the Oracle Support document:

   How to Configure A Second Listener on a Separate Network in 11.2 Grid Infrastructure [ID 1063571.1]

As I recall the note was a little unclear is spots, but we did get it to work.
The method is not entirely straight forward, but is supported, and once setup works as expected.

I would point you to a blog if I had written one ( shame on me ), but I did write an internal document that I think could be easily converted to a blog.

If this note seems to cover it , feel free to ask any questions you may have about it.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Sr Oracle DBA at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/ Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com


End of oracle-l Digest V11 #115


--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 22 2014 - 12:05:12 CEST

Original text of this message