Hello Upendra 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@xxxxxxxxxxx> 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@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 > ******************************* > > >