Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Not able to connect to ODI repository

Pavan8uJul 8 2019 — edited Aug 16 2019

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

Comments
Post Details