Re: oracle-l Digest V11 #115 / Re: Oracle RAC listener on a 2nd network
- From: Markus Michalewicz <Markus.Michalewicz@xxxxxxxxxx>
- To: George Leonard - Business Connexion <George.Leonard@xxxxxxxxx>
- Date: Tue, 22 Apr 2014 06:03:36 -0700
Hello George,
Thanks for asking: "Is multiple SCAN's supported yet, on different
interfaces?"
YES, as the paper formerly linked explains, multiple SCANs can be used in a
"one SCAN per subnet" manner with Oracle Grid Infrastructure 12c. Note that the
default assumes that there is only one subnet per interface and this is what
the paper explains (it uses a subnet on eth0 and another on eth2). However, one
can use only one physical interface if needed, which I would not recommend if
strong isolation is required. More details can be found in the paper.
Thanks,
Markus
On Apr 21, 2014, at 11:10 PM, George Leonard - Business Connexion wrote:
> Markus
>
> Is multiple SCAN's supported yet, on different interfaces?
>
>
> Sent from my iPhone 5
>
> George Leonard
> __________________________
> Georgelza@xxxxxxxxx
> +27 82 655 2466
>
> On 22 Apr 2014, at 8:03, "Markus Michalewicz" <Markus.Michalewicz@xxxxxxxxxx>
> wrote:
>
>> 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
>>
>> <oracle_sig_logo.gif>
>> 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:
