Oracle错误（超出同时SESSIONS_PER_USER限制） [英] Oracle Error (exceeded simultaneous SESSIONS_PER_USER limit)

问题描述

我有一个带有Oracle数据库的.Net应用程序。尝试在我的应用程序中运行报告时收到以下错误。如果有针对此问题的修复程序，请求任何人检查并提供建议。

另请注意，我已经和我的DBA交谈了，他说.Net代码中有些东西没有结束会话。



错误信息是：



ORA-2391：同时超出SESSIONS_PER_USER限制



告诉我如果您需要更多信息

Hi,

I have a .Net application with Oracle database. I received the below error while trying to run a report in my application. Request anyone to check and advice if there is a fix for this problem.
Also note that I have spoken to my DBA and he says that there is something in the .Net code that is not ending the sessions.

The error message is :

ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit

Let me know if you need any more info

推荐答案

对于DB方：



查看此

错误：ORA-02391：超出了同时的SESSIONS_PER_USER限制 [ ^ ]



编码方：



您可能没有正确关闭/处置连接对象。打开连接时，应在使用后关闭。你应该正确处理对象。查看这些文章以供参考

ASP.NET - 如何正确使用（打开/关闭）连接 [ ^ ]

正确实现IDisposable和Dispose模式 [ ^ ]

ADO.NET连接池概览 [ ^ ]

For DB side:

Check this
Error: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit[^]

Coding side:

There's possibilities that you didn't close/dispose the connection object properly. When you open a connection, you should close after the use & you should dispose the objects properly. Check these articles for reference
ASP.NET - How To Use(Open/Close) Connections Correctly[^]
Implementing IDisposable and the Dispose Pattern Properly[^]
ADO.NET Connection Pooling at a Glance[^]

这篇关于Oracle错误（超出同时SESSIONS_PER_USER限制）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！