Re: Connecting to RAC on a different network than the one on which VIP is set up
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Mon, 23 Mar 2009 17:44:42 -0500
Message-ID: <HfUxl.22822$Ws1.5948_at_nlpi064.nbdc.sbc.com>
pknayar_at_gmail.com wrote:
> Hi,
> I am trying to set up Streams in Oracle 11g between two RAC
> databases. Unfortunately the connectivity between the two databases
> is on a different network than the one on which the VIP is set up. In
> doing sqlplus from one to the other on this other (management)
> network, I get these sessions sometimes which just hang for a long
> time before timing out. Doing an strace on the sqlplus session shows
> that the connection gets redirected from one node in the remote
> cluster to the other, but the address that is returned is the VIP
> address. Is there a way to get around this?
>
> Thanks
> Pradeep
Date: Mon, 23 Mar 2009 17:44:42 -0500
Message-ID: <HfUxl.22822$Ws1.5948_at_nlpi064.nbdc.sbc.com>
pknayar_at_gmail.com wrote:
> Hi,
> I am trying to set up Streams in Oracle 11g between two RAC
> databases. Unfortunately the connectivity between the two databases
> is on a different network than the one on which the VIP is set up. In
> doing sqlplus from one to the other on this other (management)
> network, I get these sessions sometimes which just hang for a long
> time before timing out. Doing an strace on the sqlplus session shows
> that the connection gets redirected from one node in the remote
> cluster to the other, but the address that is returned is the VIP
> address. Is there a way to get around this?
>
> Thanks
> Pradeep
This is a POSSIBLLY sounds like your DNS may not be set up correctly. You may try making sure that ALL IP addresses associated with both environments should be entered in /etc/hosts so the lookups may succeed. Received on Mon Mar 23 2009 - 17:44:42 CDT