RE: Oracle RAC listener on a 2nd network

  • From: Upendra <nupendra@xxxxxxxxxxx>
  • To: Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx>, "development@xxxxxxxxxxxxxxxxx" <development@xxxxxxxxxxxxxxxxx>
  • Date: Wed, 30 Apr 2014 16:52:15 -0400

Thanks for pointing out the caveat and the fix too! 


Date: Wed, 30 Apr 2014 09:04:04 -0500
Subject: Re: Oracle RAC listener on a 2nd network
From: jeremy.schneider@xxxxxxxxxxxxxx
To: development@xxxxxxxxxxxxxxxxx
CC: nupendra@xxxxxxxxxxx; oracle.blog3@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx

Just noticed this old thread.
FYI - I recently helped architect and manage an environment with a lot of 
databases where two networks (and multiple RAC dbs per cluster) were the 
standard for all deployments. There was a public network for client traffic but 
data guard traffic went over a backup network. I believe our internal processes 
were based on the note Raj mentioned [1063571.1]. This was all on 11.2.0.3 with 
recent PSUs applied and it works very well.

There's only one problem that I remember. When adding a new node to a cluster, 
the root.sh script which adds the node can't handle the extra network and 
fails.  It creates the second network but doesn't add the VIP, then attempts to 
start the vips which fails.  The workaround I found was to open a second 
terminal window and run the following command while root.sh is running:

srvctl add vip -n <NODENAME> -A <NODE-BVIP-IP>/255.255.254.0 -k 2

Other than that, the second network worked great for us on 11gR2.  It's all 
managed by the GI clusterware so failover, listeners, etc work as they should.

-Jeremy

--
http://about.me/jeremy_schneider




On Wed, Apr 23, 2014 at 1:27 AM, Martin Bach <development@xxxxxxxxxxxxxxxxx> 
wrote:

You are welcome.



When I started putting my notes on WordPress I realised that the post's length 
got out of hand a bit. Next pieces to follow end of the week and next week. I 
had all of this written down in February but haven't come around posting it.




Martin

-- 

Martin Bach

Enkitec

martincarstenbach.wordpress.com
                                          

Other related posts: