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

问题描述

尝试使用瘦 jdbc 驱动程序在 Red Hat Linux(64 位)上连接到 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. 数据库服务器或侦听器有问题.为您的会话提供服务的处理程序在打开后可能会崩溃.

检查以下 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屋！