[20190314]理解TRANSPORT_CONNECT_TIMEOUT RETRY_COUNT参数在tnsnames.ora.tx

最新推荐文章于 2022-01-18 18:43:37 发布
最新推荐文章于 2022-01-18 18:43:37 发布
阅读量719 收藏 1
点赞数

[20190314]理解LOAD_BALANCE TRANSPORT_CONNECT_TIMEOUT RETRY_COUNT参数在tnsnames.ora.txt


--//链接:https://dba010.com/2019/03/11/understanding-load_balance-parameter-in-tnsnames-ora/

--//以前也做过类似测试:http://blog.itpub.net/267265/viewspace-2199977/


TRANSPORT_CONNECT_TIMEOUT:


"The TRANSPORT_CONNECT_TIMEOUT parameter specifies the time, in seconds, for a client to establish a TCP connection to

the database server. The default value is 60 seconds." For more information, click here


RETRY_COUNT:


"To specify the number of times an ADDRESS list is traversed before the connection attempt is terminated." For more

information, click here         


--//实际上测试次数是RETRY_COUNT+1.

--//重复测试:


1.在/tmp目录下建立tnsnames.ora,内容如下:


$ export TNS_ADMIN=/tmp

$ cat tnsnames.ora

CLIENT_CON =

 (DESCRIPTION =

  (LOAD_BALANCE=ON)

   (TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=2)

   (ADDRESS = (PROTOCOL = TCP)(HOST =10.10.10.10)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =11.11.11.11)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =12.12.12.12)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =13.13.13.13)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =14.14.14.14)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =15.15.15.15)(PORT = 1522))

  (CONNECT_DATA =

     (SERVER = DEDICATED)

     (SERVICE_NAME = orclgg)

   ))


2.测试:

$ export TNS_ADMIN=/tmp

$ strace -tT -f tnsping client_con 2>&1 | grep  'connect'

$ strace -tT -f tnsping client_con 2>&1 | grep  'connect'

08:58:03 connect(4, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000033>

08:58:03 connect(4, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000033>

08:58:03 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("15.15.15.15")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000052>

08:58:06 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("12.12.12.12")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000042>

08:58:09 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("14.14.14.14")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000044>

08:58:12 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("11.11.11.11")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000041>

08:58:15 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("13.13.13.13")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000041>

08:58:18 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("10.10.10.10")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000042>


08:58:21 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("12.12.12.12")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000042>

08:58:24 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("10.10.10.10")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000041>

08:58:27 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("11.11.11.11")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000041>

08:58:30 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("14.14.14.14")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000043>

08:58:33 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("13.13.13.13")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000042>

08:58:36 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("15.15.15.15")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000041>


08:58:39 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("10.10.10.10")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000044>

08:58:42 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("12.12.12.12")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000043>

08:58:45 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("15.15.15.15")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000042>

08:58:48 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("11.11.11.11")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000040>

08:58:51 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("13.13.13.13")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000045>

08:58:54 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("14.14.14.14")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000041>


--//分成3组,也就是尝试3次.每次选择的IP不是定义的顺序(LOAD_BALANCE=ON).

--//如果连接不上,时间间隔是3秒尝试下一个.


3.修改tnsnames.ora文件(LOAD_BALANCE=OFF):

--//重复测试:

$ strace -tT -f tnsping client_con 2>&1 | grep -E 'connect'

09:01:46 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("10.10.10.10")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000050>

09:01:49 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("11.11.11.11")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000042>

09:01:52 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("12.12.12.12")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000042>

09:01:55 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("13.13.13.13")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000043>

09:01:58 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("14.14.14.14")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000044>

09:02:01 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("15.15.15.15")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000042>


09:02:04 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("10.10.10.10")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000042>

09:02:07 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("11.11.11.11")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000046>

09:02:10 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("12.12.12.12")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000036>

09:02:13 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("13.13.13.13")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000034>

09:02:16 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("14.14.14.14")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000036>

09:02:19 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("15.15.15.15")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000038>


09:02:22 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("10.10.10.10")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000037>

09:02:25 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("11.11.11.11")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000038>

09:02:28 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("12.12.12.12")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000037>

09:02:31 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("13.13.13.13")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000038>

09:02:34 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("14.14.14.14")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000037>

09:02:37 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("15.15.15.15")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000037>


--//可以发现尝试顺便选择的IP是定义的顺序.


4.取消TRANSPORT_CONNECT_TIMEOUT设置:

$ cat tnsnames.ora

CLIENT_CON =

 (DESCRIPTION =

  (LOAD_BALANCE=OFF)

   (RETRY_COUNT=1)

   (ADDRESS = (PROTOCOL = TCP)(HOST =10.10.10.10)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =11.11.11.11)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =12.12.12.12)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =13.13.13.13)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =14.14.14.14)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =15.15.15.15)(PORT = 1522))

  (CONNECT_DATA =

     (SERVER = DEDICATED)

     (SERVICE_NAME = orclgg)

   ))



$ strace -tT -f tnsping client_con 2>&1 | grep -E 'connect'

09:05:53 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("10.10.10.10")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000052>

09:06:53 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("11.11.11.11")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000045>

09:07:53 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("12.12.12.12")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000047>

09:08:53 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("13.13.13.13")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000057>

09:09:53 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("14.14.14.14")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000057>

09:10:53 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("15.15.15.15")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000067>


09:11:53 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("10.10.10.10")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000056>

09:12:53 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("11.11.11.11")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000051>

09:13:53 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("12.12.12.12")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000042>

09:14:54 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("13.13.13.13")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000043>

09:15:54 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("14.14.14.14")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000045>

09:16:54 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("15.15.15.15")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000043>


--//可以发现间隔是60秒,也就是缺省TRANSPORT_CONNECT_TIMEOUT=60.


4.取消RETRY_COUNT设置:

$ cat tnsnames.ora

CLIENT_CON =

 (DESCRIPTION =

  (LOAD_BALANCE=OFF)

   (TRANSPORT_CONNECT_TIMEOUT=1)

   (ADDRESS = (PROTOCOL = TCP)(HOST =10.10.10.10)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =11.11.11.11)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =12.12.12.12)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =13.13.13.13)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =14.14.14.14)(PORT = 1522))

   (ADDRESS = (PROTOCOL = TCP)(HOST =15.15.15.15)(PORT = 1522))

  (CONNECT_DATA =

     (SERVER = DEDICATED)

     (SERVICE_NAME = orclgg)

   ))


$ strace -tT -f tnsping client_con 2>&1 | grep  'connect'

09:20:05 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("10.10.10.10")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000047>

09:20:06 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("11.11.11.11")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000041>

09:20:07 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("12.12.12.12")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000050>

09:20:08 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("13.13.13.13")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000042>

09:20:09 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("14.14.14.14")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000043>

09:20:10 connect(4, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("15.15.15.15")}, 16) = -1 EINPROGRESS (Operation now in progress) <0.000042>


--//缺省RETRY_COUNT=0.


来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-2638329/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267265/viewspace-2638329/

cuixun7780
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
一个典型的Haproxy_exporter的监控metric例子.txt
07-17
haproxy_backend_http_connect_time_average_seconds haproxy_backend_http_queue_time_average_seconds haproxy_backend_http_response_time_average_seconds haproxy_backend_http_responses_compressed_total ...
oracle tcp timeout,Oracle11gr2网络配置新增TRANSPORT_CONNECT_TIMEOUT参数
weixin_34551601的博客
04-03 511
在11.2中，TNSNAMES.ORA中的配置新增了TRANSPORT_CONNECT_TIMEOUT参数。有的时候配置TNSNAMES.ORA出错在所难免，而等待超时失败的时候十分痛苦，这一分钟的TCP超时会显得很漫长，尤其是WINDOWS环境下的SQLPLUSW工具，在这一分种内完全没有任何的响应。现在11.2允许用户配置TNSNAMES.ORA的时候指定TRANSPORT_CONNECT_T...
oracle 增加tns,Oracle11gr2的tnsnam.ora新增TRANSPORT_CONNECT_TIMEOUT参
weixin_34161139的博客
04-04 347
在11.2中，TNSNAMES.ORA中的配置新增了TRANSPORT_CONNECT_TIMEOUT参数。有的时候配置TNSNAMES.ORA出错在所难免，而等待超时失败的时候十分痛苦，这一分钟的TCP超时会显得很漫长，尤其是WINDOWS环境下的SQLPLUSW工具，在这一分种内完全没有任何的响应。现在11.2允许用户配置TNSNAMES.ORA的时候指定TRANSPORT_CONNECT_T...
Oracle11gr2网络配置新增TRANSPORT_CONNECT_TIMEOUT参数
ckawt40802的专栏
05-16 425
在11.2中，TNSNAMES.ORA中的配置新增了TRANSPORT_CONNECT_TIMEOUT参数。 有的时候配置TNSNAMES.ORA出错在所难免，而等待超时失败的时候十分痛苦，这一分钟的TCP超时...
rac一节点时间比另一个节点快_解决高可用的最后一公里，保障业务的连续性
weixin_39657825的博客
11-23 336
我们知道，数据库是数据的载体，系统中所有的信息最终都要汇集到数据库进行存储和交换，那么数据库的重要性当然是不言而喻的。一旦由于网络中断，存储故障，或者服务器故障而导致数据库出现故障，必将会对客户造成业务中断、客户流失、生产力损失，以及其他不可估量的影响。有时，我们需要进行安装数据库安全补丁、维护数据库服务器等操作。因为这些操作可能会造成业务中断，所以一般都放在周末或晚上才做。加班的人员会...
php connecttimeout,tcp会偶尔3秒timeout的分析以及如何用php规避这个问题
weixin_40004081的博客
03-18 393
2年前做一个cache中间件调用的时候，发现很多通过php的curl调用一个的服务会出现偶尔的connect_time超时, 表现为get_curlinfo的connect_time在3秒左右, 本来没怎么注意, 因为客户端的curl_timeout设置的就是3秒, 某天, 我把这个timeout改到了5秒后, 发现了一2年前做一个cache中间件调用的时候，发现很多通过php的curl调用一个的...
yj.rar_a fresh copy_fresh cop_fresh copy
09-19
描述 "vfsome installation files are corrupt a fresh copy and retry the installtion" 明确指出安装过程中遇到了损坏的文件，建议获取一个全新的副本并重试安装过程。 在IT行业中，遇到此类问题通常是由于下载...
fsys.rar_The Process
09-19
Finalizes DPLL registration process. In case a failure (clk-ref or clk-bypass is missing), the clock is added to retry list and the initialization is retried on later stage.
01 SIM7600CE_TCP透传模式示例.zip
08-11
- **Timeout**：连接超时时间，用于控制连接尝试的时间。 - **Retry Times**：连接失败后的重试次数。 理解并实现SIM7600CE的TCP透传模式，对于开发物联网设备、远程监控系统、数据采集应用等有着重要的实践意义。...
LINUX下的DNS服务器设置.rar_dns _dns linux_linux_linux DNS_linux 服务器
09-23
在Linux系统中，DNS（Domain Name System）服务器是网络服务中的关键组件，它负责将域名转换为IP地址，使得用户可以方便地通过域名访问互联网资源。这篇教程将深入讲解如何在Linux环境下设置DNS服务器，包括基本概念...
PyPI 官网下载 | aiohttp_retry-2.3.2-py3-none-any.whl
01-04
资源来自pypi官网。 资源全名：aiohttp_retry-2.3.2-py3-none-any.whl
exec-retry:具有重试功能的child_process.exec
05-14
$ npm install exec-retry --save 用法 const exec = require ( 'exec-retry' ) ; exec ( 'curl https://www.roqet.io' , function ( err , stdout , stderr ) { // done! } ) ; // now set max retries ...
树莓派上使用DHT11温湿度传感器详细教程.rar_DHT11_树莓派_树莓派 DHT11_树莓派 传感器_树莓派DHT11
09-21
在本文中，我们将深入探讨如何在树莓派上使用DHT11温湿度传感器进行数据采集和处理。DHT11是一款经济实惠、易于使用的数字传感器，能够提供相对湿度和温度的读数，广泛应用于智能家居、环境监测等领域。在树莓派这样...
MySQL和连接相关的timeout 的详细整理
09-09
重试间隔由`MASTER_CONNECT_RETRY`选项控制，而重试次数由`--master-retry-count`选项限制。 2. `net_read_timeout`: 此参数定义了MySQL服务器在读取客户端发送的数据时等待的最长时间。如果在这个时间内没有接收到...
dio_retry:重试dio的拦截器
05-02
import 'package:dio_retry/dio_retry.dart'; final dio = Dio(); dio.interceptors.add(RetryInterceptor()); ``` ### 重试策略配置 `dio_retry`提供了多种重试策略，包括基于错误类型、HTTP状态码或自定义条件的...
Oracle19c PDB级别Failover 出错场景测试
In-Memory Computing Technology
01-18 1175
首先抛出观点，对于客户端连接，也就是应用程序使用的连接，不要用默认的服务。 原文出处为Real Application Clusters Administration and Deployment Guide： All of these services are used for internal management. You cannot stop or disable any of these internal services to do planned outages or to failove
INBOUND_CONNECT_TIMEOUT与SQLNET.INBOUND_CONNECT_TIMEOUT小结
weixin_34087307的博客
02-28 217
   关于sqlnet.ora的参数SQLNET.INBOUND_CONNECT_TIMEOUT，它表示等待用户认证超时的时间，单位是秒，缺省值是60秒，如果用户认证超时了，服务器日志alert.log显示出错信息"WARNING: inbound connection timed out (ORA-3136)"，sqlnet.log里面出现TNS-12535: TNS:operation tim...
slave_net_timeout, MASTER_HEARTBEAT_PERIOD, MASTER_CONNECT_RETRY,以及 MASTER_RETRY_COUNT设置和查看
翔云
02-27 2855
在主从复制中，有几个参数是非常重要的，包括slave_net_timeout, MASTER_HEARTBEAT_PERIOD, MASTER_CONNECT_RETRY,以及 MASTER_RETRY_COUNT。 slave_net_timeout表示slave在slave_net_timeout时间之内没有收到master的任何数据(包括binlog，heartbeat)，slave认为...
Oracle的连接超时的解决方法
热门推荐
LWL_IT_Home的专栏
08-29 2万+
如果你连接的是自己本机的oracle: 1、 在cmd命令行中尝试：ping  本机IP地址； 2、 确保关闭防火墙 3、 数据库监听程序启动 4、 当然，也不排除缓存问题，所以需要对项目工程build project – clean 对工程的进一步清楚缓存问题，问题解决；   如果你连接的是他人笔记本中的oracle: 1、 要确保能够ping通对方的IP地址（要确保是在同一个局域
oracle的78.175.initial_retry_timeout
最新发布
05-26
`initial_retry_timeout`是Oracle数据库中的一个参数，它表示在重试数据库连接时的初始等待时间。当数据库连接失败时，会根据该参数设定的时间间隔进行重试，如果连接仍然失败，则会按照指定的算法逐步增加重试时间间隔。 具体来说，`initial_retry_timeout`参数的单位是秒，它的默认值为5秒。如果需要调整该参数，可以使用以下语句： ```sql ALTER SYSTEM SET initial_retry_timeout = <value>; ``` 其中，`<value>`表示新的参数值，可以是整数或浮点数。需要注意的是，修改该参数可能会对数据库性能产生影响，应该谨慎调整。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值