ORACLE11g R2 RAC to RAC Data Guard Sync via separate public

Questions relating to Oracle Real Application Clusters (RAC) and Clusterware.

Moderator: Tim...

ORACLE11g R2 RAC to RAC Data Guard Sync via separate public

Postby hitgon » Fri Mar 08, 2013 7:43 am

Hi Tim Hall

OS Platform:- RHEL5.5 64bit
Database Version:- 11.2.0.2
CLUSTER:-2-Node RAC Database
DATA SYNC: RAC to RAC Dataguard

Site-1 Configuration
2-Node RAC Database
All the applications of Site-1 is communicate with the Database through the Site-1 Oracle RAC default local site public network1/vlan

Site-2 Configuration
2-Node RAC Database
All the applications of Site-2 is communicate with the Database through the Site-2 Oracle RAC default local site public network1/vlan

We don't want to do Communication of Data Guard Sync via public network1/vlan
so here There is no network communication through the Site-1 default local site public network1/vlan and Site-2 default local site public network1/vlan

Site-1 and Site-2 Database Servers is accessible via separate public network2/vlan
So We want to do Communication of Data Guard Sync via separate public network2/vlan
We have available the separate vlan for this configuration

Please provide your expert valuable suggestions and comments

Can we add second listener in different public network which is in diff vlan then existing default public network in site-1 Oracle RAC?
Can we add second listener in different public network which is in diff vlan then existing default public network in site-2 Oracle RAC?

Thanks in Advance
Awaiting for your response :)

Regards
Hitgon
hitgon
Member
 
Posts: 19
Joined: Wed Aug 03, 2011 1:46 pm

Re: ORACLE11g R2 RAC to RAC Data Guard Sync via separate pub

Postby Tim... » Fri Mar 08, 2013 11:16 am

Hi.

Sure. You can define listeners on any address and as long as the tnsnames.ora entry on the calling server has the correct hostname/IP in it, it will connect just fine.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17951
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: ORACLE11g R2 RAC to RAC Data Guard Sync via separate pub

Postby hitgon » Fri Mar 08, 2013 11:59 am

Thanks Tim

Can you please provide your confirmation regarding Configure Listener in RAC for above requirements

Do we required the separate listener for public network2 or we can also do configure inside same listener?

We are referring the Oracle Meta-Link Note:-
How to Configure A Second Listener on a Separate Network in 11.2 Grid Infrastructure [ID 1063571.1]

Are We on the right track for above specified requirements

Thanks again

Regards
Hitgon
hitgon
Member
 
Posts: 19
Joined: Wed Aug 03, 2011 1:46 pm

Re: ORACLE11g R2 RAC to RAC Data Guard Sync via separate pub

Postby Tim... » Fri Mar 08, 2013 12:43 pm

Hi.

I think so. I think it is a lot clearer to anyone looking if you do this with two listeners.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17951
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: ORACLE11g R2 RAC to RAC Data Guard Sync via separate pub

Postby hitgon » Sat Mar 09, 2013 11:44 am

Hi Tim

We will test the same and let you know

Millions Thanks :) for your suggestions

Regards
Hitgon
hitgon
Member
 
Posts: 19
Joined: Wed Aug 03, 2011 1:46 pm

Re: ORACLE11g R2 RAC to RAC Data Guard Sync via separate pub

Postby Tim... » Sat Mar 09, 2013 12:05 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17951
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle RAC and Clusterware

Who is online

Users browsing this forum: No registered users and 1 guest