1 Reply Latest reply: Jun 14, 2013 3:33 AM by JeromeFr RSS

    Physical Schema - JDBC Connection - With Service Name

    989049

      Hi,

       

      We have database cluster with multiple nodes rather than a database in our project

      I have created a physical schema and have given the JDBC connection detail as:

      jdbc:oracle:thin:@//<host>:<port>/<servicename>

      and it always giving me an error message "Network adaptor could not establish the connection"

       

      But, when I gave the details in SQL Developer, I am able to connect without any issue.

       

      I would like to know, does ODI supports this format?

      Is SID a mandatory?

       

      Appreciate your help.