Re: RAC questions

  • From: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
  • To: johan.eriksson@xxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 20 Jan 2006 06:09:29 -0800 (PST)

Hi,
   
  The cluster interconnect should not be configured with Virtual IP. 
   
  Load balancing is at the connection level. So if the users disconnect and 
reconnect, they will connect to the correct node.
   
  Have found Mike Ault and Madhu Tumma's book on RAC quite informative. 
Metalink also has some useful articles.
   
  Regards
   
  Joseph Amalraj

johan Eriksson <johan.eriksson@xxxxxxxxxxxx> wrote:
  Hi all,

Our setup is oracle 10.2 on Red hat linux 3 and some connections came
from an JBoss application server.

We are testing our RAC system and it has resulted in some questions and
problems. So if anyone could explain the behaviour, point me to relevant
documentation or/and recommend the best book(s) about RAC I would be
happy man again.

The first problem we have are:
They did bring down the interface that interconnect was using on one of
the nodes while running queries on both the nodes. On node1 the query
was executed as it should and on node2 it hanged (was on this node they
disabled the network interface).

When checking with ifconfig the VIP adress from node2 had been
transferred to node1 (this is how it should work if I understand it
correctly) and on node2 the VIP was gone.

But when we bring back eth1 on node2 again nothing happens, VIP is still
on node1, we have tried to restart everything but nothing happens, node2
it still unavailible...
Should this work automatically or is it manual work that is the intended
solution?
What is the default behaviour if the interconnect goes down?




--
//www.freelists.org/webpage/oracle-l


  

Other related posts: