java 连接 orcale 异常

[beijingnanhai]

使用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_876

tnsnames.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)

[wori011]

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

看看这个

[梁林張斌]

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

[小德]

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

是不是不一样？

[iqlife]

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

[yanka_sky]

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)
)
)

[chen_19821119]

[Quote=引用 5 楼 yanka_sky 的回复:]
ADDRESS = (PROTOCOL = TCP)(HOST = 132.04.132.70)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 132.04.132.75)(PORT = 1521))
怎么会有两个HOST呢？这里应该有问题吧！我连接成功了，我的tnsnames.ora中的给你参考一下：
HCDC =
(DESCRIP……
[/Quote]

估计是这个原因。

[slowtown]

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

[小青蛙]

我还没有遇到这样的问题，但可以尝试楼上的方法

[d604060189]

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

[石野]

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

希望能帮到你

[阳光草丛下的兔子]

[Quote=引用 6 楼 slowtown 的回复:]
字符写错了
jdbc.jdbcUrl = jdbc:oracle:thin:@132.04.132.75:1521:CUHFBD
与下面的
CUJFBD要保持一致
[/Quote]

这个。。。。。

[Rotel-刘志东]

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

[James890116]

重启下数据库的监听就OK了