Hello All,
I am trying to connect ODI studio to ODI repository but getting a Network Adapter error.
I can connect to the master repository. I can connect to the DB with the same username and password.Ping the server etc.
Do I need Oracle Client on the machine that is running ODI Studio ? SQL Dev connects just fine.
Version of ODI Studio 12.2.1.2.6
Here is the error message:
oracle.odi.core.config.WorkRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.
Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.odi.core.repository.Repository.getWorkRepository(Repository.java:221)
at oracle.odi.core.OdiInstance.createWorkRepository(OdiInstance.java:614)
at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:889)
at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:719)
at oracle.odi.ui.docking.panes.OdiCnxFactory$2.run(OdiCnxFactory.java:245)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
at java.lang.Thread.run(Thread.java:748)
any help/pointers will be greatly appreciated.
Thanks!