Oracle数据提供商钉IIS工作进程时，网站已停止 [英] Oracle data provider pegs IIS worker process when web site is stopped
问题描述
我们正在经历的Oracle 11g第2版，其中w3wp进程接管并全部处理器核心和调试表明，Oracle数据提供者无限投掷ThreadAbortExceptions一个讨厌的问题。开发人员通过执行以下操作发现此问题：
We're experiencing a nasty issue in Oracle 11g Release 2 where the w3wp process takes over and entire processor core, and debugging shows that the Oracle data provider is throwing ThreadAbortExceptions infinitely. A developer found this issue by doing the following:
1）浏览使用Oracle数据连接本地（HTTP网站：//本地主机/ OracleWebSite - 我们使用IIS，而不是ASP.NET开发服务器，为我们所有的网站）。这确保了w3wp进程正在运行，并且连接的积极甲骨文池的应用程序池的存在。
1) Browse a web site that uses Oracle data connections locally (http://localhost/OracleWebSite - we use IIS, not the ASP.NET dev server, for all of our sites). This ensures that the w3wp process is running and that an active Oracle pool of connections exists in the app pool.
2）停止该网站（或执行重建上有问题的网站在Visual Studio所有操作）。
2) Stop the web site (or perform a Rebuild All operation in Visual Studio on the web site in question).
我们的Oracle连接在受影响的应用（所有Oracle Web应用程序）的处理是行之有效的和健壮。如果禁用连接池不会发生此问题。此问题不会在发生甲骨文11g第1版。
Our Oracle connection handling in the affected applications (all Oracle web apps) is well-established and robust. This issue does not occur if we disable connection pooling. This issue does not occur in Oracle 11g Release 1.
推荐答案
这已得到解决。的修补程序发布的Oracle 11.2.0.1.2，这是可以通过oracle.com网站。
This has been resolved. The fix is released in Oracle 11.2.0.1.2, which is available through the oracle.com website.
不幸的是，修复目前只能通过My Oracle Support的帐号。
Unfortunately the fix is currently only available through a "My Oracle Support" account.
这已被固定在11.2.0.2和补丁9966926的Oracle 11g 11.2.0.1修补程序5 BUG的Windows（64位AMD64和Intel EM64T）。
This has been fixed in 11.2.0.2 and in Patch 9966926 ORACLE 11G 11.2.0.1 PATCH 5 BUG FOR WINDOWS (64-BIT AMD64 AND INTEL EM64T).
或替代方法：是加入自我调整= false以连接字符串来禁用自我调整。
Or WORKAROUND: is to disable self tuning by adding "Self Tuning=false" to the connection string.
这篇关于Oracle数据提供商钉IIS工作进程时，网站已停止的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
