Tuesday, 13 September 2011

Updating failover URL in OIM

1.Without failover URL

In the DirectDB section use the below in the url

jdbc:oracle:thin:@IP:PORT:SERVICENAME

2.With failover URL

In the DirectDB section use the below in the url

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(FAILOVER=on)(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = IPaddressnode1)(PORT = portno))(ADDRESS = (PROTOCOL = TCP)(HOST = IPaddressnode1)(PORT = portno)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=Sevicename)))

No comments:

Post a Comment