blocks|key|1615382|text|在OTL中有一个set_timeout应用程序接口可能对此很有用。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1615383|编辑:实际上，忽略它。set_timeout不适用于保险业监管局。看一下来自here的set_timeout描述，它描述了一种可以与OCI一起使用的技术。|1615384|entityMap|0|LINK|mutability|MUTABLE|url|http://otl.sourceforge.net/otl3_connect_class.htm^0|8|B|0|B|B|17|B|12|4|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@$9|X|A|Y|1|Z]]|E|$]]|$1|H|3|-4|5|6|7|10|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

There's a <code>set_timeout</code> API in OTL that might be useful for this.

Edit: Actually, ignore that. <code>set_timeout</code> doesn't work with OCI. Have a look at the <code>set_timeout</code> description from <a href="http://otl.sourceforge.net/otl3_connect_class.htm" rel="nofollow noreferrer">here</a> where it describes a technique that can be used with OCI

blocks|key|1501000|text|有一种手动方法可以避免这种情况。您可以打开防火墙，在每隔一段指定的时间后对数据库执行ping之类的操作。这样，数据库连接就不会丢失。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1501001|想法|1501002|If+(current_time+-+lastPingTime+>+configuredPingTime)
{
+++++//Dummy+query
+++++select+1+from+dual;
}|code-block|syntax|javascript|1501003|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

There is a manual way to avoid this. You can open a firewall and do something like ping database after every specified duration of time. In this way the database connection will not get lost. 

idea

<pre><code>If (current_time - lastPingTime &gt; configuredPingTime)
{
 //Dummy query
 select 1 from dual;
}
</code></pre>

blocks|key|313922|text|在我的所有DB模式中，我都有一个表，其中包含一个常量记录。只需通过简单SQL请求定期轮询此类表即可。所有其他方法都不可靠。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|313923|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In all my DB schema i have a table with one constant record. Just poll such table periodically by simple SQL request. All other methods unreliable.

blocks|key|313945|text|听起来你需要向数据库发起一个查询(例如SELECT+*+FROM+dual;)，那么如果数据库在指定的时间内没有响应，就假设服务器已经死了并做出相应的反应。恐怕我不懂C/C%2B%2B，但是你能不能使用多线程来触发语句，然后等待响应，而不会挂起应用程序？|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|313946|entityMap^0|J|J|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Sounds like you need to fire off a query to the database (eg <code>SELECT * FROM dual;</code>), then if the database hasn't responded within a specified amount of time, assume the server has died and react accordingly. I'm afraid I don't know C/C++, but can you use multi-threading to fire off the statement then wait for the response, without hanging the application?

blocks|key|1613650|text|这是可行的--我已经做了你想要的。让父进程(A)创建子进程(B)。子进程(B)连接到数据库，执行查询(类似于"select+1FROM+a_table“-如果您避免使用"dual”并创建自己的表，您将获得更好的性能)。如果(B)成功，则写出成功并退出。(A)正在等候一段指明的时间。我用了15秒。如果(A)检测到(B)仍在运行-那么它可以假定数据库已挂起-它将杀死(B)并采取必要的操作(如通过SMS在电话上呼叫我)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1613651|如果将SQL*NET配置为使用超时，您可能会注意到大型查询将因此而失败。OCI+set_timeout配置也会导致这种情况。|1613652|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

This works - I have done exactly what you are looking for.
Have a parent process (A) create a child process (B). The child process (B) connects to the database,
performs a query (something like "select 1 from a_table" - you will get better performance if you avoid using "dual" for this and create your own table). If (B) is successful then it writes out that it was successful and exits. (A) is waiting for a specified amount of time. I used 15 seconds. If (A) detects that (B) is still running - then it can assume that the database is hung - it Kills (B) and takes necessary actions (Like calling me on the phone with a SMS).

If you configure SQL*NET to use a timeout you will probably notice that large queries will fail because of it. The OCI set_timeout configuration will also cause this.

blocks|key|95962|text|这是Oracle+11.1.0.6之前的一个bug+(或者称之为特性)，他们说Oracle+11g+release+1(+patch+11.1.0.7+)上的补丁已经修复。我需要看到这一点。如果发生这种情况，您将不得不取消(杀死)执行此操作的线程。尽管不是一个好的方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|95963|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

This is a bug in Oracle ( or call it a feature ) till 11.1.0.6 and they said the patch on Oracle 11g release 1 ( patch 11.1.0.7 ) which has the fix. Need to see that.
If it happens you will have to cancel ( kill ) the thread performing this action. 
Not good approach though

In our server/client-setup we're experiencing some weird behaviour. The client is a C/C++-application which uses OCI to connect to an Oracle server (using the <a href="http://otl.sourceforge.net" rel="nofollow noreferrer">OTL</a> library).

Every now and then the DB server dies in a way (yes this is the core issue, but from application-side we're unable to solve it but have to deal with it anyway), that the machine does not respond anymore to new requests/connections but the existing ones, like the Oracle-connections, do not drop or time out. Queries sent to the DB just never return successfully anymore.

What possibilities (if any) are provided by Oracle to detect these stalled connections from the client-application side and recover in a more or less safe way?

How to detect Oracle broken/stalled connection?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

在我们的服务器/客户端设置中，我们遇到了一些奇怪的行为。客户机是一个C/C++应用程序，它使用OCI连接到Oracle服务器(使用库)。每隔一段时间，DB服务器就会以某种方式崩溃(是的，这是核心问题，但从应用程序端看，我们无法解决它，但无论如何都必须处理它)，即机器不再响应新的请求/连接，但现有的请求/连接，如Orac...

问如何检测Oracle中断/停滞的连接？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何检测Oracle中断/停滞的连接？EN