1 Reply Latest reply: Sep 26, 2012 9:50 AM by 943610 RSS

    failover callback not called when listener dies

      I need to create a RAC-aware Pro*C application.
      I got the preconfigured VirtualBox images with OL 5 and RAC nodes.
      The listener is installed on both machines too. They share a single IP address for the listener, which I added to the hosts file:   rac-scan.localdomain    rac-scan
      Actually, the cluster decides to create a virtual network adapter on one of the nodes and this address is assigned to it and then the listener becomes awailable. When this node dies, the cluster starts the listener on another node.
      I don't know, whether it's a proper way. I heard that the listener should be on a separate machine.

      But the problem is: when I turn off the node my client program is connected to, the failover callback function is not called. The next oracle operation fails with "ORA-03114: not connected to ORACLE".

      I followed http://docs.oracle.com/cd/A91202_01/901_doc/appdev.901/a89857/oci09adv.htm#428924 and https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=415245.1 to create the sample program that registers the callback.

      Could it be that the failover only works when the DB service fails, but not the listener?