Connecting to RAC on a different network than the one on which VIP is set up
From: <pknayar_at_gmail.com>
Date: Mon, 23 Mar 2009 12:47:09 -0700 (PDT)
Message-ID: <d2f038c3-e24f-48dd-96b0-eec73137d106_at_o11g2000yql.googlegroups.com>
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?
Date: Mon, 23 Mar 2009 12:47:09 -0700 (PDT)
Message-ID: <d2f038c3-e24f-48dd-96b0-eec73137d106_at_o11g2000yql.googlegroups.com>
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
Received on Mon Mar 23 2009 - 14:47:09 CDT