Re: Long connect time when one node in RAC goes down

From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Tue, 2 Sep 2008 20:15:11 -0400
Message-ID: <74f79c6b0809021715y4be0ebf0saa2bd3e7a7df339f@mail.gmail.com>


Adar,

Did you read note 226880.1, which has step by step instructions in how to set up TAF? It explains what local_listener and remote_listener is used for and should fix your problem. I've never had a problem with a setup when following that note.

Finn

On Tue, Sep 2, 2008 at 6:30 PM, freek D'Hooge <freek.dhooge_at_uptime.be>wrote:

> Hi,
>
> Can you post the output of the lsnrctl status command?
> What I would like to see is which ip address is used by an instance to
> registrate to the remote listener. It could be that your session was
> connection at node 1, but was redirected to node 2 (due to server load
> balancing), but was given the real address of node 2 instead of the vip
> address.
>
> Controlling which ip will be used (real or vip) is done via the
> local_listener parameter.
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 02 2008 - 19:15:11 CDT

Original text of this message