Friday 6 August 2010

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

No comments: