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

Solutions on the web22638

  • via Oracle Community by WAQ28, 1 year ago
    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
  • via Oracle Community by 969237, 1 year ago
    Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: 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
  • via Oracle Community by e8df1d81-c105-439a-8cdb-bac14ee0d141, 11 months ago
    Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: 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
  • Stack trace

    • 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 at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:100) at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:491) at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:544) at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:521) at oracle.odi.StartScen.run(StartScen.java:201) at oracle.odi.StartScen.main(StartScen.java:343) Caused by: 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(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.loadMasterRepositoryInfo(RepositoryUtils.java:376) at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:78) at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:492)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 11 months ago
    5 times, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    2 times, 1 year ago
    Once, 1 year ago
    9 more bugmates