RE: oracle-l Digest V11 #115 / Re: Oracle RAC listener on a 2nd network
- From: Upendra <nupendra@xxxxxxxxxxx>
- To: "Markus.Michalewicz@xxxxxxxxxx" <markus.michalewicz@xxxxxxxxxx>, "andrew.kerber@xxxxxxxxx" <andrew.kerber@xxxxxxxxx>
- Date: Tue, 22 Apr 2014 11:43:41 -0400
Thanks Markus and everyone who replied.
I am considering the 12c clusterware upgrade and hopefully it is not painful.
BTW, I am trying to find the database and clusterware support matrix in MOS
under "certifications".. I can't seem to find it.. Any pointers?
-Upendra
Subject: Re: oracle-l Digest V11 #115 / Re: Oracle RAC listener on a 2nd network
From: Markus.Michalewicz@xxxxxxxxxx
Date: Mon, 21 Apr 2014 23:01:11 -0700
CC: oracle-l@xxxxxxxxxxxxx
To: andrew.kerber@xxxxxxxxx; nupendra@xxxxxxxxxxx
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@xxxxxxxxxxx>
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@xxxxxxxxx>
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.'
------------------------------
From: Upendra <nupendra@xxxxxxxxxxx>
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@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.'
------------------------------
From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
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@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.'
------------------------------
From: Upendra <nupendra@xxxxxxxxxxx>
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@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.'
------------------------------
From: Stalin <stalinsk@xxxxxxxxx>
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@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.'
------------------------------
From: Jared Still <jkstill@xxxxxxxxx>
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@xxxxxxxxxxx> 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
*******************************
Other related posts:
