Hello Gurus,
I have installed OBIA 11.1.1.9.2.0, Few days back, able to login in ODI, but now I am not . All services including OPMN/bi_server, odi_server1all are up and running fine.Below log attached when trying to login in ODI 11g
Kindly help me to resolve this issue.
Log:-
| 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:100) |
| at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:518) |
| at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:641) |
| at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:609) |
| at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:548) |
| at oracle.odi.ui.docking.panes.OdiCnxFactory$1.run(OdiCnxFactory.java:203) |
| at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655) |
| at java.lang.Thread.run(Thread.java:662) |
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:182) |
| at oracle.odi.core.repository.support.RepositoryUtils.loadMasterRepositoryInfo(RepositoryUtils.java:376) |
| at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:78) |
| ... 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:133) |
| at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62) |
| 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:943) |
| at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:873) |
| at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:863) |
| at sun.reflect.GeneratedMethodAccessor80.invoke(Unknown Source) |
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) |
| at java.lang.reflect.Method.invoke(Method.java:597) |
| at oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$DataSourceInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:48) |
| at com.sun.proxy.$Proxy0.getConnection(Unknown Source) |
| at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:217) |
| at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) |
| at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) |
| at java.util.concurrent.FutureTask.run(FutureTask.java:138) |
| at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) |
| at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) |
| ... 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.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.createOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1641) |
| at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.access$600(UniversalConnectionPoolImpl.java:1477) |
| at oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnection(UniversalConnectionPoolImpl.java:545) |
| at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.createOnePooledConnection(OracleJDBCConnectionPool.java:129) |
| at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingRequests(UniversalConnectionPoolImpl.java:333) |
| at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionAndValidate(UniversalConnectionPoolImpl.java:162) |
| at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnectionPoolImpl.java:143) |
| at oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:157) |
| at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:931) |
| ... 14 more |
