Connecting ADS to Oracle RAC using connection string
Article ID: KB0082862
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | ALL VERSIONS |
Description
Connecting ADS to Oracle RAC using connection string
Issue/Introduction
Connecting ADS to Oracle RAC using connection string
Resolution
Please follow below mentioned steps:
Alter the data source’s JDBC connect string format (in the Advanced tab).
From: jdbc:oracle:thin:@<HOST>:<PORT>:<DATABASE_NAME>
To: jdbc:oracle:thin:@<HOST>
When prompted for the connection information, put the TNS name or connect string in the host field and leave Port and Service name blank. In your case the connect string will look like:
(DESCRIPTION_LIST=(FAILOVER=on)(LOAD_BALANCE=off)(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(DESCRIPTION=(CONNECT_TIMEOUT=5) (TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS= (PROTOCOL=TCP) (HOST= mars-cn.edc.nam.gm.com) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=mars.world)))(DESCRIPTION=(CONNECT_TIMEOUT=5) (TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS= (PROTOCOL=TCP) (HOST= mars_d1m-cn.edc.nam.gm.com) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=mars.world))))
Alter the data source’s JDBC connect string format (in the Advanced tab).
From: jdbc:oracle:thin:@<HOST>:<PORT>:<DATABASE_NAME>
To: jdbc:oracle:thin:@<HOST>
When prompted for the connection information, put the TNS name or connect string in the host field and leave Port and Service name blank. In your case the connect string will look like:
(DESCRIPTION_LIST=(FAILOVER=on)(LOAD_BALANCE=off)(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(DESCRIPTION=(CONNECT_TIMEOUT=5) (TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS= (PROTOCOL=TCP) (HOST= mars-cn.edc.nam.gm.com) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=mars.world)))(DESCRIPTION=(CONNECT_TIMEOUT=5) (TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS= (PROTOCOL=TCP) (HOST= mars_d1m-cn.edc.nam.gm.com) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=mars.world))))
Feedback
Yes
No
Powered by
