Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Unable to login in ODI in OBIA 11.1.1.9.2.0
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 |
Answers
-
Hi Sonu,
You able to log-in with the odi schema at the back-end (via sql developer or something) ?
Regards,
M
0 -
Hi
ODI is not able to connect to the schema in your database, it could be one of these reasons
1. Database server is down or listener is down
2. Passwords expired
3. Hostname or JDBC connection string is incorrect in the ODI login page
4. Incorrect schema name or password
Thanks
AA
0 -
Hi,
Please ensure that the steps mentioned in the Oracle documentation has been successfully completed.
Refer section "Configuring User Access for ODI Studio" in the below link.
Once all the steps are successfully completed. check on the below.
1.) Check on the hosts file on the client machine on which you are configuring ODI.
2.) Open Terminal (linux ) and command Prompt in Windows and try to ping the host of ODI repository database host.
Thanks
Krishna
0
