2 Replies Latest reply: Dec 20, 2012 7:59 AM by LaserSoft RSS

    FAN - Fast Aplication Notification, ERROR in FAN Feature

    980807
      Dear,

      I am implementing the FAN (Fast Application Notification) feature available in Oracle RAC and am following the Oracle documentation (http://docs.oracle.com/cd/E11882_01/java.112/e16548/apxracfan.htm) but the Java client does not work (not receiving notifications).

      Does anyone have an example (the program) ready and can share?

      Thank you in advance for help,

      TLange
        • 1. Re: FAN - Fast Aplication Notification, ERROR in FAN Feature
          hitgon
          http://www.idevelopment.info/data/Programming/java/jdbc/High_Availability/FastConnectionFailoverExampleThin.java
          http://www.drdobbs.com/jvm/jdbc-fast-connection-failover-with-oracl/222700353
          http://oracle-dba-yi.blogspot.in/2010/01/taf-vs-fan-vs-fcf-vs-ons.html
          • 2. Re: FAN - Fast Aplication Notification, ERROR in FAN Feature
            LaserSoft
            Hi Friend,


            We have to complete the following configurations before FAN setup.


            1. Setup your classpath, you will need ons.jar which can be obtained from your database server or an oracle client installation.

            2. You will also need the JDBC/THIN driver which is the ojdbc14.jar file.

            3. Set your properties in the file fcfcache.properties to reflect your current environment

            Example :

            onsconfig=nodes=<node1_vip>,<node2_vip>:6200
            url=jdbc:oracle:thin:@(DESCRIPTION= (LOAD_BALANCE=yes)
            *(ADDRESS=(PROTOCOL=TCP)(HOST=node1_vip)(PORT=1521))*
            *(ADDRESS=(PROTOCOL=TCP)(HOST=node2_vip)(PORT=1521))*
            *(CONNECT_DATA=(service_name=SID)))*

            Note : The most important setup here is the onsconfig property settings that specify the ONS ports on the server side.

            4. Verify Failover After Shutting Down One Node

            once a node has been shutdown the cache is notified through ONS and automatically cleans the dead/stale connections and issues connections only to the remaining alive nodes.

            Hope it helps............


            Thanks
            LaserSoft