SQL DEVELOPER AND TAF

1. Make sure You have install Oracle Client with OCI ( To check OCI –Search OCI.dll in client installed folderè it should be here "C:\Oracle\product\11.1.0\client_1\BIN")
   
2. In Database Connection window , user "Connection Type" = "Advance".
   
3. It will open "Custome JDBC URL" Box.
   
4. Type Below connection string as per your environment:
   

   
    

   jdbc:oracle:oci:@(DESCRIPTION =
   

   (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
   

   (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
   

   (LOAD_BALANCE = ON)
   

   (CONNECT_DATA =
   

   (SERVER = DEDICATED)
   

   (SERVICE_NAME = bsquat)
   

   (FAILOVER_MODE =
   

   (TYPE = SELECT)
   

   (METHOD = BASIC)
   

   (RETRIES = 180)
   

   (DELAY = 5)
   

   )
   

   )
   

   )
   

   
    

   
    

5. Test + Save + Try !!
   
6. Job Done !!!