ORA-12560: TNS: 协议适配器错误
我们有一个 dot net 应用程序，它连接到 Oracle 并获取数据并移动到 SQL Server。它工作得很好。刚刚开始出现错误 ORA-12560: TNS:protocol 适配器错误 。 tnsping 也给出这个错误。但如果我停止这个应用程序和 tnsping 那么它就成功了。再次在前 10 分钟启动应用程序，它运行良好，但出现同样的错误。该应用程序每 5 秒连接一次 Oracle 数据库。
知道这个错误是什么吗？以及如何解决。这里有很多问题，但没有找到解决方案。
非常感谢您对此查询的评论
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.
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
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
看来你有某种资源泄漏。您是否正确关闭连接？
另外，正如 ar 在评论中所说，为什么不保持此连接打开呢？ IIRC 在任何 DBMS 中建立 conn 都是昂贵的操作。
另外，来自文档：
ORA-12560 -- TNS：协议适配器错误
原因：发生通用协议适配器错误。
操作：检查用于正确协议规范的地址。在报告此错误之前，请查看错误堆栈并检查是否存在较低级别的传输错误。有关更多详细信息，请打开跟踪并重新执行该操作。操作完成后关闭跟踪。
更新：
问题可能是由 Windows 事件日志溢出引起的。在此处查看 Oracle 的活动：
开始菜单=>控制面板=>管理工具 =>事件查看器
您应该手动清除日志或增加其大小
It seems you have some sort of resource leak. Do you close connections properly ?
Also, as ar said in comment, why don't you just keep this connection open ? IIRC Establishing conn is costly operation in any 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.
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