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:
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.
The two formats accepted with the oracl.jdbc.OracleDriver are the following :
So you can probably address your problem with the second latter if the OCI driver doesn't impact the performance.
Hope it helps.