This discussion is archived
2 Replies Latest reply: Dec 20, 2012 5:59 AM by LaserSoft RSS

FAN - Fast Aplication Notification, ERROR in FAN Feature

980807 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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

Legend

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