oracle odi 资料档案库访问期间出现未分类的异常错误,ODI11g问题汇总

其它用户无法连接工作资料库，Network Adapter could not establish the connection

报错信息：

oracle.odi.core.config.WorkRepositoryResourceFailureException:

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: 获取连接时出现异常错误: oracle.ucp.UniversalConnectionPoolException: 无法从数据源获取连接: java.sql.SQLRecoverableException: IO 错误: The Network Adapter could not establish the connection

at oracle.odi.core.repository.Repository.getWorkRepository(Repository.java:155)

at oracle.odi.core.OdiInstance.createWorkRepository(OdiInstance.java:504)

at oracle.odi.core.OdiInstance.(OdiInstance.java:581)

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

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

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

at http://www.doczj.com/doc/b16c56bf65ce050876321318.htmlng.Thread.run(Thread.java:662)

Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: 获取连接时出现异常错误: oracle.ucp.UniversalConnectionPoolException: 无法从数据源获取连接: java.sql.SQLRecoverableException: IO 错误: 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 :180)

at oracle.odi.core.repository.support.RepositoryUtils.loadWorkRepositoryInfo(RepositoryUtils.java:380) at oracle.odi.core.repository.Repository.getWorkRepository(Repository.java:153)

at oracle.odi.core.OdiInstance.createWorkRepository(OdiInstance.java:505)

... 5 more

Caused by: java.sql.SQLException: 获取连接时出现异常错误: oracle.ucp.UniversalConnectionPoolException: 无法从数据源获取连接: java.sql.SQLRecoverableException: IO 错误: The Network Adapter could not establish the connection

at