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
  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
  2. 0

    ODI-10182: Uncategorized exception during repository access.

    Oracle Community | 4 years ago | user10958385
    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
  3. 0

    ODI-10182: Uncategorized exception during repos... | Oracle Community

    oracle.com | 1 year ago
    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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Unable to Connect to RAC DB when deployed in Weblogic Server

    Stack Overflow | 1 year ago | sunil gogula
    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: Exception occurred while enabling failover with remote ONS subscription
  6. 0

    Database connectivity issue of Mule application with mysql database in linux environment

    Stack Overflow | 8 months ago | JavaStack
    org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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