Posted by : Arjun Lagisetty 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.

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

Leave a Reply

Subscribe to Posts | Subscribe to Comments

Popular Post

Labels

Blog Archive

Copyright © ODI Pundits - Oracle Data Integrator - Maintained by Arjun Lagisetty