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

   If you are asking if 11.2.0.4 database in 12c GI is supported, certainly, Yes. Currently, we are testing this specific combination of versions and a few issues, we have encountered ( so far) are bugs in 11.2.0.4 database software. 12c clusterware is itself stable.

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 Tue, Apr 22, 2014 at 8:43 AM, Upendra <nupendra_at_hotmail.com> wrote:

> 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_at_oracle.com
> Date: Mon, 21 Apr 2014 23:01:11 -0700
> CC: oracle-l_at_freelists.org
> To: andrew.kerber_at_gmail.com; nupendra_at_hotmail.com
>
>
> 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