Oracle 11g连接重置错误 [英] Oracle 11g connection reset error

问题描述

在使用瘦jdbc驱动程序尝试连接到Red Hat Linux上的Oracle 11g时，看到以下错误。如果有人能够更多地了解如何对此进行故障排除，我们将非常感激。

Am seeing the below error while trying to connect to Oracle 11g on Red Hat Linux, 64-bit using thin jdbc drivers. Would highly appreciate if anyone can throw more light on how to go about troubleshooting this.

 Caused by: java.net.SocketException: Connection reset
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
    at oracle.net.ns.DataPacket.send(DataPacket.java:199)
    at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:211)
    at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:227)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
    at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)
    at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1122)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1099)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:288)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)
    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366)

推荐答案

您没有包含问题的任何细节，例如更改了什么？这是您的新配置还是突然停止工作？你知道你有足够的连接吗？这是发生在每个连接上还是间歇性的？

You didn't include any details of the problem like what changed? Is this a new configuration for you or did it suddenly stop working? Do you know if you have enough connections available? Does this happen to every connection or is it intermittent?

考虑到登录过程中发生的错误，有几种可能性：

Considering the error is occurring during the logon process, a few possibilities are:

1. 网络故障


2. 您已经用尽了最多的连接数，因此Oracle会挂断您。


3. 防火墙限制


4. 数据库服务器或侦听器出现问题。处理会话的处理可能会在打开后崩溃。

1. Network fault
2. You have exhausted the maximum # of connections, so Oracle hangs up on you.
3. Firewall restrictions
4. A problem with the database server or the listener. The processing serving your session could be crashing after it's opened.

检查以下stackoverflow线程，了解如何检查活动连接数和最大如果那是问题，我会期望ORA-00018：超过最大会话数错误，所以可能不是。但是值得检查。

Check the following stackoverflow thread about how to check the number of active connections and the max. I would expect an "ORA-00018: maximum number of sessions exceeded" error if that were the problem, so it may not be. But it's worth checking.

如何检查允许连接到Oracle数据库的最大数量？

这篇关于Oracle 11g连接重置错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！