10 Replies Latest reply on Aug 16, 2019 6:42 AM by Pavan8u

    Not able to connect to ODI repository

    Pavan8u

      Hi friends,

       

      I am stuck with some strange issue.

       

      I am not able to connect to ODI repository from ODI studio. "The Network Adapter could not establish the connection"

       

      But I am able to connect to repository schema from sql developer.

       

      Could someone please help me with this issue.

       

      Error Message-

       

      oracle.odi.core.config.MasterRepositoryResourceFailureException: 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.getMasterRepository(Repository.java:115)

      at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:569)

      at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:772)

      at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:659)

      at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:611)

      at oracle.odi.ui.docking.panes.OdiCnxFactory$1.run(OdiCnxFactory.java:223)

      at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:947)

      at java.lang.Thread.run(Thread.java:745)

      Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: 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 org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:524)

      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:588)

      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:613)

      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:645)

      at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:111)

      at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:121)

      at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:136)

      at oracle.odi.core.repository.support.RepositoryUtils$RepositoryInfoSource.loadRepositoryInfo(RepositoryUtils.java:287)

      at oracle.odi.core.repository.support.RepositoryUtils.loadMasterRepositoryInfo(RepositoryUtils.java:481)

      at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:92)

      ... 7 more

      Caused by: 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.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)

      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)

      at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)

      at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)

      ... 17 more

      Caused by: 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.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)

      at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)

      at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1126)

      at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1030)

      at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1005)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke(Method.java:606)

      at oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$DataSourceInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:48)

      at com.sun.proxy.$Proxy17.getConnection(Unknown Source)

      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:228)

      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

      at java.util.concurrent.FutureTask.run(FutureTask.java:262)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

      ... 1 more

      Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

      at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:368)

      at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:49)

      at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:80)

      at oracle.ucp.jdbc.DriverConnectionFactoryAdapter.createConnection(DriverConnectionFactoryAdapter.java:122)

      at oracle.ucp.jdbc.oracle.OracleDriverConnectionFactoryAdapter.createConnection(OracleDriverConnectionFactoryAdapter.java:83)

      at oracle.ucp.common.Database.createPooledConnection(Database.java:268)

      at oracle.ucp.common.Cluster.create(Cluster.java:234)

      at oracle.ucp.common.Core.growBorrowed(Core.java:630)

      at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingRequests(UniversalConnectionPoolImpl.java:230)

      at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionAndValidate(UniversalConnectionPoolImpl.java:139)

      at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnectionPoolImpl.java:120)

      at oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:170)

      at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.borrowConnection(OracleJDBCConnectionPool.java:849)

      at oracle.ucp.jdbc.oracle.OracleConnectionConnectionPool.borrowConnection(OracleConnectionConnectionPool.java:82)

      at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1102)

      ... 14 more

       

      Regards,

      Pavan