Friday, January 24, 2014
ODI often uses jdbc thin driver to connect to all the data sources especially Oracle data sources. With widely prevalent Oracle RAC clusters implementations its helpful to have the URL format handy when trying to connect to one of these RAC beasts. You should obtain Hostname, Port and Service Name from your DBA.
Example: jdbc:oracle:thin:@//dbhostname:portnumberhere/servicenamehere
Please see this StackOverflow link for more little more clarity
jdbc:oracle:thin:@//<HOST>[:PORT]/<SERVICE NAME>
Example: jdbc:oracle:thin:@//dbhostname:portnumberhere/servicenamehere
Please see this StackOverflow link for more little more clarity
Contributing author: Kiran Bokam
