java.sql.SQLException: 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

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

    ODI-10182 error while deploying ODI code through command line.

    Oracle Community | 2 years ago | 988813
    java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
  3. 0

    Odi Topology Restore - 11.1.1.7.0

    wpthm.com | 1 year ago
    java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Login failed for user 'XXXXXXX'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    db:: 3.65::How to connect MS sql server using ODI 78

    hivmr.com | 8 months ago
    java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Login failed for user 'XXXXXXX'.
  6. 0

    SAXException while including another schema

    Oracle Community | 6 years ago | 615786
    java.sql.SQLException: A SAXException was caught while reading the model saying An IOException occured while including another schema saying The filename, directory name, or volume label syntax is incorrect

    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. java.sql.SQLException

      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

      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection()
    2. oracle.odi.jdbc
      LoginTimeoutDatasourceAdapter.getConnection
      1. oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
      2. oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
      2 frames
    3. Spring Framework
      SqlQuery.execute
      1. org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
      2. org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
      3. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:524)
      4. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:588)
      5. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:613)
      6. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:645)
      7. org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:111)
      8. org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:121)
      9. org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:136)
      9 frames
    4. oracle.odi.core
      RepositoryUtils.loadMasterRepositoryInfo
      1. oracle.odi.core.repository.support.RepositoryUtils$RepositoryInfoSource.loadRepositoryInfo(RepositoryUtils.java:182)
      2. oracle.odi.core.repository.support.RepositoryUtils.loadMasterRepositoryInfo(RepositoryUtils.java:377)
      2 frames