RE: 11.2.0.2: Why is the local listener listening on public ip?
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "adar666@xxxxxxxxxxxx" <adar666@xxxxxxxxxxxx>, "fmhabash@xxxxxxxxx" <fmhabash@xxxxxxxxx>
- Date: Mon, 15 Nov 2010 10:16:24 +0100
With server side load balancing you can control the ip that is returned to the
client by setting the local listener parameter. If you put the vip there (or in
the tnsnames alias to which you are referring to) the vip ip will be returned
to the client.
This is also best practice as in case of a node failure the client will benefit
from faster failover.
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Yechiel Adar
Sent: maandag 15 november 2010 7:07
To: fmhabash@xxxxxxxxx
Cc: Oracle L
Subject: Re: 11.2.0.2: Why is the local listener listening on public ip?
It is not a good practice to remove the public IP from the listener.
It will cause connections to fail.
When the RAC decide that one server is overloaded and the connection has
to be handled by another node,
it returns to the client with the public IP of the new node, and tell
the client to connect to this IP.
So you put only the VIP in the tnsnames, but let the listener to accept
connections on public IP.
Yechiel
On 08/11/2010 16:59, fmhabash wrote:
> This is what i got from the default install. the local listeners are
> listening on the node vip and public ip. Do we know why?and is it a
> good practice to remove the public ip?
>
> Thank you.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
