Wednesday, August 04, 2010

How to Setup RAC database Adapter in OVD ?

Select Custom URL then

-> Select Database : Oracle Thin or OCI

-> Driver name

-> URL
if it is oci then replace with oci else remove <> .

jdbc:oracle::@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=ankit1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=ankit2)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=mydb)(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))

No comments: