oracle ORA-12560: TNS: 协议适配器错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3607172/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
ORA-12560: TNS:protocol adapter error
提问by Joseph
we have a dot net application and it connecting to Oracle and fetching data and moving to SQL server. it was working very fine. just started giving error ORA-12560: TNS:protocol adapter error. Tnsping also giving this error. but if i stop this application and tnsping then its success. again starting the application on the first 10 minutes its working perfectly and gain giving same error. every 5 seconds this application connecting to Oracle databse.
我们有一个 dot net 应用程序，它连接到 Oracle 并获取数据并移动到 SQL 服务器。它工作得很好。刚开始出现错误ORA-12560: TNS:protocol adapter error。Tnsping 也给出了这个错误。但如果我停止这个应用程序和 tnsping 那么它的成功。再次在前 10 分钟启动应用程序，它可以完美运行并获得相同的错误。每 5 秒此应用程序连接到 Oracle 数据库。
any idea what is this error; and how to resolve. there is lots of questions over here,but didnt find a soulution .
知道这是什么错误；以及如何解决。这里有很多问题，但没有找到解决方案。
highly appreciate your comments against this query
非常感谢您对此查询的评论
回答by Alexander Malakhov
It seems you have some sort of resource leak. Do you close connections properly ?
看来你有某种资源泄漏。您是否正确关闭了连接？
Also, as arsaid in comment, why don't you just keep this connection open ? IIRC Establishing conn is costly operation in any DBMS.
另外，正如ar在评论中所说，你为什么不保持这个连接打开？IIRC 在任何 DBMS 中建立连接都是昂贵的操作。
Also, from documentation:
此外，从文档：
ORA-12560 -- TNS:protocol adapter error
Cause: A generic protocol adapter error occurred.
Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and reexecute the operation. Turn off tracing when the operation is complete.
ORA-12560 -- TNS:protocol adapter error
原因：发生通用协议适配器错误。
操作：检查用于正确协议规范的地址。在报告此错误之前，请查看错误堆栈并检查较低级别的传输错误。有关更多详细信息，请打开跟踪并重新执行操作。操作完成后关闭跟踪。
UPDATE:
Problem could be caused by overflow of Windows event journal. Check Oracle's events here:
Start menu => Control Panel => Administrative Tools => Event Viewer
You should either clear journal manually or increase its' size
更新：
问题可能是由 Windows 事件日志溢出引起的。在此处检查 Oracle 的事件：
开始菜单 => 控制面板 => 管理工具 => 事件查看器
您应该手动清除日志或增加其大小
