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 The Connection descriptor used by the client was: 192.168.1.145:1521:orcl

Oracle Community | Luis_vkacito | 6 years ago
  1. 0

    Failed  to configure the generic  connector

    Oracle Community | 6 years ago | Luis_vkacito
    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 The Connection descriptor used by the client was: 192.168.1.145:1521:orcl
  2. 0

    mondrian+Jpviot页面报错 - zhangzhongzhong的博客 - 博客频道 - CSDN.NET

    csdn.net | 4 months ago
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:oracle:thin:@localhost:1521:orcl; JdbcUser=cdrdw; JdbcPassword=cdrdw</span>
  3. 0

    OWSM Error

    Oracle Community | 7 years ago | 673437
    com.cfluent.utils.db.DBException: Io exception: The Network Adapter could not establish the connection
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java utils.dbping failing.

    Oracle Community | 5 years ago | MohtashimShaikh
    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 The Connection descriptor used by the client was: tamldbp02.mybank.net:4601:demo
  6. 0

    How to set the timezone region for JDBC Connection and avoid the SqlException timezone region not found?

    Stack Overflow | 2 years ago | AndreaNobili
    java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found

  1. Michael 1 times, last 4 months ago
  2. Jeremy 1 times, last 4 months ago
  3. qavid 2 times, last 5 months ago
  4. Kawada 4 times, last 6 months ago
45 unregistered visitors
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

    Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: 192.168.1.145:1521:orcl

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OracleDriver.connect
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
    4. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:460)
    5. oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411)
    6. oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
    7. oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)
    8. oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
    9. oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:474)
    9 frames
  3. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(DriverManager.java:582)
    2. java.sql.DriverManager.getConnection(DriverManager.java:154)
    2 frames
  4. Commons DBCP
    PoolableConnectionFactory.makeObject
    1. org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:51)
    2. org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
    2 frames
  5. Commons Pool
    GenericObjectPool.borrowObject
    1. org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
    1 frame
  6. Commons DBCP
    PoolingDataSource.getConnection
    1. org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
    1 frame
  7. com.thortech.xl
    CreateConnectorAction.goNext
    1. com.thortech.xl.gc.impl.common.DBFacade.getConnection(Unknown Source)
    2. com.thortech.xl.gc.impl.common.DBFacade.getMetadata(Unknown Source)
    3. com.thortech.xl.gc.impl.common.DBFacade.getDBType(Unknown Source)
    4. com.thortech.xl.gc.impl.common.DBFacade.getSchema(Unknown Source)
    5. com.thortech.xl.gc.impl.prov.DBProvisioningTransportProvider.getSchema(Unknown Source)
    6. com.thortech.xl.gc.impl.prov.DBProvisioningTransportProvider.detectMetadata(Unknown Source)
    7. com.thortech.xl.gc.impl.prov.DBProvisioningTransportProvider.defineMetadata(Unknown Source)
    8. com.thortech.xl.webclient.actions.CreateConnectorAction.getGenericAdapter(Unknown Source)
    9. com.thortech.xl.webclient.actions.CreateConnectorAction.imageScreen(Unknown Source)
    10. com.thortech.xl.webclient.actions.CreateConnectorAction.goNext(Unknown Source)
    10 frames
  8. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  9. struts
    DispatchAction.dispatchMethod
    1. org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
    1 frame
  10. com.thortech.xl
    CreateConnectorAction.execute
    1. com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(Unknown Source)
    2. com.thortech.xl.webclient.actions.tcActionBase.execute(Unknown Source)
    3. com.thortech.xl.webclient.actions.tcAction.execute(Unknown Source)
    4. com.thortech.xl.webclient.actions.CreateConnectorAction.execute(Unknown Source)
    4 frames
  11. struts
    ActionServlet.doPost
    1. org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
    2. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
    3. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
    4. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
    4 frames
  12. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    2 frames
  13. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  14. com.thortech.xl
    SecurityFilter.doFilter
    1. com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source)
    1 frame
  15. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  16. JBoss Application Server Tomcat
    ReplyHeaderFilter.doFilter
    1. org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
    1 frame
  17. Glassfish Core
    StandardContextValve.invoke
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    4 frames
  18. JBoss Application Server Tomcat
    JaccContextValve.invoke
    1. org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
    2. org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
    2 frames
  19. Glassfish Core
    ErrorReportValve.invoke
    1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    2 frames
  20. JBoss Application Server Tomcat
    CachedConnectionValve.invoke
    1. org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
    1 frame
  21. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    2. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
    2 frames
  22. Grizzly HTTP
    JIoEndpoint$Worker.run
    1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
    3 frames
  23. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:619)
    1 frame