使用pl/sql可以连接连接字符串
jdbc.driver = oracle.jdbc.driver.OracleDriver
jdbc.jdbcUrl = jdbc:oracle:thin:@132.04.132.75:1521:CUHFBD
jdbc.dbUser = admin
jdbc.dbPwd = admin_876tnsnames.org
CUJFBD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 132.04.132.70)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 132.04.132.75)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cujfbd)
    )
  )使用jdbc连接报异常
java.sql.SQLException: Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descript
or
The Connection descriptor used by the client was:
132.40.130.70:1521:CUJFBD        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:111)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:260)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
438)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
n.java:34)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at com.unicom.uniformdata.JDBCBase.connectToDb(JDBCBase.java:65)
        at com.unicom.uniformdata.JDBCBase.query(JDBCBase.java:83)
        at com.unicom.uniformdata.SqlExecuteServiceServiceSoapBindingImpl.syncEx
ecute(SqlExecuteServiceServiceSoapBindingImpl.java:112)
        at com.unicom.uniformdata.SqlExecuteServiceServiceSoapBindingSkeleton.sy
ncExecute(SqlExecuteServiceServiceSoapBindingSkeleton.java:93)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.j
ava:397)
        at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider
.java:186)
        at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:
323)
        at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrateg
y.java:32)
        at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
        at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
        at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454
)
        at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
        at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:69
9)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBas
e.java:327)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern
al(CharacterEncodingFilter.java:88)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:76)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
9)
        at java.lang.Thread.run(Thread.java:662)

解决方案 »

  1.   

    ORA-12505, TNS:listener does not currently know of SID given in connect descript
    or
    The Connection descriptor used by the client was:
    132.40.130.70:1521:CUJFBD看看这个
      

  2.   

       ORACLE 监听接口被占用了,在使用着,断开别的连接,或者干脆重启应用服务器,再练次就没事了。这问题很诡异,我也老遇见,重启下就没事了。
      

  3.   

    jdbc.jdbcUrl = jdbc:oracle:thin:@132.04.132.75:1521:CUHFBD
    The Connection descriptor used by the client was:
    132.40.130.70:1521:CUJFBD是不是不一样?
      

  4.   

    使用的地址错误,字符串写错了的?
    The Connection descriptor used by the client was:
    132.40.130.70:1521:CUJFBD
      

  5.   

    ADDRESS = (PROTOCOL = TCP)(HOST = 132.04.132.70)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 132.04.132.75)(PORT = 1521))
    怎么会有两个HOST呢?这里应该有问题吧!我连接成功了,我的tnsnames.ora中的给你参考一下:
    HCDC =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 4f437e52323e4bc)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = HCDC)
        )
      )
      

  6.   

    字符写错了
    jdbc.jdbcUrl = jdbc:oracle:thin:@132.04.132.75:1521:CUHFBD
    与下面的
    CUJFBD要保持一致
      

  7.   

    居然碰到同事了 , cujfbd 总部同事
      

  8.   

    这个问题我也遇到了,后来找了好久才知道是这里出问题了,可能LZ和我一样吧,可以参考!
    我的是oracle11的
    jdbc.driver = oracle.jdbc.driver.OracleDriver   这个改成下面这个
    jdbc.driver = oracle.jdbc.OracleDriver希望能帮到你
      

  9.   

    The Connection descriptor used by the client was:
    132.40.130.70:1521:CUJFBD,这块应该是客户端的ip