java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionP oolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor ODI-1414: Error connecting to agent Internal: a JDBC error occurs while connecting to the master repository. Caused By: 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.UniversalConnectionP oolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Oracle Community | WAQ28 | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Running scenario from CMD

    Oracle Community | 3 years ago | WAQ28
    java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionP oolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor ODI-1414: Error connecting to agent Internal: a JDBC error occurs while connecting to the master repository. Caused By: 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.UniversalConnectionP oolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

    Root Cause Analysis

    1. org.springframework.jdbc.CannotGetJdbcConnectionException

      Could not get JDBC Connection; nested exception is java.sql.SQLException: Except ion occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: List ener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

      at org.springframework.jdbc.datasource.DataSourceUtils.getConnection()
    2. Spring Framework
      SqlQuery.execute
      1. org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
      2. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:524)
      3. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:588)
      4. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:613)
      5. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:645)
      6. org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:111)
      7. org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:121)
      8. org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:136)
      8 frames
    3. oracle.odi.core
      OdiInstance.createMasterRepository
      1. oracle.odi.core.repository.support.RepositoryUtils$RepositoryInfoSource.loadRepositoryInfo(RepositoryUtils.java:182)
      2. oracle.odi.core.repository.support.RepositoryUtils.loadMasterRepositoryInfo(RepositoryUtils.java:376)
      3. oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:78)
      4. oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:492)
      4 frames