1 Reply Latest reply: May 21, 2013 2:24 PM by Balazs Papp RSS

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

    KevinBong
      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
          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