This discussion is archived
1 Reply Latest reply: May 21, 2013 12:24 PM by Balazs Papp RSS

Oracle RAC VIP is not answering when it fails over to another node

871385 Newbie
Currently Being Moderated
Have you seen this situation with Oracle RAC?

Three node system. RAC 1 is down and RAC 2 and 3 is up. The Oracle VIP for Node 1 fails over to Node 3. When you go to a client server and do a tnsping to the rac 1 VIP address, it answers no listener. It's the VIP address and not the physical IP address. Is there something missing on the Oracle cluster software/config for the three rac node system that is not redirecting the node 1 VIP to node 3
  • 1. Re: Oracle RAC VIP is not answering when it fails over to another node
    Balazs Papp Expert
    Currently Being Moderated
    Hi,

    Works as intended.

    a) clients (11.2) connect to the DB using the SCAN address - on the event of failover, the service is removed from the SCAN listener, so it will not forward requests to the failed VIP - No problem here.
    b) clients (pre 11.2, but works for 11.2 also of course) have a list of VIP addresses - When a client tries to connect through a failed VIP, it will immediately get the reply that there is no listener there, so it can try another address without wasting time.

    Anything else than the above is not a proper HA configuration.

    Pre 11.2:

    http://docs.oracle.com/cd/B28359_01/server.111/b28282/configbp003.htm#CHDCFGHC

    "A VIP address is an alternate public address that client connections use instead of the standard public IP address. If a node fails, then *the node's VIP address fails over to another node but there is no listener listening on that VIP, so a client that attempts to connect to the VIP address receives a connection refused error (ORA-12541) instead of waiting for long TCP connect timeout messages. This error causes the client to quickly move on to the next address in the address list and establish a valid database connection.*"

    11.2:

    http://docs.oracle.com/cd/E11882_01/server.112/e10803/config_cw.htm#CEGGDIHA

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points