"Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Unknown host specified" Error Received when Trying to Connect to New ODI 12c Work Repository (Doc ID 2468059.1)

Last updated on AUGUST 09, 2021

Applies to:

Symptoms

When attempting to connect to a newly created work repository in Oracle Data Integrator (ODI) Studio 12c, the following error occurs:

oracle.odi.core.config.WorkRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.
Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to start the Universal Connection Pool:
oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Unknown host specified
  at oracle.odi.core.repository.Repository.getWorkRepository(Repository.java:223)
  at oracle.odi.core.OdiInstance.createWorkRepository(OdiInstance.java:628)
  at oracle.odi.core.OdiInstance.(OdiInstance.java:903)
  at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:733)
  at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:681)
  at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:660)
  at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.testConnection(SnpsDialogLoginDetail.java:778)
  ...
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException:
IO Error: Unknown host specified
  at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:575)
  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:704)
  at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:112)
  at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:122)
  at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:137)
  at oracle.odi.core.repository.support.RepositoryUtils$RepositoryInfoSource.loadRepositoryInfo(RepositoryUtils.java:353)
  at oracle.odi.core.repository.support.RepositoryUtils.loadWorkRepositoryInfo(RepositoryUtils.java:557)
  at oracle.odi.core.repository.Repository.getWorkRepository(Repository.java:202)
  ... 167 more
Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Unknown host specified
  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:111)
  at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
  ... 177 more
Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Unknown host specified
  at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:456)
  at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:133)
  at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:942)
  at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1971)
  at oracle.ucp.jdbc.PoolDataSourceImpl.access$500(PoolDataSourceImpl.java:198)
  at oracle.ucp.jdbc.PoolDataSourceImpl$30.build(PoolDataSourceImpl.java:4355)
  at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1926)
  ...
Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Unknown host specified
  at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336)
  at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:59)
  at oracle.ucp.jdbc.DriverConnectionFactoryAdapter.createConnection(DriverConnectionFactoryAdapter.java:129)
  at oracle.ucp.jdbc.oracle.OracleDriverConnectionFactoryAdapter.createConnection(OracleDriverConnectionFactoryAdapter.java:85)
  at oracle.ucp.common.Database.createPooledConnection(Database.java:256)
  at oracle.ucp.common.Topology.start(Topology.java:236)
  at oracle.ucp.common.Core.start(Core.java:1800)
  at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:709)
  at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129)
  at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:938)
  ... 17 more
Caused by: java.sql.SQLRecoverableException: IO Error: Unknown host specified
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:775)
  at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:833)
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:40)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:704)
  at oracle.ucp.jdbc.DriverConnectionFactoryAdapter.createConnection(DriverConnectionFactoryAdapter.java:125)
  ... 24 more
Caused by: oracle.net.ns.NetException: Unknown host specified
  at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:210)
  at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:132)
  at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:496)
  at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:683)
  at oracle.net.ns.NSProtocol.connect(NSProtocol.java:295)
  at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1439)
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:519)
  ... 28 more

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.