RE: oracle-l Digest V11 #115 / Re: Oracle RAC listener on a 2nd network
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:
- Create additional subnet(s) on the (public) network(s)�
- Assign node VIPs to newly created subnet(s)�
- Create a node Listener for newly created subnet(s)�
- 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