My Oracle Support Banner

ODI Repository Connection Error "A login timeout occured while connecting to the database" with "TNS-12537: TNS:connection closed" (Doc ID 2613333.1)

Last updated on DECEMBER 18, 2019

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to connect to an Oracle Data Integrator (ODI) repository, the following message occurs:

oracle.odi.core.config.WorkRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.
Could not get JDBC Connection; nested exception is oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database
  at oracle.odi.core.repository.Repository.getWorkRepository(Repository.java:195)
  at oracle.odi.core.OdiInstance.createWorkRepository(OdiInstance.java:531)
  at oracle.odi.core.OdiInstance.(OdiInstance.java:678)
  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 oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database
  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.loadWorkRepositoryInfo(RepositoryUtils.java:382)
  at oracle.odi.core.repository.Repository.getWorkRepository(Repository.java:174)
  ... 7 more

At the same time, the following message is written to the database alert.log:

 

TNS-12537: TNS:connection closed
  ns secondary err code: 12560
  nt main err code: 0
  nt secondary err code: 0
  nt OS err code: 0
opiodr aborting process unknown ospid (<PROCESS_ID>) as a result of ORA-609

Changes

Database listener logging level may have been increased.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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